Multi-step processing of spatial joins
- 24 May 1994
- proceedings article
- Published by Association for Computing Machinery (ACM)
- Vol. 23 (2) , 197-208
- https://doi.org/10.1145/191839.191880
Abstract
Spatial joins are one of the most important operations for combining spatial objects of several relations. In this paper, spatial join processing is studied in detail for extended spatial objects in two-dimensional data space. We present an approach for spatial join processing that is based on three steps. First, a spatial join is performed on the minimum bounding rectangles of the objects returning a set of candidates. Various approaches for accelerating this step of join processing have been examined at the last year's conference [BKS 93a]. In this paper, we focus on the problem how to compute the answers from the set of candidate which is handled by the following two steps. First of all, sophisticated approximations are used to identify answers as well as to filter out false hits from the set of candidates. For this purpose, we investigate various types of conservative and progressive approximations. In the last step, the exact geometry of the remaining candidates has to be tested against the join predicate. The time required for computing spatial join predicates can essentially be reduced when objects are adequately organized in main memory. In our approach, objects are first decomposed into simple components which are exclusively organized by a main-memory resident spatial data structure. Overall, we present a complete approach of spatial join processing on complex spatial objects. The performance of the individual steps of our approach is evaluated with data sets from real cartographic applications. The results show that our approach reduces the total execution time of the spatial join by factors.Keywords
This publication has 13 references indexed in Scilit:
- Efficient processing of spatial joins using R-treesPublished by Association for Computing Machinery (ACM) ,1993
- Join processing in relational databasesACM Computing Surveys, 1992
- The TR*-tree: A new representation of polygonal objects supporting spatial queries and operationsPublished by Springer Nature ,1991
- Internal and external algorithms for the points-in-regions problem—the inside join of geo-relational algebraAlgorithmica, 1990
- The R*-tree: an efficient and robust access method for points and rectanglesPublished by Association for Computing Machinery (ACM) ,1990
- Gray codes for partial match and range queriesIEEE Transactions on Software Engineering, 1988
- Spatial query processing in an object-oriented database systemPublished by Association for Computing Machinery (ACM) ,1986
- Computational GeometryPublished by Springer Nature ,1985
- R-treesPublished by Association for Computing Machinery (ACM) ,1984
- Minimum partition of polygonal regions into trapezoidsPublished by Institute of Electrical and Electronics Engineers (IEEE) ,1983