| 数据仓库中基于实体化辅助视图的视图增量维护 |
| |
| 引用本文： | 胡孔法,董逸生,赵庆建.数据仓库中基于实体化辅助视图的视图增量维护[J].小型微型计算机系统,2003,24(2):251-254. |
| |
| 作者姓名： | 胡孔法 董逸生 赵庆建 |
| |
| 作者单位： | 1. 东南大学,计算机科学与工程系,江苏,南京,210096
2. 东南大学,经济管理学院,江苏,南京,210096 |
| |
| 基金项目： | 国家 8 63/CIMS项目基金 ( No.640 90 0 2 0 12 )资助，江苏省“九五”重点攻关课题资助 ( No.BG980 1)，江苏“十五”高科技项目 ( No:BG2 0 0 10 13)资助 |
| |
| 摘 要： | 为了加快对大量数据的查询处理速度，通常在数据仓库以实视图方式存储数据，当基础数据发生变化时，这些实视图也必须随着更新，因而视图自维护和一致性维护成为数据仓库的重要问题。本文提出利用视图计算的中间结果创建辅助视图，在数据仓库中进行实体化，采用有效的增量维护算法计算实视图的精确变化，实现数据仓库视图自维护。
|
| 关 键 词： | 数据仓库 实体化辅助视图 视图增量维护 增量维护算法 数据源 数据库 |
| 文章编号： | 1000-1220(2003)02-0251-04 |
Incremental Maintenance of View Based on Auxiliary Views i n Data Warehouse |
| |
| HU Kong-fa ,DONG Yi-sheng ,ZHAO Qing-jian.Incremental Maintenance of View Based on Auxiliary Views i n Data Warehouse[J].Mini-micro Systems,2003,24(2):251-254. |
| |
| Authors: | HU Kong-fa DONG Yi-sheng ZHAO Qing-jian |
| |
| Affiliation: | HU Kong-fa 1,DONG Yi-sheng 1,ZHAO Qing-jian 2 1 |
| |
| Abstract: | We often store data in the warehouse as materialized views in order to speedup query processing on large amounts of data. These views need to be maintained in response to update in the source data. The issue of self-maintainability and consistency of the view is an important issue in data warehousing. In the paper we show that the warehouse views can be made self-maintainable with the auxiliary views , which derived from the intermediate results of the view computation can be materialized in the warehouse. Then proposed an efficient incremental maintenance algorithm that computes the exact updates to both the materialized view and auxiliary views. |
| |
| Keywords: | data warehouse materialized view auxiliary view view self-maintainability incremental maintenance algorithm |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
