数据仓库预聚集增量更新的研究

Research on Pre-aggregation Incremental Update in Data Warehouse

数据仓库通常都包含预聚集。当数据源发生更新时,数据仓库及预聚集也必须随着更新。为了提高查询性能,重点探讨数据仓库预聚集更新问题,给出了预聚集更新的处理流程,并针对事实表更新及维表更新设计了相应的预聚集增量更新算法。

In order to improve query performance, data warehouse usually contains pre-aggregation. When data source updates, data warehouse and pre-aggregation also correspondingly update. This paper mainly studies pre-aggregation update question of data warehouse, and gives processing flow of pre-aggregation update. It also designs corresponding algorithms of pre-aggregation incremental update according to the fact table and dimension table update.