Skip to main content
Log in

Dynamic monitoring of optimal locations in road network databases

  • Regular Paper
  • Published:
The VLDB Journal Aims and scope Submit manuscript

Abstract

Optimal location (OL) queries are a type of spatial queries that are particularly useful for the strategic planning of resources. Given a set of existing facilities and a set of clients, an OL query asks for a location to build a new facility that optimizes a certain cost metric (defined based on the distances between the clients and the facilities). Several techniques have been proposed to address OL queries, assuming that all clients and facilities reside in an \(L_p\) space. In practice, however, movements between spatial locations are usually confined by the underlying road network, and hence, the actual distance between two locations can differ significantly from their \(L_p\) distance. Motivated by the deficiency of the existing techniques, this paper presents a comprehensive study on OL queries in road networks. We propose a unified framework that addresses three variants of OL queries that find important applications in practice, and we instantiate the framework with several novel query processing algorithms. We further extend our framework to efficiently monitor the OLs when locations for facilities and/or clients have been updated. Our dynamic update methods lead to efficient answering of continuous optimal location queries. We demonstrate the efficiency of our solutions through extensive experiments with large real data.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14
Fig. 15
Fig. 16
Fig. 17
Fig. 18
Fig. 19
Fig. 20
Fig. 21
Fig. 22
Fig. 23
Fig. 24
Fig. 25
Fig. 26
Fig. 27
Fig. 28
Fig. 29
Fig. 30
Fig. 31
Fig. 32
Fig. 33
Fig. 34
Fig. 35
Fig. 36
Fig. 37
Fig. 38
Fig. 39
Fig. 40
Fig. 41

Similar content being viewed by others

Notes

  1. Note that we cannot apply Blossom on \(G_i\) directly, since a candidate location in \(G_i\) may attract a client outside \(G_i\).

