We examine the problem of eciently computing sum/count/ avg aggregates over objects with non-zero extent. Recent work on computing multi-dimensional aggregates has concentrated on objects with zero extent (points) on a multidimensional grid, or one-dimensional intervals. However, in many spatial and/or spatio-temporal applications objects have extent in various dimensions, while they can be located anywhere in the application space. The aggregation predicate is typically described by a multi-dimensional box (box-sum aggregation). We examine two variations of the problem. In the simple case an object's value contributes to the aggregation result as a whole as long as the object intersects the query box. More complex is the functional box-sum aggregation introduced in this paper, where objects participate in the aggregation proportionally to the size of their intersection with the query box. We rst show that both problems can be reduced to dominance-sum queries. Traditionally, dominance-sum queries are addressed in main memory by a static structure, the ECDF-tree. We then propose two extensions, namely, the ECDF-B-trees, that make this structure disk-based and dynamic. Finally, we introduce the BA-tree that combines the advantages from each ECDF-B-tree. We run experiments comparing the performance of the ECDF-B-trees, the BA-tree and a traditional R*-tree (which has been augmented to include aggregation information on its index nodes) over spatial datasets. Our evaluation rearms that the BA-tree has more robust performance. Compared against the augmented R*-tree, the BA-tree oers drastic improvement in query performance at the expense of some limited extra space.
|
1541
|
Computational Geometry: An Introduction
– Preparata, Shamos
- 1985
|
|
452
|
The R ∗ -tree: An Efficient and Robust Access Method for Points and Rectangles
– Beckmann, Kriegel, et al.
- 1990
|
|
417
|
Multidimensional access methods
– Gaede, Gunther
- 1998
|
|
248
|
Online aggregation
– Hellerstein, Haas, et al.
- 1997
|
|
204
|
External memory algorithms and data structures: Dealing with massive data
– Vitter
|
|
194
|
Geometric range searching and its relatives
– Agarwal, Erickson
- 1999
|
|
186
|
On the computation of multidimensional aggregates
– Agarwal, Agrawal, et al.
- 1996
|
|
145
|
An Array-Based Algorithm for Simultaneous Multidimensional Aggregations
– Zhao, Deshpande, et al.
- 1997
|
|
132
|
An asymptotically optimal multiversion B-tree
– Becker, Gschwind, et al.
- 1996
|
|
131
|
Approximate computation of multidimensional aggregates of sparse data using wavelets
– Vitter, Wang
- 1999
|
|
91
|
A functional approach to data structures and its use in multidimensional searching
– Chazelle
- 1988
|
|
90
|
Multidimensional divide-and-conquer
– Bentley
- 1980
|
|
81
|
Decomposable searching problems I: Static-to-dynamic transformation
– Bentley, Saxe
- 1980
|
|
78
|
Data cube approximation and histograms via wavelets.In
– JS, Wang, et al.
- 1998
|
|
75
|
Dynamic algorithms in computational geometry
– Chiang, Tamassia
- 1992
|
|
71
|
On computing the data cube
– Sarawagi, Agrawal, et al.
- 1996
|
|
61
|
External memory algorithms
– VITTER
- 1998
|
|
58
|
Selectivity estimation in spatial databases
– Acharya, Poosala, et al.
- 1999
|
|
56
|
Congressional samples for approximate answering of group-by queries
– Acharya, Gibbons, et al.
- 2000
|
|
55
|
Incremental computation and maintenance of temporal aggregates
– Yang, Widom
- 2001
|
|
54
|
Multi-dimensional searching and computational geometry
– Mehlhorn
- 1984
|
|
52
|
Computing temporal aggregates
– Kline, Snodgrass
- 1995
|
|
50
|
Geometric range searching
– Matousek
- 1994
|
|
48
|
Progressive approximate aggregate queries with a multi-resolution tree structure
– Lazaridis, Mehrotra
- 2001
|
|
46
|
Compressed data cubes for OLAP aggregate query approximation on continuous dimensions.In
– Shanmugasundaram, Fayyad, et al.
- 1988
|
|
43
|
The R*-tree: an ecient and robust access method for points and rectangles
– Beckmann, Kriegel, et al.
- 1990
|
|
40
|
Efficient computation of temporal aggregates with range predicates
– Zhang, Markowetz, et al.
- 2001
|
|
31
|
Relative prefix sums: An efficient approach for querying dynamic OLAP data cubes
– Geffner, Agrawal, et al.
- 1999
|
|
27
|
Parallel algorithms for computing temporal aggregates
– Gendrano, Huang, et al.
- 1999
|
|
26
|
Hierarchical cubes for range-sum queries
– Chan, Ioannidis
- 1999
|
|
22
|
On the equivalence of some rectangle problems
– Edelsbrunner, Overmars
- 1982
|
|
22
|
Scalable algorithms for large temporal aggregation
– Moon, Lopez, et al.
- 2000
|
|
18
|
The transformation technique for spatial objects revisited
– PAGEL, SIX, et al.
- 1993
|
|
15
|
Temporal aggregation over data streams using multiple granularities
– Zhang, Gunopulos, et al.
- 2002
|
|
11
|
Exploring Spatial Datasets with Histograms
– Sun, Agrawal, et al.
- 2002
|
|
10
|
Aggregate processing of planar points
– Tao, Papadias, et al.
- 2002
|
|
9
|
Cubetree: Organization of and Bulk
– Roussopoulos, Kotidis, et al.
- 1997
|
|
9
|
Selectivity estimation for spatial joins with geometric selections
– Sun, Agrawal, et al.
- 2002
|
|
9
|
Time-IT, the Time-Integrated Testbed", ftp://ftp.cs.arizona.edu/timecenter/timeit -0.1.tar.gz, Current as of August 18
– Kline, Soo
- 1998
|
|
8
|
Dynamic Update Cube for Range-Sum Queries
– Chung, Chun, et al.
- 2001
|
|
8
|
Range Queries
– Ho, Agrawal, et al.
- 1997
|
|
7
|
How to Evaluate Multiple Range-Sum Queries Progressively
– Schmidt, Shahabi
- 2002
|
|
6
|
The K-D-B Tree
– Robinson
- 1981
|
|
6
|
User Defined Aggregates
– Wang, Zaniolo
- 2000
|
|
5
|
Relative Pre Sums: An Ecient Approach for Querying Dynamic OLAP Data Cubes
– Gener, Agrawal, et al.
- 1999
|
|
5
|
Abbadi. pCube: Update-efficient online aggregation with progressive feedback and error bounds
– Riedewald, Agrawal, et al.
- 2000
|
|
4
|
Abbadi, "The Dynamic Data Cube
– Geffner, Agrawal, et al.
- 2000
|
|
4
|
Efficient olap operations in spatial data warehouses
– Papadias, Kalnis, et al.
- 2001
|
|
3
|
The Design of Dynamic Data Structures", LNCS
– Overmars
- 1983
|
|
3
|
On the Equivalence of Some Rectangle
– Edelsbrunner, Overmars
- 1982
|