数据仓库的集合刷新维护算法

本文提出了一种版本控制集合刷新算法ＶＳＲＡ，它采用增量维护和批处理思想，首先根据原始数据的变化集合，计算出实体化视图的刷新集合，然后据此集合实体化视图，同时利用版本控制保持数据仓库与当前数据库状态的一致性，达到对数据仓库联机维护的目的。ＶＳＲＡ不但减少了数据仓库与数据库之间的通信开销，而且提高了实体化视
视图的刷新效率。严格的版本控制使用户可以随时使用数据仓库进行联机分析处理（ＯＬＡＰ），并得到正确一

A Set Refreshing Maintenance Algorithm for Data Warehouse

In this paper,we propose a new version control set refreshin g algorithm(VARA),which adopts the mechanisms of incremental maintenance,version control and batch processing to ensure on line mainte nance and consistency.VSRA uses set refreshing and batch processing mechanisms t hrough which not only the communication overhead between legacy database and dat a warehouse is reduced,but also the refreshing efficiency of materialized views is promoted.Users can perform on line analytical processing at any time and get correct results.