Efficient Computation of Spatial Joins

Spatial joins are join operations that involve spatial data types and operators. Due to basic properties of spatial data, many conventional join strategies suffer serious performance penalties or are not applicable at all. The join strategies known from conventional databases that can be applied to spatial joins and the ways in which some of these techniques can be modified to be more efficient in the context of spatial data are discussed. A class of tree structures, called generalization trees, that can be applied efficiently to compute spatial joins in a hierarchical manner are described. The performances of the most promising strategies are analytically modeled and compared. >

[1]  S. B. Yao,et al.  Approximating block accesses in database organizations , 1977, CACM.

[2]  Michael Stonebraker,et al.  The Implementation of Postgres , 1990, IEEE Trans. Knowl. Data Eng..

[3]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[4]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

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

[6]  Hans-Jörg Schek,et al.  The DASDBS Project: Objectives, Experiences, and Future Prospects , 1990, IEEE Trans. Knowl. Data Eng..

[7]  Doron Rotem Spatial join indices , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[8]  Jürg Nievergelt,et al.  The Grid File: An Adaptable, Symmetric Multikey File Structure , 1984, TODS.