skip to main content
research-article

Finding Alternative Shortest Paths in Spatial Networks

Published: 01 December 2012 Publication History

Abstract

Shortest path query is one of the most fundamental queries in spatial network databases. There exist algorithms that can process shortest path queries in real time. However, many complex applications require more than just the calculation of a single shortest path. For example, one of the common ways to determine the importance (or price) of a vertex or an edge in spatial network is to use Vickrey pricing, which intuitively values the vertex v (or edge e) based on how much harder for travelling from the sources to the destinations without using v (or e). In such cases, the alternative shortest paths without using v (or e) are required. In this article, we propose using a precomputation based approach for both single pair alternative shortest path and all pairs shortest paths processing. To compute the alternative shortest path between a source and a destination efficiently, a naïive way is to precompute and store all alternative shortest paths between every pair of vertices avoiding every possible vertex (or edge), which requires O(n4) space. Currently, the state of the art approach for reducing the storage cost is to choose a subset of the vertices as center points, and only store the single-source alternative shortest paths from those center points. Such approach has the space complexity of O(n2 log n). We propose a storage scheme termed iSPQF, which utilizes shortest path quadtrees by observing the relationships between each avoiding vertex and its corresponding alternative shortest paths. We have reduced the space complexity from the naïive O(n4) (or the state of the art O(n4 log n)) to O(min(γ, L)n1.5) with comparable query performance of O(K), where K is the number of vertices in the returned paths, L is the diameter of the spatial network, and γ is a value that depends on the structure of the spatial network, which is empirically estimated to be 40 for real road networks. Experiments on real road networks have shown that the space cost of the proposed iSPQF is scalable, and both the algorithms based on iSPQF are efficient.

References

