Efficient Range-Sum Queries along Dimensional Hierarchies in Data Cubes

  • Authors:
  • Tobias Lauer;Dominic Mai;Philippe Hagedorn

  • Affiliations:
  • -;-;-

  • Venue:
  • DBKDA '09 Proceedings of the 2009 First International Conference on Advances in Databases, Knowledge, and Data Applications
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Fast response to users’ query and update requests continues to be one of the key requirements for OLAP systems. We outline the generalization of a space-efficient data structure, which makes it particularly suited for cubes with hierarchically structured dimensions. For a large class of range-sum queries – roll-up and drill-down along dimension hierarchies – the structure requires only a constant number of cell accesses per query on average, while offering an expected poly-logarithmic update performance.