Wavelet-based relative prefix sum methods for range sum queries in data cubes

  • Authors:
  • Daniel Lemire

  • Affiliations:
  • National Research Council of Canada

  • Venue:
  • CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data mining and related applications often rely on extensive range sum queries and thus, it is important for these queries to scale well. Range sum queries in data cubes can be achieved in time O(1) using prefix sum aggregates but prefix sum update costs are proportional to the size of the data cube O(nd). Using the Relative Prefix Sum (RPS) method, the update costs can be reduced to the root of the size of the data cube O(nd/2). We present a new family of base b wavelet algorithms further reducing the update costs to O (nd/β) for β as large as we want while preserving constant-time queries. We also show that this approach leads to O(logd n) query and update methods twice as fast as Haarbased methods. Moreover, since these new methods are pyramidal, they provide incrementally improving estimates.