数据仓库的联机维护与下查

提出了一种三层数据仓库体系结构，引入了“数据仓库基库”概念，不权使得传统数据库能够更容易地融入数据仓库系统，而且增强了整个系统的伸缩性。在此基础上，提出了３ＶＷＱ（Ｔｈｒｅｅ－Ｖｅｒｓｉｏｎ Ｗｉｔｈｏｕｔ Ｑｕｉｅｓｃｉｎｇ）算法来解决数据仓库的联机维护问题及其对下查的支持。该算法采用版本控制和补偿思想来协调数据库和数据仓库之间的数据更新，从而保证了联机维护与下查的一致性。

ON-LINE MAINTENANCE AND DRILL-DOWN IN DATA WAREHOUSE

This paper proposes a new three tier Data Warehousing architecture, Data Warehouse Base, through which the legacy database systems can be easily integrated into Data Warehousing system and enhances the scalability of Data Warehousing system. Then this paper introduces a new algorithm 3VWQ (three version without quiescing) under the architecture to support on line maintenance and drill down query in Data Warehouse environment. It uses version control and compensating mechanisms to synchronize the data refreshments between Database and Data Warehouse so as to ensure the consistency of on line maintenance and drill down query.