MetaCartSign in to MyCiteSeer

Include Citations | Advanced Search | Help

Include Citations | Advanced Search | Help

  Efficient aggregation over objects with extent (2002) [30 citations — 7 self]

Download:
Download as a PDF | Download as a PS
by Donghui Zhang, Vassilis J. Tsotras, Dimitrios Gunopulos
TechReport UCR CS 01 01, CS Dept
http://www.cs.ucr.edu/~donghui/publications/boxaggr_pods02.ps
Add To MetaCart

Abstract:

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.

Citations

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