共享多版本源视图的多实化视图异步增量维护  

Asynchronous incremental maintenance of multiple materialized views over shared multi-version source views

作　　者：张晓刚[1,2] 杨路明[1] 潘久辉[2] 

机构地区：[1]中南大学信息科学与工程学院,湖南长沙410083 [2]暨南大学计算机系,广东广州510632

出　　处：《华中科技大学学报（自然科学版）》2013年第3期52-56,共5页Journal of Huazhong University of Science and Technology(Natural Science Edition)

基　　金：教育部广东省产学研项目(2007B090400095);广东省科技计划资助项目(2010B010600026)

摘　　要：为了解决补偿和多版本在多实化视图维护上性能不理想的问题,提出了共享多版本源视图的多实化视图异步增量维护方案SMVM(源多版本视图维护).在SMVM中,集成端的实化视图直接定义在多个数据源的共享引用多版本源视图上,并且在收到源视图的数据更新后,向其他相关数据源发送基于版本的维护查询,以此来进行多实化视图的异步增量维护.这样在完全避免数据源并发更新导致增量查询异常的同时,提高了多个实化视图异步增量维护的整体性能,且基于元组标志的视图增量补偿方法使得对源视图的维护更有效.实验结果验证了SMVM的可行性和有效性.To resolve the problem of the inferior performance of multiple materialized views maintenance through the current compensation and multi-version methods, a novel asynchronous multiple materialized view maintenance schema SMVM （source muhi-version view maintenance） based on shared multi-version source view was proposed. In SMVM, materialized views in data integration site could straightway define on share-cited multi-version source views of multiple data sources, and send view maintenace query based on version to the other related data sources after received the data updates of source view for asynchronous incremental maintance of multiple materialized views. It not only avoided incremental query anomalies due to concurrent updates of data source but also improved the efficiency of asynchronous incremental maintenance of multiple materialized views. Furthermore, the compensation method of view increment utilizing the tuple-identifier made maintenance of source views more effective. Finally, experimental results demonstrated the feasibility and validity of SMVM sufficiently.

关 键 词：多实化视图 异步 增量维护 源视图 多版本 共享 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]