[1]
Ball, M., Golden, B., and Vohra, R. 1989. Finding the most vital arcs in a network. Oper. Resear. Lett. 8, 2, 73--76.
[2]
Bernstein, A. and Karger, D. 2008. Improved distance sensitivity oracles via random sampling. In Proceedings of the 19th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA’08). SIAM, Philadelphia, PA, 34--43.
[3]
Bernstein, A. and Karger, D. 2009. A nearly optimal oracle for avoiding failed vertices and edges. In Proceedings of the 41st Annual ACM Symposium on Theory of Computing (STOC’09). ACM, New York, NY, 101--110.
[4]
Bresenham, J. E. 1965. Algorithm for computer control of a digital plotter. IBM Syst. J. 4, 25--30.
[5]
Cho, H.-J. and Chung, C.-W. 2005. An efficient and scalable approach to cnn queries in a road network. In Proceedings of the 31st International Conference on Very Large Data Bases (VLDB’05). VLDB Endowment, 865--876.
[6]
Chowdhury, R. A. and Ramachandran, V. 2002. Improved distance oracles for avoiding link-failure. In Proceedings of the 13th International Symposium on Algorithms and Computation (ISAAC’02). Springer, 523--534.
[7]
Demetrescu, C. and Italiano, G. F. 2004. A new approach to dynamic all pairs shortest paths. J. ACM 51, 968--992.
[8]
Demetrescu, C., Thorup, M., Chowdhury, R. A., and Ramachandran, V. 2008. Oracles for distances avoiding a failed node or link. SIAM J. Comput. 37, 1299--1318.
[9]
Dijkstra, E. 1959. A note on two problems in connexion with graphs. Numerische mathematik 1, 1, 269--271.
[10]
Duan, R. and Pettie, S. 2009. Dual-failure distance and connectivity oracles. In Proceedings of the 20th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA’09). SIAM, Philadelphia, PA, 506--515.
[11]
Emek, Y., Peleg, D., and Roditty, L. 2008. A near-linear time algorithm for computing replacement paths in planar directed graphs. In Proceedings of the 19th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA’08). SIAM, Philadelphia, PA, 428--435.
[12]
Fredman, M. L. and Tarjan, R. E. 1987. Fibonacci heaps and their uses in improved network optimization algorithms. J. ACM 34, 596--615.
[13]
Frigioni, D., Marchetti-Spaccamela, A., and Nanni, U. 1996. Fully dynamic output bounded single source shortest path problem. In Proceedings of the 7th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA’96). SIAM, Philadelphia, PA, 212--221.
[14]
Frigioni, D., Marchetti-Spaccamela, A., and Nanni, U. 2000. Fully dynamic algorithms for maintaining shortest paths trees. J. Algorithms 34, 251--281.
[15]
Goldberg, A. V. and Harrelson, C. 2005. Computing the shortest path: A search meets graph theory. In Proceedings of the 16th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA’05). SIAM, Philadelphia, PA, 156--165.
[16]
Hershberger, J. and Suri, S. 2001. Vickrey prices and shortest paths: What is an edge worth? In Proceedings of the 42nd IEEE Symposium on Foundations of Computer Science (FOCS’01). IEEE, 252--259.
[17]
Hershberger, J., Suri, S., and Bhosle, A. 2007. On the difficulty of some shortest path problems. ACM Trans. Algorithms 3, 5, 1--15.
[18]
Johnson, D. B. 1977. Efficient algorithms for shortest paths in sparse networks. J. ACM 24, 1--13.
[19]
Jung, S. and Pramanik, S. 2002. An efficient path computation model for hierarchically structured topographical road maps. IEEE Trans. Knowl. Data Engin. 14, 1029--1046.
[20]
King, V. 1999. Fully dynamic algorithms for maintaining all-pairs shortest paths and transitive closure in digraphs. In Proceedings of the 40th Annual Symposium on Foundations of Computer Science (FOCS’99). IEEE, 81--89.
[21]
Li, F., Cheng, D., Hadjieleftheriou, M., Kollios, G., and Teng, S.-H. 2005. On trip planning queries in spatial databases. In Advances in Spatial and Temporal Databases, C. Bauzer Medeiros, M. Egenhofer, and E. Bertino Eds., Lecture Notes in Computer Science, vol. 3633. Springer, 923--923.
[22]
Papadias, D., Zhang, J., Mamoulis, N., and Tao, Y. 2003. Query processing in spatial network databases. In Proceedings of the 29th International Conference on Very Large Data Bases (VLDB’03). VLDB Endowment, 802--813.
[23]
Roditty, L. and Zwick, U. 2005. Replacement paths and k simple shortest paths in unweighted directed graphs. In Automata, Languages and Programming, L. Caires, G. Italiano, L. Monteiro, C. Palamidessi, and M. Yung Eds., Lecture Notes in Computer Science, vol. 3580. Springer, 249--260.
[24]
Samet, H. 2005. Foundations of Multidimensional and Metric Data Structures. Morgan Kaufmann Publishers Inc., San Francisco, CA.
[25]
Samet, H., Sankaranarayanan, J., and Alborzi, H. 2008. Scalable network distance browsing in spatial databases. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD’08). ACM, New York, NY, 43--54.
[26]
Sankaranarayanan, J. and Samet, H. 2009. Distance oracles for spatial networks. In Proceedings of the IEEE International Conference on Data Engineering. IEEE, 652--663.
[27]
Sankaranarayanan, J., Alborzi, H., and Samet, H. 2005. Efficient query processing on spatial networks. In Proceedings of the 13th Annual ACM International Workshop on Geographic Information Systems (GIS’05). ACM, New York, NY, 200--209.
[28]
Sankaranarayanan, J., Samet, H., and Alborzi, H. 2009. Path oracles for spatial networks. Proc. VLDB Endow. 2, 1210--1221.

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Transactions on Database Systems
ACM Transactions on Database Systems  Volume 37, Issue 4
December 2012
345 pages
ISSN:0362-5915
EISSN:1557-4644
DOI:10.1145/2389241
Issue’s Table of Contents
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 December 2012
Accepted: 01 July 2012
Revised: 01 May 2012
Received: 01 July 2011
Published in TODS Volume 37, Issue 4

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. Spatial networks
  2. real-time query processing
  3. shortest paths

Qualifiers

  • Research-article
  • Research
  • Refereed

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)11
  • Downloads (Last 6 weeks)2
Reflects downloads up to 31 Jan 2025

Other Metrics

Citations

Cited By

View all

View Options

Login options

Full Access

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media