Data structures for range-aggregate extent queries

A fundamental and well-studied problem in computational geometry is range searching, where the goal is to preprocess a set, S, of geometric objects (e.g., points in the plane) so that the subset S^'@?S that is contained in a query range (e.g., an axes-parallel rectangle) can be reported efficiently. However, in many situations, what is of interest is to generate a more informative ''summary'' of the output, obtained by applying a suitable aggregation function on S^'. Examples of such aggregation functions include count, sum, min, max, mean, median, mode, and top-k that are usually computed on a set of weights defined suitably on the objects. Such range-aggregate query problems have been the subject of much recent research in both the database and the computational geometry communities. In this paper, we further generalize this line of work by considering aggregation functions on point-sets that measure the extent or ''spread'' of the objects in the retrieved set S^'. The functions considered here include closest pair, diameter, and width. The challenge here is that these aggregation functions (unlike, say, count) are not efficiently decomposable in the sense that the answer to S^' cannot be inferred easily from answers to subsets that induce a partition of S^'. Nevertheless, we have been able to obtain space- and query-time-efficient solutions to several such problems including: closest pair queries with axes-parallel rectangles on point sets in the plane and on random point-sets in R^d (d>=2), closest pair queries with disks on random point-sets in the plane, diameter queries on point-sets in the plane, and guaranteed-quality approximations for diameter and width queries in the plane. Our results are based on a combination of geometric techniques, including multilevel range trees, Voronoi Diagrams, Euclidean Minimum Spanning Trees, sparse representations of candidate outputs, and proofs of (expected) upper bounds on the sizes of such representations.

[1]  Amitava Datta,et al.  An efficient algorithm for computing the maximum empty rectangle in three dimensions , 2000, Inf. Sci..

[2]  Donghui Zhang,et al.  Improving min/max aggregation over spatial objects , 2001, GIS '01.

[3]  Prosenjit Bose,et al.  Approximate Range Mode and Range Median Queries , 2005, STACS.

[4]  Prosenjit Gupta Range-Aggregate Query Problems Involving Geometric Aggregation Operations , 2006, Nord. J. Comput..

[5]  Pankaj K. Agarwal,et al.  CRB-Tree: An Efficient Indexing Scheme for Range-Aggregate Queries , 2003, ICDT.

[6]  Prosenjit Gupta Range-Aggregate Proximity Queries , 2007 .

[7]  Ralf Hartmut Güting,et al.  The direct dominance problem , 1985, SCG '85.

[8]  David G. Kirkpatrick,et al.  Optimal Search in Planar Subdivisions , 1983, SIAM J. Comput..

[9]  Robert E. Tarjan,et al.  Scaling and related techniques for geometry problems , 1984, STOC '84.

[10]  Prosenjit Gupta,et al.  Range-Aggregate Proximity Detection for Design Rule Checking in VLSI Layouts , 2006, CCCG.

[11]  Stefan Felsner Empty Rectangles and Graph Dimension , 2005 .

[12]  Shashi Shekhar,et al.  Spatial Databases: A Tour , 2003 .

[13]  Donghui Zhang,et al.  Optimizing spatial Min/Max aggregations , 2005, The VLDB Journal.

[14]  Dimitrios Gunopulos,et al.  Efficient computation of temporal aggregates with range predicates , 2001, PODS '01.

[15]  Michael Ian Shamos,et al.  Computational geometry: an introduction , 1985 .

[16]  Seokjin Hong,et al.  Efficient Execution of Range-Aggregate Queries in Data Warehouse Environments , 2001, ER.

[17]  Michiel H. M. Smid,et al.  On the power of the semi-separated pair decomposition , 2009, Comput. Geom..

[18]  Yufei Tao,et al.  Range aggregate processing in spatial databases , 2004, IEEE Transactions on Knowledge and Data Engineering.

[19]  Pankaj K. Agarwal,et al.  Geometric Range Searching and Its Relatives , 2007 .

[20]  Michiel H. M. Smid,et al.  Range Mode and Range Median Queries on Lists and Trees , 2003, Nord. J. Comput..

[21]  Rolf Klein,et al.  Direct dominance of points , 1986 .

[22]  Pankaj K. Agarwal,et al.  Approximating extent measures of points , 2004, JACM.

[23]  Dimitrios Gunopulos,et al.  Efficient aggregation over objects with extent , 2002, PODS '02.

[24]  Ravi Janardan On Maintaining the Width and Diameter of a Planar Point-Set Online , 1991, ISA.

[25]  Jing Shan,et al.  On Spatial-Range Closest-Pair Query , 2003, SSTD.

[26]  Mark de Berg,et al.  Computational geometry: algorithms and applications , 1997 .