Skip to main content
Journal cover image

Efficient external memory structures for range-aggregate queries

Publication ,  Journal Article
Agarwal, PK; Arge, L; Govindarajan, S; Yang, J; Yi, K
Published in: Computational Geometry: Theory and Applications
April 1, 2013

We present external memory data structures for efficiently answering range-aggregate queries. The range-aggregate problem is defined as follows: Given a set of weighted points in Rd, compute the aggregate of the weights of the points that lie inside a d-dimensional orthogonal query rectangle. The aggregates we consider in this paper include count, sum, and max. First, we develop a structure for answering two-dimensional range-count queries that uses O(N/B) disk blocks and answers a query in O( logBN) I/Os, where N is the number of input points and B is the disk block size. The structure can be extended to obtain a near-linear-size structure for answering range-sum queries using O( logBN) I/Os, and a linear-size structure for answering range-max queries in O(logB2N) I/Os. Our structures can be made dynamic and extended to higher dimensions. © 2012 Elsevier B.V.

Duke Scholars

Altmetric Attention Stats
Dimensions Citation Stats

Published In

Computational Geometry: Theory and Applications

DOI

ISSN

0925-7721

Publication Date

April 1, 2013

Volume

46

Issue

3

Start / End Page

358 / 370

Related Subject Headings

  • Geological & Geomatics Engineering
  • 49 Mathematical sciences
  • 46 Information and computing sciences
  • 0802 Computation Theory and Mathematics
  • 0103 Numerical and Computational Mathematics
  • 0101 Pure Mathematics
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Agarwal, P. K., Arge, L., Govindarajan, S., Yang, J., & Yi, K. (2013). Efficient external memory structures for range-aggregate queries. Computational Geometry: Theory and Applications, 46(3), 358–370. https://doi.org/10.1016/j.comgeo.2012.10.003
Agarwal, P. K., L. Arge, S. Govindarajan, J. Yang, and K. Yi. “Efficient external memory structures for range-aggregate queries.” Computational Geometry: Theory and Applications 46, no. 3 (April 1, 2013): 358–70. https://doi.org/10.1016/j.comgeo.2012.10.003.
Agarwal PK, Arge L, Govindarajan S, Yang J, Yi K. Efficient external memory structures for range-aggregate queries. Computational Geometry: Theory and Applications. 2013 Apr 1;46(3):358–70.
Agarwal, P. K., et al. “Efficient external memory structures for range-aggregate queries.” Computational Geometry: Theory and Applications, vol. 46, no. 3, Apr. 2013, pp. 358–70. Scopus, doi:10.1016/j.comgeo.2012.10.003.
Agarwal PK, Arge L, Govindarajan S, Yang J, Yi K. Efficient external memory structures for range-aggregate queries. Computational Geometry: Theory and Applications. 2013 Apr 1;46(3):358–370.
Journal cover image

Published In

Computational Geometry: Theory and Applications

DOI

ISSN

0925-7721

Publication Date

April 1, 2013

Volume

46

Issue

3

Start / End Page

358 / 370

Related Subject Headings

  • Geological & Geomatics Engineering
  • 49 Mathematical sciences
  • 46 Information and computing sciences
  • 0802 Computation Theory and Mathematics
  • 0103 Numerical and Computational Mathematics
  • 0101 Pure Mathematics