Range sum queries in dynamic OLAP data cubes

被引:2
|
作者
Li, HG [1 ]
Ling, TW [1 ]
Lee, SY [1 ]
Loh, ZX [1 ]
机构
[1] Natl Univ Singapore, Sch Comp, Singapore 117543, Singapore
关键词
D O I
10.1109/CODAS.2001.945152
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Range sum queries play an important role in analyzing data in data cubes. Many application domains require that data cubes should be updated quite often to provide real time information. Previous techniques for range sum queries, however, can incur an update cost of O(n(d)) in the worst case, where d is the number of dimensions of the data cube and n is the size of each dimension. To address this dynamic data cube problem, a technique called double relative prefix sum (DRPS), was proposed which achieves a query cost of O(n(1/3)) and an update cost of O(n(d/3)) in the worst case. The total cost of DRPS is the smallest compared with other techniques tinder two cost models. However, this technique causes considerable space overhead which is about n(d)+dn(d-1/3). While low query cost and update cost are critical for analysis in dynamic OLAP data cubes, growing data collections increase the demand for space-efficient approaches. So in this paper, we propose a new technique which promises the same query cost and update cost as DRPS while the additional space requirement is, only n(d).
引用
收藏
页码:74 / 81
页数:8
相关论文
共 50 条
  • [1] Range queries in dynamic OLAP data cubes
    Liang, WF
    Wang, H
    Orlowska, ME
    [J]. DATA & KNOWLEDGE ENGINEERING, 2000, 34 (01) : 21 - 38
  • [2] Space-efficient cubes for OLAP range-sum queries
    Chun, SJ
    Chung, CW
    Lee, SL
    [J]. DECISION SUPPORT SYSTEMS, 2004, 37 (01) : 83 - 102
  • [3] Partial-sum queries in OLAP data cubes using covering codes
    Ho, CT
    Bruck, J
    Agrawal, R
    [J]. IEEE TRANSACTIONS ON COMPUTERS, 1998, 47 (12) : 1326 - 1340
  • [4] Range top/bottom k queries in OLAP sparse data cubes
    Luo, ZW
    Ling, TW
    Ang, CH
    Lee, SY
    Cui, B
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, 2001, 2113 : 678 - 687
  • [5] Answering approximate range aggregate queries on OLAP data cubes with probabilistic guarantees
    Cuzzocrea, A
    Wang, W
    Matrangolo, U
    [J]. DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2004, 3181 : 97 - 107
  • [6] Hierarchical cubes for range-sum queries
    Chan, CY
    Ioannidis, YE
    [J]. PROCEEDINGS OF THE TWENTY-FIFTH INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES, 1999, : 675 - 686
  • [7] Dynamic orthogonal range queries in OLAP
    Poon, CK
    [J]. THEORETICAL COMPUTER SCIENCE, 2003, 296 (03) : 487 - 510
  • [8] Efficient Range-Sum Queries along Dimensional Hierarchies in Data Cubes
    Lauer, Tobias
    Mai, Dominic
    Hagedorn, Philippe
    [J]. 2009 FIRST INTERNATIONAL CONFERENCE ON ADVANCES IN DATABASES, KNOWLEDGE, AND DATA APPLICATIONS, 2009, : 7 - +
  • [9] Space-efficient range-sum queries in OLAP
    Bengtsson, F
    Chen, JS
    [J]. DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2004, 3181 : 87 - 96
  • [10] Approximate range-sum queries over data cubes using cosine transform
    Hou, Wen-Chi
    Luo, Cheng
    Jiang, Zhewei
    Yan, Feng
    Zhu, Qiang
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2008, 5181 : 376 - +