This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Buffer Queries
July/August 2003 (vol. 15 no. 4)
pp. 895-910

Abstract—A class of commonly asked queries in a spatial database is known as buffer queries. An example of such a query is to “find house-power line pairs that are within 50 meters of each other.” A buffer query involves two spatial data sets and a distance d. The answer to this query are pairs of objects, one from each input set, that are within distance d of each other. Given nonpoint spatial objects, evaluation of buffer queries could be a costly operation, even when the numbers of objects in the input data sets are relatively small. This paper addresses the problem of how to evaluate this class of queries efficiently. A fundamental problem with buffer query evaluation is to find an efficient algorithm for solving the minimum distance (minDist) problem for lines and regions. An efficient minDist algorithm, which only requires a subsequence of segments from each object to be examined, is derived. Finding a fast minDist algorithm is the first step in evaluating a buffer query efficiently. It is observed that many, and sometimes even most, candidates can be proven in the answer without resorting to the relatively expensive minDist operation. A candidate is first evaluated with a least expensive technique—called 0-object filtering. If it fails, a more costly operation, called 1-object filtering, is applied. Finally, if both filterings fail, the most expensive minDist algorithm is invoked. To show the effectiveness of the these techniques, they are incorporated into the well-known tree join algorithm and tested with real-life as well as artificial data sets. Extensive experiments show that the proposed algorithm outperforms existing techniques by a wide margin in both execution time as well as IO accesses. More importantly, the performance gain improves drastically with the increase of distance values.

[1] L. Arge, S. Procopiuc, S. Ramaswamy, T. Suel, and J. Vitter, Scalable Sweeping-Based Spatial Join Proc. 24th Very Large Data Bases Conf., pp. 570-581, 1998.
[2] L. Becker, A. Giesen, K. Hinrichs, and J. Vahrenhold, Algorithms for Performing Polygonal Map Overlay and Spatial Join on Massive Data Sets Proc. Sixth Int'l Symp. Advances in Spatial Databases, pp. 270-285, 1999.
[3] T. Brinkhoff, H.-P. Kriegel, and B. Seeger, Efficient Processing of Spatial Joins Using R-Trees Proc. ACM SIGMOD, pp. 237-246, 1993.
[4] T. Brinkhoff, H.-P. Kriegel, R. Schneider, and B. Seeger, Multi-Step Processing of Spatial Joins Proc. ACM SIGMOD, pp. 197-208, 1994.
[5] A. Carral, Y. Manolopoulos, Y. Theodoridis, and M. Vassilakopoulos, Closest Pair Queries in Spatial Databases Proc. ACM SIGMOD, pp. 189-200, 2000.
[6] E.P.F. Chan and J.N.H. Ng, A General and Efficient Implementation of Geometric Operators and Predicates Proc. Fifth Int'l Symp. Advances in Spatial Databases, pp. 69-93, 1997.
[7] F. Chin and C.A. Wang, Optimal Algorithms for the Intersection and the Minimum Distance Problems Between Planar Polygons IEEE Trans. Computer, pp. 1203-1207, 1983.
[8] N. Chrisman, Exploring Geographic Information Systems. Wiley, 1997.
[9] O. Günther, “Efficient Computation of Spatial Joins,” Proc. Ninth Conf. Data Eng., pp. 50-60, 1993.
[10] R.H. Guting and W. Schilling, A Practical Divide-and-Conquer Algorithm for the Rectangle Intersection Problem Information Sciences (42), pp. 95-112, 1987.
[11] R.H. Guting, T. Ridder, and M. Schneider, Implementation of ROSE Algebra: Efficient Algorithms for Realm-Based Spatial Data Types Proc. Advances in Spatial Databases Fourth Int'l Symp. (SSD '95), pp. 216-239, 1995.
[12] A. Guttman, R-Trees: A Dynamic Index Structure for Spatial Searching Proc. ACM SIGMOD, pp. 47-57, 1984.
[13] G.R. Hjaltason and H. Samet, Incremental Distance Join Algorithms for Spatial Databases Proc. ACM SIGMOD, pp. 237-248, 1998.
[14] Y.-W. Huang, M. Jones, and E. Rundensteiner, Improving Spatial Intersect Using Symbolic Intersect Detection Proc. Fifth Int'l Symp. Advances in Spatial Databases, pp. 165-177, 1997.
[15] I. Kamel and C. Faloutsos, Hilbert R-Tree: An Improved R-Tree Using Fractals Proc. 20th Very Large Data Bases Conf., pp. 500-509, 1994.
[16] R.K. Kothuri and S. Ravada, Efficient Processing of Large Spatial Queries Using Interior Approximations Proc. Seventh Int'l Symp. Spatial and Temporal Databases (SSTD '01), pp. 404-421, July 2001.
[17] N. Koudas and K.C. Sevcik, High Dimensional Similarity Joins: Algorithms and Performance Evaluation IEEE Trans. Knowledge and Data Eng., vol. 12, no. 1, pp. 3-18, Jan./Feb. 2000.
[18] H. Kriegel, T. Brinkhoff, and R. Schneider, An Efficient Map Overlay Algorithm Based on Spatial Access Methods and Computational Geometry Proc. Int'l Workshop DBMS's for Geographic Applications, pp. 194-211, 1991.
[19] M.L. Lo and C.V. Ravishankar, Spatial Hash-Join Proc. ACM SIGMOD, pp. 247-258, 1996.
[20] V.J. Lumelsky, On Fast Computation of Distance Between Line Segments Information Processing Letters, vol. 21, pp. 55-61, 1985.
[21] K. Mehlhorn and S. Naher, LEDA, A Platform for Combinatorial and Geometric Computing Comm. ACM, no. 38, pp. 96-102, Jan. 1995.
[22] Oracle Spatial User's Guide and Reference. Version 9.0.1, 2001.
[23] J.M. Patel and D. DeWitt, Partition Based Spatial-Merge Join Proc. ACM SIGMOD, pp. 259-270, 1996.
[24] S. Quinlan, Efficient Distance Computation Between Non-Convex Objects Proc. IEEE Int'l Conf. Robotics and Automation, pp. 3325-3330, 1994.
[25] P. Rigaux, M. Scholl, and A. Voisard, Spatial Databases with Application to GIS. Morgan Kaufmann, 2002.
[26] N. Roussopoulos, S. Kelley, and F. Vincent, Nearest Neighbor Queries Proc. ACM SIGMOD, pp. 71-79, 1995.
[27] J. Star and J. Estes, Geographic Information Systems An Introduction. Prentice Hall, 1990.
[28] G. Zimbrao and J.M. de Souza, A Raster Approximation for the Processing of Spatial Joins Proc. 24th Very Large Data Bases Conf., pp. 558-569, 1998.

Index Terms:
Buffer query, distance-related query, minimum distance, spatial query evaluation, filtering, refinement, spatial join.
Citation:
Edward P.F. Chan, "Buffer Queries," IEEE Transactions on Knowledge and Data Engineering, vol. 15, no. 4, pp. 895-910, July-Aug. 2003, doi:10.1109/TKDE.2003.1209007
Usage of this product signifies your acceptance of the Terms of Use.