Spatial hash-joins
- 1 June 1996
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 25 (2) , 247-258
- https://doi.org/10.1145/235968.233337
Abstract
We examine how to apply the hash-join paradigm to spatial joins, and define a new framework for spatial hash-joins. Our spatial partition functions have two components: a set of bucket extents and an assignment function, which may map a data item into multiple buckets. Furthermore, the partition functions for the two input datasets may be different.We have designed and tested a spatial hash-join method based on this framework. The partition function for the inner dataset is initialized by sampling the dataset, and evolves as data are inserted. The partition function for the outer dataset is immutable, but may replicate a data item from the outer dataset into multiple buckets. The method mirrors relational hash-joins in other aspects. Our method needs no pre-computed indices. It is therefore applicable to a wide range of spatial joins.Our experiments show that our method outperforms current spatial join algorithms based on tree matching by a wide margin. Further, its performance is superior even when the tree-based methods have pre-computed indices. This makes the spatial hash-join method highly competitive both when the input datasets are dynamically generated and when the datasets have pre-computed indices.Keywords
This publication has 13 references indexed in Scilit:
- Partition based spatial-merge joinPublished by Association for Computing Machinery (ACM) ,1996
- Spatial joins using seeded treesPublished by Association for Computing Machinery (ACM) ,1994
- Efficient processing of spatial joins using R-treesPublished by Association for Computing Machinery (ACM) ,1993
- Join processing in relational databasesACM Computing Surveys, 1992
- A practical divide-and-conquer algorithm for the rectangle intersection problemInformation Sciences, 1987
- Analysis of object oriented spatial access methodsPublished by Association for Computing Machinery (ACM) ,1987
- Join processing in database systems with large main memoriesACM Transactions on Database Systems, 1986
- R-treesPublished by Association for Computing Machinery (ACM) ,1984
- Implementation techniques for main memory database systemsPublished by Association for Computing Machinery (ACM) ,1984
- Application of hash to data base machine and its architectureNew Generation Computing, 1983