Abstract
We introduce a novel technique to drastically reduce the computation required by the refinement step during spatial intersect join processing. This technique, called Symbolic Intersect Detection (SID), detects most of the true hits during a spatial intersect join by scrutinizing symbolic topological relationships between candidate polygon pairs. SID boosts performance by detecting true hits early during the refinement step, thus avoiding expensive polygon intersect computations that would otherwise be required to detect the true hits. Our experimental evaluation with real GIS map data demonstrates that SID can identify more than 80% of the true hits with only minimal overhead. Consequently, SID outperforms known techniques for resolving polygon intersection during the refinement step by more than 50%. Most state-of-the-art methods in spatial join processing can benefit from SID's performance gains because the SID approach integrates easily into the established two-phase spatial join process.
Preview
Unable to display preview. Download preview PDF.
References
Brinkhoff, T., Kriegel, H., and Seeger, B.: Efficient Processing of Spatial Joins Using R-trees. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1993) 237–246
Brinkhoff, T., Kriegel, H., Schneider, R., and Seeger, B.: Multi-Step Processing of Spatial Joins. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1994) 197–208
Burrough, P.A.: Principles of Geographic Information Systems for Land Resources Assessment. Oxford University Press (1986)
Gunther, O.: Efficient Computation of Spatial Joins. Proc. IEEE 9th Int. Conf. on Data Engineering. (1993) 50–59
Guttman, A.: R-tree: a dynamic index structure for spatial searching. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1984) 45–57
Huang, Y.W., Jing, N., and Rundensteiner, E.A.: Breadth-First R-tree Joins with Global Optimizations. EECS Technical Report, University of Michigan (1996)
Huang, Y.W., Jing, N., and Rundensteiner, E.A.: Integrated Query Processing Strategies for Spatial Path Queries. Proc. IEEE 13th Int. Conf. on Data Engineering. (1997)
Lo, M.L. and Ravishankar, C.V.: Spatial Hash-Joins. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1996) 247–258
Maguire, D.J., Goodchild, M.F., and Rhind, D.W.: Geographic Information Systems, volume 1. John Wiley & Sons, Inc. (1991)
Nievergelt, J. and Hinterberger, H.: The Grid File: An Adaptable, Symmetric Multikey File Structure. ACM Transactions on Database Systems. 9(1) (1984) 39–71
Orenstein, J.A.: Spatial Query Processing in an Object-Oriented Database System. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1986)
Orenstein, J.A.: A Comparison of Spatial Query Processing Techniques for Native and Parameter Spaces. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1990) 343–352
Patel, J.M. and DeWitt, D.J.: Partition Based Spatial-Merge Join. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1996) 259–270
Preparata, F.P. and Shamos, M.I.: Computational Geometry. Springer (1985).
Rotem, D.: Spatial Join Indices. Proc. IEEE 7th Int. Conf. on Data Engineering. (1991) 500–509
Shamos, M.I. and Hoey, D.J.: Geometric Intersection Problems. Proc. Conf. on Foundations of Computer Science. (1976) 208–215
Stonebraker, M., Frew, J., Gardels, K., and Meredith, J.: The SEQUOIA 2000 Storage Benchmark. Proc. ACM SIGMOD Int. Conf. on Management of Data. (1993)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1997 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Huang, YW., Jones, M., Rundensteiner, E.A. (1997). Improving spatial intersect joins using Symbolic Intersect Detection. In: Scholl, M., Voisard, A. (eds) Advances in Spatial Databases. SSD 1997. Lecture Notes in Computer Science, vol 1262. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63238-7_29
Download citation
DOI: https://doi.org/10.1007/3-540-63238-7_29
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-63238-2
Online ISBN: 978-3-540-69240-9
eBook Packages: Springer Book Archive