[1]胡孔法,宋爱波,董逸生,等.数据仓库中实视图聚集函数的增量更新[J].东南大学学报(自然科学版),2002,32(1):11-14.[doi:10.3969/j.issn.1001-0505.2002.01.003]
 Hu Kongfa,Song Aibo,Dong Yisheng,et al.Incremental updates of aggregate functions of materialized view in the data warehouse[J].Journal of Southeast University (Natural Science Edition),2002,32(1):11-14.[doi:10.3969/j.issn.1001-0505.2002.01.003]
点击复制

数据仓库中实视图聚集函数的增量更新()
分享到:

《东南大学学报(自然科学版)》[ISSN:1001-0505/CN:32-1178/N]

卷:
32
期数:
2002年第1期
页码:
11-14
栏目:
计算机科学与工程
出版日期:
2002-01-20

文章信息/Info

Title:
Incremental updates of aggregate functions of materialized view in the data warehouse
作者:
胡孔法1 宋爱波1 董逸生1 赵庆建2
1 东南大学计算机科学与工程系,南京 210096; 2 河海大学信息管理系,常州 213022
Author(s):
Hu Kongfa1 Song Aibo1 Dong Yisheng1 Zhao Qingjian2
1 Department of Computer Science and Engineering, Southeast University, Nanjing 210096, China
2 Department of Information Management, Hohai University, Changzhou 213022, China
关键词:
数据仓库 联机分析处理 聚集函数 增量更新算法
Keywords:
data warehouse on-line analytical processing aggregate functions incremental updates algorithm
分类号:
TP311
DOI:
10.3969/j.issn.1001-0505.2002.01.003
摘要:
提出在视图表达式树中以由下到上的方式计算中间结点的变化,将计算出的中间结果作为辅助视图保存在数据仓库中,利用这些辅助视图或子视图计算出来的聚集函数的变化,来计算本视图聚集函数值的更新,实现视图的增量维护,从而缩短数据仓库更新维护时间,提高OLAP查询效率.同时,介绍了实视图中聚集函数的增量更新算法,实现实视图聚集函数的更新维护.
Abstract:
This paper proposes a method to compute the changes of each intermediate node in a bottom-up fashion in the view expression tree and store the data as auxiliary view in the data warehouse. By computing the updates of the aggregate functions with these auxiliary view or child view, we can compute the updates to the aggregate function of the view and implement the view incremental maintenance.Thus the maintainable time of updating the data warehouse can be reduced and the efficiency of the OLAP queries improved. The authors also propose a maintainable and incremental update algorithm to make aggregate functions on materialized views maintained.

参考文献/References:

[1] 王能斌.数据库系统原理[M].北京:电子工业出版社,2000.310-330.
  Wang Nengbin.Principles of database systems [M].Beijing:Publishing House of Electronics Industry,2000.310-330.(in Chinese)
   [2] Hull R,Zhou G.A framework for supporting data integration using the materialized and virtual approaches [A].In:Proceedings of the ACM SIGMOD Conference on Management of Data [C].Montreal,1996.481-492.
[3] Agrawal D,Abbadi A,Singh A,et al.Efficient view maintenance at data warehouses [A].In:Proceedings of the ACM SIGMOD Conference on Management of Data [C].Tucson,Arizona,1997.417-427.
[4] Dallan Q.Making views self-maintainable for data warehousing [A].In:Proceedings of International Conference on Parallel and Database Information Systems [C].Miami Beach,1996.158-169.
[5] Ross K A,Srivastava D,Sudarshan S.Materialized view maintenance and integrity constraint checking[A].In:Proceeding of the ACM SIGMOD International Conference on Management of Data [C].Montreal,1996.447-458.
[6] Jaedicke M,Mitschang B.On parallel processing of aggregate and scalar functions in object-rational DBMS [A].In:Proceedings of ACM SIDMOD International Conference on Management of Data [C].1998.379-389.http://www3.informatik.tu-muenchen.de/public/projekte/sfb342/publications/.2001-03-20.
[7] Colby L,Kawaguchi A,Lieuwen D,et al.Supporting multiple view maintenance policies [A].In: Proceedings of the ACM SIGMOD Conference on Management of Data [C].Tucson,Arizona,1997.405-416.
[8] Bailay J,Dong G,Mohania M,et al.Distributed view maintenance by incremental semijion and tagging [J].Distributed and Parallel Databases,1998,6(3):287-309.
[9] Huyn N.Multiple view self-maintenance in data warehousing environments [A].In:Proceedings of the 23rd International Conference on Very Large Database [C].Athens,1997.26-35.
[10] Liang W,Wang H,Orlowska M E,et al.Making multiple views self-maintainable in a data warehouse [J].Data & Knowledge Engineering,1999(30):121-134.

相似文献/References:

[1]谈晓洁,周晶,盛昭瀚.基于数据仓库的城市交通拥堵疏导数据管理[J].东南大学学报(自然科学版),2003,33(1):102.[doi:10.3969/j.issn.1001-0505.2003.01.026]
 Tan Xiaojie,Zhou Jing,Sheng Zhaohan.Data warehouse based data repository for urban traffic congestion management[J].Journal of Southeast University (Natural Science Edition),2003,33(1):102.[doi:10.3969/j.issn.1001-0505.2003.01.026]
[2]胡孔法,董逸生,徐立臻,等.基于OLAP查询的数据集市系统的研究[J].东南大学学报(自然科学版),2002,32(6):875.[doi:10.3969/j.issn.1001-0505.2002.06.011]
 Hu Kongfa,Dong Yisheng,Xu Lizhen,et al.Research on data mart system based on OLAP queries[J].Journal of Southeast University (Natural Science Edition),2002,32(1):875.[doi:10.3969/j.issn.1001-0505.2002.06.011]
[3]杨科华,胡孔法.基于维层次性的Data Cube存储优化方法[J].东南大学学报(自然科学版),2005,35(4):524.[doi:10.3969/j.issn.1001-0505.2005.04.006]
 Yang Kehua,Hu Kongfa.Storage optimization method of Data Cube based on hierarchy of dimension[J].Journal of Southeast University (Natural Science Edition),2005,35(1):524.[doi:10.3969/j.issn.1001-0505.2005.04.006]
[4]胡孔法,董逸生,陈崚.数据仓库中一种基于维层次编码的位图索引方法[J].东南大学学报(自然科学版),2005,35(2):171.[doi:10.3969/j.issn.1001-0505.2005.02.002]
 Hu Kongfa,Dong Yisheng,Chen Ling.Bitmap index based on dimension hierarchical encoding in data warehouse[J].Journal of Southeast University (Natural Science Edition),2005,35(1):171.[doi:10.3969/j.issn.1001-0505.2005.02.002]

备注/Memo

备注/Memo:
基金项目: 江苏省“九五”重点攻关课题资助项目(BG98017-1).
作者简介: 胡孔法(1970—), 男, 博士生; 董逸生(联系人), 男, 教授, 博士生导师.
更新日期/Last Update: 2002-01-20