Multi-way Spatial Joins Using R-Trees: Methodology and Performance Evaluation

We propose a new multi-way spatial join algorithm called M-way R-tree join which synchronously traverses M R-trees. The M-way R-tree join can be considered as a generalization of the 2-way R-tree join. Although a generalization of the 2-way R-tree join has recently been studied, it did not properly take into account the optimization techniques of the original algorithm. Here, we extend these optimization techniques for M-way joins. Since the join ordering was considered to be important in the M-way join literature (e.g., relational join), we especially consider the ordering of the search space restriction and the plane sweep. Additionally, we introduce indirect predicates in the M-way join and propose a further optimization technique to improve the performance of the M-way R-tree join. Through experiments using real data, we show that our optimization techniques significantly improve the performance of the M-way spatial join.

[1]  Timos K. Sellis Review - Efficient Processing of Spatial Joins Using R-Trees , 2000, ACM SIGMOD Digit. Rev..

[2]  Descriptors Census Figures,et al.  U.S. BUREAU OF THE CENSUS , 1996 .

[3]  Elke A. Rundensteiner,et al.  Spatial Joins Using R-trees: Breadth-First Traversal with Global Optimizations , 1997, VLDB.

[4]  Hans-Peter Kriegel,et al.  Efficient processing of spatial joins using R-trees , 1993, SIGMOD Conference.

[5]  Hans-Peter Kriegel,et al.  The R*-tree: an efficient and robust access method for points and rectangles , 1990, SIGMOD '90.

[6]  David J. DeWitt,et al.  Partition based spatial-merge join , 1996, SIGMOD '96.

[7]  Ellis Horowitz,et al.  Fundamentals of Computer Algorithms , 1978 .

[8]  Yannis E. Ioannidis,et al.  Left-deep vs. bushy trees: an analysis of strategy spaces and its implications for query optimization , 1991, SIGMOD '91.

[9]  Ming-Ling Lo,et al.  Spatial joins using seeded trees , 1994, SIGMOD '94.

[10]  Michael Ian Shamos,et al.  Computational geometry: an introduction , 1985 .

[11]  Nick Koudas,et al.  Size separation spatial join , 1997, SIGMOD '97.

[12]  Jack A. Orenstein Spatial query processing in an object-oriented database system , 1986, SIGMOD '86.

[13]  Dimitris Papadias,et al.  Processing and optimization of multiway spatial joins using R-trees , 1999, PODS '99.

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

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

[16]  Chan-Gun Lee,et al.  Early separation of filter and refinement steps in spatial query optimization , 1999, Proceedings. 6th International Conference on Advanced Systems for Advanced Applications.

[17]  Sridhar Ramaswamy,et al.  Scalable Sweeping-Based Spatial Join , 1998, VLDB.

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

[19]  Dimitris Papadias,et al.  Integration of spatial join algorithms for processing multiple inputs , 1999, SIGMOD '99.

[20]  Dimitris Papadias,et al.  Range Queries Involving Spatial Relations: A Performance Analysis , 1995, COSIT.

[21]  Dimitris Papadias,et al.  Algorithms for Querying by Spatial Structure , 1998, VLDB.