Browse > Article

Overlapped-Subcube: A Lossless Compression Method for Prefix-Sun Cubes  

강흠근 (한국과학기술원 전산학과)
민준기 (한국과학기술원 전산학과)
전석주 (안산1대학 인터넷정보과)
정진완 (한국과학기술원 전산학과)
Publication Information
Journal of KIISE:Databases / v.30, no.6, 2003 , pp. 553-560 More about this Journal
Abstract
A range-sum query is very popular and becomes important in finding trends and in discovering relationships between attributes in diverse database applications. It sums over the selected cells of an OLAP data cube where target cells are decided by specified query ranges. The direct method to access the data cube itself forces too many cells to be accessed, therefore it incurs severe overheads. The prefix-sum cube was proposed for the efficient processing of range-sum queries in OLAP environments. However, the prefix-sum cube has been criticized due to its space requirement. In this paper, we propose a lossless compression method called the overlapped-subcube that is developed for the purpose of compressing prefix-sum cubes. A distinguished feature of the overlapped-subcube is that searches can be done without decompressing. The overlapped-subcube reduces the space requirement for storing prefix-sum cubes, and improves the query performance.
Keywords
OLAP; range-sum query; compression method; prefix-sum cube;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Space-Efficient Data Cubes for Dynamic Environments /
[ M.Riedewald;D.Agrawal;A.E.Abbadi;R.Pajarola ] / In Proceedings of the second International Conference on DaWak
2 R. Agrawal, A. Gupta, S. Sarawagi, 'Modeling Multidimensional Databases,' In Proceedings of the 13th International Conference on Data Engineering, pages 232-243, 1997
3 E.F. Codd, S.B. Codd, and C.T. Salley, 'Providing OLAP (n-Iine analytical processing) to user-analysts: An IT mandate,' Technical report, 1993
4 Ralph Kimball, The Data Warehousing ToolKit, John Wiley and Sons, 1996
5 T. Niemi, J. Nummenmaa, P. Thanisch, 'Functional Dependencies in Controlling Sparsity of OLAP Cubes,' In Proceedings of the second International Conference on DaWaK, pages 199-209, 2000
6 J. Li, D. Rotem, J. Srivastava, 'Aggregation Algorithms for Very Large Compressed Data Warehouses,' In Proceedings of the 25th International Conference on VLDB, pages 651-662, 1999
7 J. S. Vitter, M. Wang, 'Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets,' In Proceedings of ACM SIG-MOD, pages 193-204, 1999   DOI
8 S. J. Chun, C. W. Chung, J. H. Lee, S. L. Lee, 'Dynamic Update Cube for Range-Sum Queries,' In Proceedings of the 27th International Conference on VLDB, pages 521-530, 2001
9 S. Sarawagi, M. Stonebraker, 'Efficient Organization of Large Multi-Dimensional Arrays,' In Proceedings of the 10th International Conference on Data Engineering, pages 328-336, 1994   DOI
10 A. Shoshani, 'OLAF and Statistical Databases: Similarities and Differences,' In Proceedings of ACM PODS, pages 185-196, 1997   DOI
11 M. Riedewald, D. Agrawal, A. E. Abbadi, 'pCube: Update-Efficient Online Aggregation With Progressive Feedback and Error Bounds,' In Proceedings of the 12th International Conference on SSDBM, pages 95-108, 2000   DOI
12 S. Chaudhuri and U. Dayal, An Overview of Data Warehousing and OLAP Technology, SIGMOD Record, 26(1), 1997   DOI   ScienceOn
13 M. Gyssens and L.V.S. Lakshmanan, 'A foundation for multi-dimensional databases,' Proceedings of the 23th International Conference on VLDB, pages 106-115, 1997
14 J. Gray, A. Bosworth, A. Layman, and H. Pirahesh, 'Data Cube: A Relational Aggregation Operator Generalizing Group-by, Cross-Tab and Sub Totals,' In Proceedings of the 12th International Conference on Data Engineering, pages 152-159, 1996
15 J, S. Vitter, M. Wang, B. Lyer, 'Data Cube Approximation and Histograms via Wavelets,' In Proceedings of the 7th International Conference on Information and Knowledge Management, pages 96-104, 1998   DOI
16 Y. Zhao, K Ramasamy, K. Tufte, and J. F. Naughton, 'Array-Based Evaluation of Multi-Dimensional Queries in Object-Relational Database Systems,' In Proceedings of the 14th International Conference on Data Engineering, pages 241-249, 1998   DOI
17 M. Riedewald, D. Agrawal, A. E. Abbadi, R. Pajarola, 'Space-Efficient Data Cubes for Dynamic Environments,' In Proceedings of the second International Conference on DaWaK, pages 24-33, 2000
18 C. Ho, R. Agrawal, N. Megiddo, R. Srikant, 'Range Queries in OLAP Data Cubes,' In Proceedings of ACM SIGMOD, pages 73-88, 1997
19 C. Li and X.S. Wang, 'A data model for supporting on-line analytical processing,' In Proceedings of the 5th International Conference on Information and Knowledge Management, pages 81-88, 1996   DOI
20 BMC Software, Constructing a Data Warehouse, White Paper, www.bmc.com/products/documents/ 9322.pdf
21 Y. Kotidis, N. Roussopoulos, 'An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees,' Proceedings of ACM SIGMOD, pages 249-258, 1998   DOI