By Topic

Range sum queries in dynamic OLAP data cubes

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

The purchase and pricing options are temporarily unavailable. Please try again later.
4 Author(s)
Hua-Gang Li ; Sch. of Comput., Nat. Univ. of Singapore, Singapore ; Tok Wang Ling ; Sin Yeung Lee ; Zheng Xuan Loh

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

Published in:

Cooperative Database Systems for Advanced Applications, 2001. CODAS 2001. The Proceedings of the Third International Symposium on

Date of Conference:

2001