[1]胡孔法,董逸生,徐立臻.基于维层次的压缩Cube[J].东南大学学报(自然科学版),2004,34(5):599-603.[doi:10.3969/j.issn.1001-0505.2004.05.009]
 Hu Kongfa,Dong Yisheng,Xu Lizheng.Compressed cube based on dimension hierarchy[J].Journal of Southeast University (Natural Science Edition),2004,34(5):599-603.[doi:10.3969/j.issn.1001-0505.2004.05.009]
点击复制

基于维层次的压缩Cube()
分享到:

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

卷:
34
期数:
2004年第5期
页码:
599-603
栏目:
计算机科学与工程
出版日期:
2004-09-20

文章信息/Info

Title:
Compressed cube based on dimension hierarchy
作者:
胡孔法12 董逸生2 徐立臻2
1 扬州大学计算机科学与工程系, 扬州 225009; 2 东南大学计算机科学与工程系, 南京 210096
Author(s):
Hu Kongfa12 Dong Yisheng2 Xu Lizheng2
1 Department of Computer Science and Enginnering, Yangzhou University, Yangzhou 225009, China
2 Department of Computer Science and Engineering, Southeast University, Nanjing 210096, China
关键词:
维层次 DH-Cube 多维数据仓库 增量更新
Keywords:
dimension hierarchy dimension hierarchy cube multidimensional data warehouse incremental update
分类号:
TP311
DOI:
10.3969/j.issn.1001-0505.2004.05.009
摘要:
提出利用Cube中的维层次来创建高性能的DH-Cube(dimension hierarchy cube),在DH-Cube中存储构成Cube的所有维的所有层次粒度组成的数据单元,从而实现了在1个DH-Cube中就可以存储构成该Cube的d个维所创建的2d个立方体视图的所有信息,从而压缩Cube存储空间,提高MOLAP查询效率,减少Cube创建时间和更新时间.
Abstract:
A high performance DH-Cube(dimension hierarchy cube)with the dimension hierarchy on the cube is presented. The DH-Cube stores all data cells constructed by all granularities of all dimensions on the cube. The DH-Cube can contain the information of 2d(d is the number of dimensions)data cube view created by d dimensions of the cube. Thereby it compresses the storage space, improves the efficiency of MOLAP(multidimensional on-line analysis process)queries, and reduces the creation time and update time of the cube.

参考文献/References:

[1] Gray J,Bosworth A,Layman A,et al.Data cube:a relational aggregation operator generalizing group-by,cross-tab,and sub-totals [A].In:Kitsuregawa M,ed. Proceedings of the 12th International Conference on Data Engineering [C].New Orleans:IEEE Computer Society,1996.152-159.
[2] Chan C Y,Ioannidis Y E.Hierarchical cubes for range-sum queries[A].In:Atkinson M P,Orlowska M E,Valduriez P,eds.Proceedings of 25th International Conference on Very Large Databases [C].Edinburgh:Morgan Kaufmann Publishers,1999.675-686.
[3] Mistry H,Roy P,Sudarshan S,et al.Materialized view selection and maintenance using multi-query optimization [A].In:Aref W G,ed.Proceedings of the ACM SIGMOD 2001 [C].Santa Barbara:ACM Press,2001.307-318.
[4] Geffner S,Agrawal D,Abbadi A E1.The dynamic data cubes [A].In:Zaniolo C,ed. Proceedings of the 7th International Conference on Extending Database Technology [C].Konstanz,2000.237-253.
[5] Kotidis Y,Roussopoulos N.An alternative storage organization for ROLAP aggregate views based on cubetrees [A].In:Haas L M,Tiwary A,eds.Proceedings of the ACM SIGMOD International Conference on Management of Data [C].Washington:ACM Press,1998.249-258.
[6] Li Jian-zhong,Srivastava J.Efficient aggregation algorithms for compressed data warehouses [J].IEEE Transactions on Knowledge and Data Engineering, 2002,14(3):515-529.
[7] 胡孔法,宋爱波,董逸生,等.数据仓库中实视图聚集函数的增量更新 [J].东南大学学报(自然科学版),2002,32(1):11-14.
  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.(in Chinese)

备注/Memo

备注/Memo:
基金项目: 江苏省“九五”重点攻关资助项目(BG98017-1)、江苏省“十五”高科技资助项目(BG2001013).
作者简介: 胡孔法(1970—),男, 博士生; 董逸生(联系人),男, 教授,博士生导师,ysdong@seu.edu.cn.
更新日期/Last Update: 2004-09-20