DocumentCode :
3407316
Title :
Range sum queries in dynamic OLAP data cubes
Author :
Li, Hua-Gang ; Ling, Tok Wang ; Lee, Sin Yeung ; Loh, Zheng Xuan
Author_Institution :
Sch. of Comput., Nat. Univ. of Singapore, Singapore
fYear :
2001
fDate :
2001
Firstpage :
74
Lastpage :
81
Abstract :
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(nd) 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(n1/3) and an update cost of O(nd/3 ) in the worst case. The total cost of DRPS is the smallest compared with other techniques under two cost models. However, this technique causes considerable space overhead which is about nd+dnd-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. We propose a new technique which promises the same query cost and update cost as DRPS while the additional space requirement is only nd
Keywords :
data analysis; data mining; data structures; data warehouses; query processing; relational databases; data analysis; data warehouse; double relative prefix sum; dynamic OLAP data cubes; multidimensional databases; online analytical processing; query cost; range sum queries; real time information; relational database; update cost; Aggregates; Costs; Data analysis; Data warehouses; Databases; Information analysis; Marketing and sales; Multidimensional systems; Navigation; Silicon compounds;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Cooperative Database Systems for Advanced Applications, 2001. CODAS 2001. The Proceedings of the Third International Symposium on
Conference_Location :
Beijing
Print_ISBN :
0-7695-1128-7
Type :
conf
DOI :
10.1109/CODAS.2001.945152
Filename :
945152
Link To Document :
بازگشت