A generic algorithmic framework for aggregation of spatio-temporal data

Spatio-temporal databases are often associated with analyses that summarize stored data over spatial, temporal or spatio-temporal dimensions. For example, a study of traffic patterns might explore average traffic densities on a road network at different times, over different areas in space, and over different areas in space at different times. The importance of temporal, spatial and spatio-temporal aggregation has been reflected in a significant number of proposals for algorithms for efficient computation of specific kinds of aggregation. However; although such proposals may be effective in particular cases, as yet there is no generic framework that provides efficient support for the wide range of partitioning and aggregation operations that a spatio-temporal database management system might be expected to support over both stored and derived data. This paper proposes an algorithmic framework that can be applied to many different forms of aggregation, and presents the results of performance studies on an implementation of the framework. These show that the framework provides a scalable solution for the many cases in which the aggregations required over stored and derived data may be widely variable and unpredictable.

[1]  Marcel Kornacker,et al.  High-Performance Extensible Indexing , 1999, VLDB.

[2]  Jennifer Widom,et al.  Incremental computation and maintenance of temporal aggregates , 2001, Proceedings 17th International Conference on Data Engineering.

[3]  Christian S. Jensen,et al.  Efficient evaluation of the valid-time natural join , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[4]  Ralf Hartmut Güting,et al.  Realm-based spatial data types: The ROSE algebra , 1995, The VLDB Journal.

[5]  R. G. Cattell The object database standard , 1994 .

[6]  Norman W. Paton,et al.  The Tripod spatio-historical data model , 2004, Data Knowl. Eng..

[7]  Norman W. Paton,et al.  An Experimental Performance Evaluation of Spatio‐Temporal Join Strategies , 2005, Trans. GIS.

[8]  Ming-Ling Lo,et al.  Spatial hash-joins , 1996, SIGMOD '96.

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

[10]  Panos Kalnis,et al.  Indexing spatio-temporal data warehouses , 2002, Proceedings 18th International Conference on Data Engineering.

[11]  Sharad Mehrotra,et al.  Progressive approximate aggregate queries with a multi-resolution tree structure , 2001, SIGMOD '01.

[12]  Goetz Graefe,et al.  Query evaluation techniques for large databases , 1993, CSUR.

[13]  Richard T. Snodgrass,et al.  Aggregates in the Temporal Query Language TQuel , 1993, IEEE Trans. Knowl. Data Eng..

[14]  Norman W. Paton,et al.  Tripod: a comprehensive system for the management of spatial and aspatial historical objects , 2001, GIS '01.

[15]  Norman W. Paton,et al.  A query calculus for spatio-temporal object databases , 2001, Proceedings Eighth International Symposium on Temporal Representation and Reasoning. TIME 2001.

[16]  Panos Kalnis,et al.  Efficient OLAP Operations in Spatial Data Warehouses , 2001, SSTD.

[17]  Richard T. Snodgrass,et al.  Computing temporal aggregates , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

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

[19]  Yannis Theodoridis,et al.  On the Generation of Spatiotemporal Datasets , 1999 .

[20]  Richard S. Bird,et al.  Introduction to functional programming , 1988, Prentice Hall International series in computer science.

[21]  Myoung-Ho Kim,et al.  Effective Temporal Aggregation Using Point-Based Trees , 1999, DEXA.

[22]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.