Abstract
An important query for spatial database research is to find the closest pair of objects in a given space. Existing work assumes two objects of the closest pair come from two different data sets indexed by R-trees. The closest pair in the whole space will be found via an optimzed R-tree join technique. However, this technique doesn’t perform well when the two data sets are identical. And it doesn’t work when the search range is some area other than the whole space. In this paper, we address the closest pair problem within the same data set. Further more, we propose a practical extension to the closest pair problem to involve a query range. The problem now becomes finding the closest pair of objects among those inside a given range. After extending the existing techniques to solve the new problem, we proposed two index structures based on augmenting the R-tree and we also give algorithms for maintaining these structrures. Experimental results show that our structures are more robust than earlier approaches.
This work was partially supported by NSF grant IIS-0073063.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Oracle8 spatial cartridge, http://technet.oracle.com/products/oracle8/info/sdods/xsdo7ds.htm
IBM informix spatial datablade module, http://www-3.ibm.com/software/data/informix/pubs/specsheets/SWSEC27152000D.pdf
Beckmann, N., Kriegel, H.-P., Schneider, R., Seeger, B.: The R*-Tree: an efficient and robust access method for points and rectangles. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (1990)
Berchtold, S., Ertl, B., Keim, D.A., Kriegel, H.-P., Seidl, T.: Fast nearest neighbor search in high-dimensional space. In: Proceedings of the 14th International Conference on Data Engineering, ICDE (1998)
Corral, A., Manolopoulos, Y., Theodoridis, Y., Vassilakopoulos. M.: Closest pair queries in spatial databases. Technical Report, Aristotle Univ. of Thessaloniki, Greece (1999), http://delab.csd.auth.gr/~michaliz/cpq.html
Corral, A., Manolopoulos, Y., Theodoridis, Y., Vassilakopoulos, M.: Closest pair queries in spatial databases. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (2000)
Dietzfelbinger, M., Hagerup, T., Katajainen, J., Penttonen, M.: A reliable randomized algorithm for the closest-pair problem. Journal of Algorithms 25(1) (1997)
Gaede, V., Günther, O.: Multidimensional access methods. ACM Computing Surveys 30(2) (1998)
Guttman, A.: R-trees: a dynamic index structure for spatial searching. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (1984)
Hjaltason, G.R., Samet, H.: Incremental distance join algorithms for spatial databases. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data, Seattle, WA, USA (1998)
Hjaltason, G.R., Samet, H.: Distance browsing in spatial databases. ACM Transactions on Database Systems, TODS (June 1999)
Katayama, N., Satoh, S.: The SR-tree: An index structure for high-dimensional nearest neighbor queries. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (1997)
Kollios, G., Gunopulos, D., Tsotras, V.J.: Nearest neighbor queries in a mobile environment. In: Proceedings of the International Workshop on Spatio-Temporal Database Management, pp. 119–134 (1999)
Korn, F., Muthukrishnan, S.: Influence sets based on reverse nearest neighbor queries. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (2000)
Roussopoulos, N., Kelly, S., Vincent, F.: Nearest neighbor queries. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (1995)
Seidl, T., Kriegel, H.-P.: Optimal multi-step k-nearest neighbor search. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (1998)
Smid, M.: Closest point problems in computational geometry. In: Sack, J.-R., Urrutia, J. (eds.) Handbook on Computational Geometry. Elsevier Science Publishing, Amsterdam (1997)
Song, Z., Roussopoulos, N.: K-nearest neighbor search for moving query point. In: Proceedings of the 7th International Symposium on Spatial and Temporal Databases, pp. 79–96 (2001)
Stanoi, I., Agrawal, D., Abbadi, A.E.: Reverse nearest neighbor queries for dynamic databases. In: Proceedings of the ACM SIGMOD Workshop on Research Issu in Data Mining and Knowledge Discovery (2000)
van den Bercken, J., Dittrich, J.-P., Blohsfeld, B., Krämer, J., Schäfer, T., Schneider, M., Seeger, B.: XXL- a library arrproach to supporting efficient implementations of advanced database queries. In: Proceedings of the 27th VLDB Conference (2001)
Yang, C., Lin, K.: An index structure for improving closest pairs and related join queries in spatial databses. In: Proceedings of the International Database Engineering and Applications Symposium, IDEAS 2002 (2002)
Yang, C., Lin, K.-I.: An index structure for efficient reverse nearest neighbor queries. In: Proceedings of the 14th International Conference on Data Engineering, ICDE (2001)
Zhang, D., Tsotras, V. J., Seeger. B.: A comparison of indexed temporal joins. Tech Report, UCR-CS-00-03, CS Dept., UC Riverside (2000), http://www.cs.ucr.edu/~donghui/publications/tempjoin.ps
Zhang, D., Tsotras, V.J., Seeger, B.: Efficient temporal join processing using indices. In: Proceedings of the 14th International Conference on Data Engineering, ICDE (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Shan, J., Zhang, D., Salzberg, B. (2003). On Spatial-Range Closest-Pair Query. In: Hadzilacos, T., Manolopoulos, Y., Roddick, J., Theodoridis, Y. (eds) Advances in Spatial and Temporal Databases. SSTD 2003. Lecture Notes in Computer Science, vol 2750. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45072-6_15
Download citation
DOI: https://doi.org/10.1007/978-3-540-45072-6_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40535-1
Online ISBN: 978-3-540-45072-6
eBook Packages: Springer Book Archive