摘要
实化视图的一致性维护是数据仓库联机维护的关键问题。本文分析了基于三层数据仓库体系结构的3VWQ算法中潜在不一致性的原因,给出了三层结构的改进方法并引入时间戳作为中间版本实化视图的一致性维护标记;提出一种基于时间戳的补偿算法,实现了增量查询维护过程中不一致更新的本地补偿,从而在保证较好性能的同时解决了维护查询过程中的一致性问题。
The possible reasons, which cause the anomalies in the 3 VWQ 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 timestarap 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
出处
《计算机工程与科学》
CSCD
2006年第7期53-56,64,共5页
Computer Engineering & Science
关键词
数据仓库
联机维护
时间戳
实化视图
data warehousing orrline maintenance timestamp materialized view
