基于时间戳的实化视图多版本维护

实化视图的一致性维护是数据仓库联机维护的关键问题.本文分析了基于三层数据仓库体系结构的3VWQ算法中潜在不一致性的原因,给出了三层结构的改进方法并引入时间戳作为中间版本实化视图的一致性维护标记;提出一种基于时间戳的补偿算法,实现了增量查询维护过程中不一致更新的本地补偿,从而在保证较好性能的同时解决了维护查询过程中的一致性问题.

Timestamp-Based Materialized View Maintenance with Multi-Version Control

The possible reasons,which cause the anomalies in the 3VWQ algorithm used in the three-tier data warehousing architecture to maintain materialized view consistency,are discussed.Timestamp is introduced to denote the consistency earmark in updating the next version materialized view. An improvement approach is proposed for the three-tier architecture. A novel compensation approach which is based on timestamp and implements the local compensation for inconsistent updating in incremental query maintenance is also proposed in order to solve the problem of inconsistency of the process.