References

  1. Berg, M., Cheong, O., van Kreveld, M., Overmars, M.: Computational Geometry: Algorithms and Applications, 3rd edn. Springer, Berlin (2008)

    Book  Google Scholar 

  2. Cabello, S., Díaz-Báñez, J.M., Langerman, S., Seara, C., Ventura, I.: Reverse facility location problems. In: Proceedings of the Canadian Conference on Computational Geometry (CCCG), pp. 68–71 (2005)

  3. Chen, Z., Shen, H.T., Zhou, X., Yu, J.X.: Monitoring path nearest neighbor in road networks. In: Proc. of ACM Management of Data (SIGMOD), pp. 591–602 (2009)

  4. Deng, K., Zhou, X., Shen, H.T., Sadiq, S., Li, X.: Instance optimal query processing in spatial networks. VLDB J 18(3), 675–693 (2009)

    Article  Google Scholar 

  5. Dijkstra, E.W.: A note on two problems in connexion with graphs. Numer. Math. 1, 269–271 (1959)

    Article  MATH  MathSciNet  Google Scholar 

  6. Du, Y., Zhang, D., Xia, T.: The optimal-location query. In: Proceedings of Symposium on Advances in Spatial and Temporal Databases (SSTD), pp. 163–180 (2005)

  7. Erwig, M., Hagen, F.: The graph Voronoi diagram with applications. Networks 36, 156–163 (2000)

    Article  MATH  MathSciNet  Google Scholar 

  8. Farahani, R.Z., Hekmatfar, M.: Facility Location: Concepts, Models, Algorithms and Case Studies, 1st edn. Physica-Verlag, Heidelberg (2009)

    Book  Google Scholar 

  9. Fotakis, D.: Incremental algorithms for facility location and \(k\)-median. Theor. Comput. Sci. 361(2–3), 275–313 (2006)

    Article  MATH  MathSciNet  Google Scholar 

  10. Ghaemi, P., Shahabi, K., Wilson, J., Banaei-Kashani, F.: Optimal network location queries. In: Proceedings of ACM Symposium on Advances in Geographic Information Systems (GIS), pp. 478–481 (2010)

  11. Ghaemi, P., Shahabi, K., Wilson, J., Banaei-Kashani, F.: Continuous maximal reverse nearest query on spatial networks. In: Proceedings of ACM Symposium on Advances in Geographic Information Systems (GIS) (2012)

  12. Ghaemi, P., Shahabi, K., Wilson, J., Banaei-Kashani, F.: A comparative study of two approaches for supporting optimal network location queries. GeoInformatica 17(2) (2013)

  13. Hershberger, J.: Finding the upper envelope of \(n\) line segments in \(o(n \log n)\) time. Inf. Process. Lett. 33(4), 169–174 (1989)

    Article  MATH  MathSciNet  Google Scholar 

  14. Huang, Z., Lu, H., Ooi, B.C., Tung, A.K.H.: Continuous skyline queries for moving objects. IEEE Trans. Knowl. Data Eng. 18(12), 1645–1658 (2006)

    Article  Google Scholar 

  15. Jensen, C.S., Kolářvr, J., Pedersen, T.B., Timko, I.: Nearest neighbor queries in road networks. In: Proceedings of ACM Symposium on Advances in Geographic Information Systems (GIS), pp. 1–8 (2003)

  16. Kolahdouzan, M.R., Shahabi, C.: Voronoi-based k-nearest neighbor search for spatial network databases. In: Proceedings of Very Large Data Bases (VLDB), pp. 840–851 (2004)

  17. Meyerson, A.: Online facility location. In: Symposium on Foundations of Computer Science (FOCS), pp. 426–431 (2001)

  18. Morse, M.D., Patel, J.M., Grosky, W.I.: Efficient continuous skyline computation. In: ICDE, p. 108 (2006)

  19. Mouratidis, K., Yiu, M.L., Papadias, D., Mamoulis, N.: Continuous nearest neighbor monitoring in road networks. In: Proceedings of Very Large Data Bases (VLDB), pp. 43–54 (2006)

  20. Nickel, S., Puerto, J.: Location Theory: A Unified Approach, 1st edn. Springer, Berlin (2005)

    Google Scholar 

  21. Papadias, D., Zhang, J., Mamoulis, N., Tao, Y.: Query processing in spatial network databases. In: Proceedings of Very Large Data Bases (VLDB), pp. 802–813 (2003)

  22. Samet, H., Sankaranarayanan, J., Alborzi, H.: Scalable network distance browsing in spatial databases. In: Proceedings of ACM Management of Data (SIGMOD), pp. 43–54 (2008)

  23. Sankaranarayanan, J., Samet, H.: Distance oracles for spatial networks. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 652–663 (2009)

  24. Sankaranarayanan, J., Samet, H., Alborzi, H.: Path oracles for spatial networks. PVLDB 2(1), 1210–1221 (2009)

    Google Scholar 

  25. Shekhar, S., Liu, D.R.: CCAM: a connectivity-clustered access method for networks and network computations. IEEE Trans. Knowl. Data Eng. (TKDE) 9(1), 102–119 (1997)

    Article  Google Scholar 

  26. Wong, R.C.W., Özsu, T., Yu, P.S., Fu, A.W.C., Liu, L.: Efficient method for maximizing bichromatic reverse nearest neighbor. Proc. VLDB Endow. (PVLDB) 2(1), 1126–1137 (2009)

    Article  Google Scholar 

  27. Xiao, X., Yao, B., Li, F.: Optimal location queries in road network databases. In: ICDE, pp. 804–815 (2011)

  28. Yiu, M.L., Mamoulis, N., Papadias, D.: Aggregate nearest neighbor queries in road networks. IEEE Trans. Knowl. Data Eng. (TKDE) 17(6), 820–833 (2005)

    Article  Google Scholar 

  29. Zhang, D., Du, Y., Xia, T., Tao, Y.: Progressive computation of the min-dist optimal-location query. In: Proceedings of Very Large Data Bases (VLDB), pp. 643–654 (2006)

Download references

Acknowledgments

Bin Yao was supported by the NSFC (Grant No. 61202025), the 863 Program of China (Grant No. 2011AA01A202), the Program for Changjiang Scholars and Innovative Research Team in University of China (IRT1158, PCSIRT), Shanghai Excellent Academic Leaders Plan (No. 11XD1402900), Microsoft Research Asia (the Urban Informatics Research Grant), and the STCSM (Grant No. 12ZR1414900). Xiaokui Xiao was supported by the Nanyang Technological University under SUG Grant M58020016 and by Microsoft Research Asia under an Urban Informatics Research Grant. Feifei Li was supported in part by NSF Grant IIS-1251019.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Feifei Li.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Yao, B., Xiao, X., Li, F. et al. Dynamic monitoring of optimal locations in road network databases. The VLDB Journal 23, 697–720 (2014). https://doi.org/10.1007/s00778-013-0347-5

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00778-013-0347-5

Keywords

Navigation