Abstract
As Geographic Information Systems (GIS) technologies have evolved, more and more GIS applications and geospatial data are available on the web. Spatial objects in a given query range can be retrieved using spatial range query − one of the most widely used query types in GIS and spatial databases. However, it can be challenging to retrieve these data from various web applications where access to the data is only possible through restrictive web interfaces that support certain types of queries. A typical scenario is the existence of numerous business web sites that provide their branch locations through a limited “nearest location” web interface. For example, a chain restaurant’s web site such as McDonalds can be queried to find some of the closest locations of its branches to the user’s home address. However, even though the site has the location data of all restaurants in, for example, the state of California, it is difficult to retrieve the entire data set efficiently due to its restrictive web interface. Considering that k-Nearest Neighbor (k-NN) search is one of the most popular web interfaces in accessing spatial data on the web, this paper investigates the problem of retrieving geospatial data from the web for a given spatial range query using only k-NN searches. Based on the classification of k-NN interfaces on the web, we propose a set of range query algorithms to completely cover the rectangular shape of the query range (completeness) while minimizing the number of k-NN searches as possible (efficiency). We evaluated the efficiency of the proposed algorithms through statistical analysis and empirical experiments using both synthetic and real data sets.


















Similar content being viewed by others
Notes
Actually, overestimation introduce a slight overhead in each cost function but it is way lower than the overhead caused by underestimation.
The terms, CDT and DCDT, are used for both the corresponding triangulation algorithms and the data structures that support these algorithms in this chapter.
References
Barish G, Chen Y, Dipasquo D, Knoblock CA, Minton S, Muslea I, Shahabi C (2000) Theaterloc: using information integration technology to rapidly build virtual application. In: Proceedings of international conf. on data engineering (ICDE), 28 February–3 March 2000, San Diego, pp 681–682
Bae WD, Alkobaisi S, Kim SH, Narayanappa S, Shahabi C (2007) Supporting range queries on web data using k-nearest neighbor search. In: Proceedings of the 7th international symposium on web and wireless GIS (W2GIS 2007), 28–29 November 2007, Cardiff, pp 61–75
Bae WD, Alkobaisi S, Kim SH, Narayanappa S, Shahabi C (2007) Supporting range queries on web data using k-nearest neighbor search. Technical report DU-CS-08-01, University of Denver
Byers S, Freire J, Silva C (2001) Efficient acquisition of web data through restricted query interface. In: Poster proceedings of the world wide web conference (WWW10), Hong Kong, 1–5 May 2001, pp 184–185
Chew LP (1989) Constrained Delaunay triangulations. Algorithmica 4(1):97–108
Dickerson M, Drysdale R, Sack J (1992) Simple algorithms for enumerating interpoint distances and finding k nearest neighbors. Int J Comput Geom Appl 2:221–239
Eppstein D, Erickson J (1994) Interated nearest neighbors and finding minimal polytypes. Discrete Comput Geom 11:321–350
Gaede V, Gounter O (1998) Multidimensional access methods. ACM Comput Surv 30(2):170–231
Hieu LQ (2005) Integration of web data sources: a survey of existing problems. In: Proceedings of the 17th GI-workshop on the foundations of databases (GvD), Wörlitz, 17–20 May 2005
Liu D, Lim E, Ng W (2002) Efficient k nearest neighbor queries on remote spatial databases using range estimation. In: Proceedings of international conf. on scientific and statistical databases management (SSDMB), Edinburgh, 24–26 July 2002, pp 121–130
Mergerian S, Koushanfar F (2005) Worst and best-case coverage in sensor networks. IEEE Trans Mob Comput 4(1):84–92
Nie Z, Kambhampati S, Nambiar U (2005) Effectively mining and using coverage and overlap statistics for data integration. IEEE Trans Knowl Data Eng 17(5):638–651, May
Roussopoulos N, Kelley S, Vincent F (1995) Nearest neighbor queries. In: Proceedings of ACM SIGMOD, San Jose, May 1995, pp 71–79
Samet H (1985) Data structures for quadtree approximation and compression. Commun ACM 28(9):973–993, September
Sharifzadeh M, Shahabi C (2006) Utilizing voronoi cells of location data streams for accurate computation of aggregate functions in sensor networks. GeoInformatica 10(1):9–36
Song Z, Roussonpoulos N (2001) K-nearest neighbor search for moving query point. In: Proceedings of international symposium on spatial and temporal databases (SSTD), Redondo Beach, 12–15 July 2001, pp 79–96
Tao U, Zhang U, Papadias D, Mamoulis N (2004) An efficient cost model for optimization of nearest neighbor search in low and medium dimensional spaces. IEEE Trans Knowl Data Eng 16(10):1169–1184, October
USGS (2001) USGS mineral resources on-line spatial data. http://tin.er.usgs.gov/
Wang G, Cao G, Porta TL (2003) Movement-assisted sensor deployment. In: Proceedings of IEEE INFOCOM, San Francisco, 30 March–3 April 2003, pp 2469–2479
Wang S, Armstrong MP (2003) A quadtree approach to domain decomposition for spatial interpolation in grid computing environments. Parallel Comput 29(3):1481–1504, April
Wu C, Lee K, Chung Y (2006) A Delaunay triangulation based method for wireless sensor network deployment. In: Proceedings of ICPADS, Minneapolis, July 2006, pp 253–260
Yerneni R, Li C, Garcia-Molina H, Ullman J (1999) Computing capabilities of mediators. In: Proceedings of SIGMOD, Philadelphia, 1–3 June 1999, pp 443–454
Acknowledgements
The authors thank Prof. Petr Vojtěchovský for providing helpful suggestions and Brandon Haenlein for the valuable discussions throughout this work.
Author information
Authors and Affiliations
Corresponding author
Additional information
The author’s work is supported in part by the National Science Foundation under award numbers IIS-0324955 (ITR), EEC-9529152 (IMSC ERC) and IIS-0238560 (PECASE) and in part by unrestricted cash gifts from Microsoft and Google. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the National Science Foundation.
Rights and permissions
About this article
Cite this article
Bae, W.D., Alkobaisi, S., Kim, S.H. et al. Web data retrieval: solving spatial range queries using k-nearest neighbor searches. Geoinformatica 13, 483–514 (2009). https://doi.org/10.1007/s10707-008-0055-2
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10707-008-0055-2