首页 | 本学科首页   官方微博 | 高级检索  
     

基于模式和数据并发更新的视图维护机制
引用本文:舒忠梅,李师贤,左亚尧,周晓聪.基于模式和数据并发更新的视图维护机制[J].小型微型计算机系统,2006,27(10):1871-1878.
作者姓名:舒忠梅  李师贤  左亚尧  周晓聪
作者单位:1. 中山大学,计算机科学系,广东,广州,510275
2. 中山大学,计算机科学系,广东,广州,510275;广东工业大学,计算机学院,广东,广州,510090
基金项目:国家自然科学基金;广东省自然科学基金;广东省科技计划工业攻关基金
摘    要:在数据仓库的实化视图维护处理中,如何有效地处理并发更新是一个重要而又棘手的问题.文中阐述了P2P环境下模式与数据全面并发的典型情形,分析了因并发更新而导致视图维护异常的原因,针对这些不同的方面提出相应的纠正策略.给出了一种基于时态演算的并发更新侦测方法,以及混合更新下对关联更新进行检测的有效算法,最后提出了解决乱序提交问题的增强代理机制,确保了数据仓库与数据源的一致性.

关 键 词:并发更新  关联更新  时态纠正
文章编号:1000-1220(2006)10-1871-08
收稿时间:06 27 2005 12:00AM
修稿时间:2005-06-27

Mechanism for View Maintenance Under Schema and Data Concurrent Updates
SHU Zhong-mei,LI Shi-xian,ZUO Ya-yao,ZHOU Xiao-cong.Mechanism for View Maintenance Under Schema and Data Concurrent Updates[J].Mini-micro Systems,2006,27(10):1871-1878.
Authors:SHU Zhong-mei  LI Shi-xian  ZUO Ya-yao  ZHOU Xiao-cong
Affiliation:1.Department of Computer Science, Sun Yat-sen University, GuangZhou, 510275, China;2.Faculty of Computer, GuangDong University of Technology, GuangZhou, 510090, China
Abstract:During maintaining the materialized view in the data warehouse, how to efficiently handle the concurrent updates is an important and intractable problem. The paper discusses typical situations that scheme change mixes with data updates concurrently. And the reasons why concurrent updates result in view maintenance anomy are analyzed. Based on the different situations, the corresponding correct strategy is presented. Furthermore, the paper proposes the temporal methods for detecting concurrent updates and related updates under mixing scheme change and data updates. Lastly, an enhanced commit agent is designed for deal with non-orderly commit problem. Thus, the consistency between data warehouse and data source is guaranteed.
Keywords:concurrent update  related update  temporal correct
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号