| 视图增量的同步计算方法 |
| |
| 引用本文： | 杜威,邹先霞. 视图增量的同步计算方法[J]. 小型微型计算机系统, 2011, 32(12) |
| |
| 作者姓名： | 杜威 邹先霞 |
| |
| 作者单位： | 1. 广东警官学院计算机系,广州,510232
2. 暨南大学计算机系,广州,510632 |
| |
| 基金项目： | 2008公安部应用创新计划项目(2008YYCXGDST081)资助; 2009广东警官学院科研基金项目(2009-Y09)资助 |
| |
| 摘 要： | 为有效降低视图增量计算的代价,提出了净化操作和主外码约束的优化同步计算方法.数据源基表的更新操作可能对同一元组多次反复的修改,而在视图增量的维护中并不需要反映基表的整个更新过程,而只是维护某个时间的状态一致,因而利用净化操作减少了计算的数据量.数据源基表间的主外码约束使得部分增量子查询的结果为空,减少这样的增量子查询提高了计算的效率.实验分析表明优化后的同步计算方法有效地降低了计算和维护代价.
|
| 关 键 词： | 实化视图 同步计算 净变化量 主外码约束 |
Synchronous Algorithm of Computing View Increment |
| |
| DU Wei , ZOU Xian-xia. Synchronous Algorithm of Computing View Increment[J]. Mini-micro Systems, 2011, 32(12) |
| |
| Authors: | DU Wei ZOU Xian-xia |
| |
| Affiliation: | DU Wei1,ZOU Xian-xia2 1(Department of Computer Science,Gongdong Police College,Guangzhou 510232,China) 2(Department of Computer Science,Jinan University,Guangzhou 510632,China) |
| |
| Abstract: | In order to reduce effectively the cost of view increment computation,we proposed the algorithm of synchronous computation which is optimized by the net change of increment and primary-foreign key constraints.Some tuples of base table in data source are modified over and over again,but the whole change process is not needed to reflect in the materialized views.So the net change can reduce the amount of data to calculate.And some increment sub-query of materialized views is empty because of the primary-forei... |
| |
| Keywords: | materialized view synchronous computation the net change of increment primary-foreign key constraints |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
