• 中国计算机学会会刊
  • 中国科技核心期刊
  • 中文核心期刊

J4 ›› 2006, Vol. 28 ›› Issue (7): 53-56.

• 论文 • 上一篇    下一篇

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

卢炎生 岳沛   

  • 出版日期:2006-07-01 发布日期:2010-05-20

  • Online:2006-07-01 Published:2010-05-20

摘要:

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

关键词: 数据仓库 联机维护 时间戳 实化视图

Abstract:

The possible reasons, which cause the anomalies in the 3 VWQ algorithm used in the three-tier data warehousing architecture to maintain materialized v iew 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 f or inconsistent updating in incremental query maintenance is also proposed in order to solve the problem of inconsistency of the process

Key words: data warehousing orrline maintenance timestamp materialized view