Indexing Graphs for Shortest Beer Path Queries

Authors David Coudert , Andrea D'Ascenzo , Mattia D'Emidio



PDF
Thumbnail PDF

File

OASIcs.ATMOS.2024.2.pdf
  • Filesize: 0.9 MB
  • 18 pages

Document Identifiers

Author Details

David Coudert
  • Université Côte d'Azur, Inria, I3S, CNRS, Sophia Antipolis, France
Andrea D'Ascenzo
  • Luiss University, Rome, Italy
Mattia D'Emidio
  • University of L'Aquila, Italy

Acknowledgements

Part of Andrea D'Ascenzo's work was carried out during his Ph.D. studies at University of L'Aquila.

Cite AsGet BibTex

David Coudert, Andrea D'Ascenzo, and Mattia D'Emidio. Indexing Graphs for Shortest Beer Path Queries. In 24th Symposium on Algorithmic Approaches for Transportation Modelling, Optimization, and Systems (ATMOS 2024). Open Access Series in Informatics (OASIcs), Volume 123, pp. 2:1-2:18, Schloss Dagstuhl – Leibniz-Zentrum für Informatik (2024)
https://doi.org/10.4230/OASIcs.ATMOS.2024.2

Abstract

A beer graph is an edge-weighted graph G = (V,E,ω) with beer vertices B ⊆ V. A beer path between two vertices s and t of a beer graph is a path that connects s and t and visits at least one vertex in B. The beer distance between two vertices is the weight of a shortest beer path, i.e. a beer path having minimum total weight. A graph indexing scheme is a two-phase method that constructs an index data structure by a one-time preprocessing of an input graph and then exploits it to compute (or accelerate the computation of) answers to queries on structures of the graph dataset. In the last decade, such indexing schemes have been designed to perform, effectively, many relevant types of queries, e.g. on reachability, and have gained significant popularity in essentially all data-intensive application domains where large number of queries have to be routinely answered (e.g. journey planners), since they have been shown, through many experimental studies, to offer extremely low query times at the price of limited preprocessing time and space overheads. In this paper, we showcase that an indexing scheme, to efficiently execute queries on beer distances or shortest beer paths for pairs of vertices of a beer graph, can be obtained by adapting the highway labeling, a recently introduced indexing method to accelerate the computation of classical shortest paths. We design a preprocessing algorithm to build a whl index, i.e. a weighted highway labeling of a beer graph, and show how it can be queried to compute beer distances and shortest beer paths. Through extensive experimentation on real networks, we empirically demonstrate its practical effectiveness and superiority, in terms of offered trade-off between preprocessing time, space overhead and query time, with respect to the state-of-the-art.

Subject Classification

ACM Subject Classification
  • Theory of computation → Graph algorithms analysis
  • Theory of computation → Shortest paths
  • Information systems → Information systems applications
Keywords
  • Graph Algorithms
  • Indexing Schemes
  • Beer Distances
  • Algorithms Engineering

Metrics

  • Access Statistics
  • Total Accesses (updated on a weekly basis)
    0
    PDF Downloads

References

  1. Takuya Akiba, Yoichi Iwata, and Yuichi Yoshida. Fast exact shortest-path distance queries on large networks by pruned landmark labeling. In Kenneth A. Ross, Divesh Srivastava, and Dimitris Papadias, editors, Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2013, New York, USA, pages 349-360. ACM, 2013. URL: https://doi.org/10.1145/2463676.2465315.
  2. Shikha Anirban, Junhu Wang, and Md. Saiful Islam. Experimental evaluation of indexing techniques for shortest distance queries on road networks. In 39th IEEE International Conference on Data Engineering (ICDE 2023) Anaheim, USA, pages 624-636. IEEE, 2023. URL: https://doi.org/10.1109/ICDE55515.2023.00054.
  3. Joyce Bacic, Saeed Mehrabi, and Michiel Smid. Shortest beer path queries in outerplanar graphs. In Hee-Kap Ahn and Kunihiko Sadakane, editors, 32nd International Symposium on Algorithms and Computation (ISAAC 2021), Fukuoka, Japan, volume 212 of LIPIcs, pages 62:1-62:16. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2021. URL: https://doi.org/10.4230/LIPICS.ISAAC.2021.62.
  4. Joyce Bacic, Saeed Mehrabi, and Michiel Smid. Shortest beer path queries in outerplanar graphs. Algorithmica, 85(6):1679-1705, 2023. URL: https://doi.org/10.1007/S00453-022-01045-4.
  5. Valentin Buchhold, Dorothea Wagner, Tim Zeitz, and Michael Zündorf. Customizable Contraction Hierarchies with Turn Costs. In Dennis Huisman and Christos D. Zaroliagis, editors, 20th Symposium on Algorithmic Approaches for Transportation Modelling, Optimization, and Systems (ATMOS 2020), volume 85 of Open Access Series in Informatics (OASIcs), pages 9:1-9:15, Dagstuhl, Germany, 2020. Schloss Dagstuhl - Leibniz-Zentrum für Informatik. URL: https://doi.org/10.4230/OASIcs.ATMOS.2020.9.
  6. Alessio Cionini, Gianlorenzo D'Angelo, Mattia D'Emidio, Daniele Frigioni, Kalliopi Giannakopoulou, Andreas Paraskevopoulos, and Christos D. Zaroliagis. Engineering graph-based models for dynamic timetable information systems. In Stefan Funke and Matús Mihalák, editors, 14th Workshop on Algorithmic Approaches for Transportation Modelling, Optimization, and Systems, ATMOS 2014, September 11, 2014, Wroclaw, Poland, volume 42 of OASIcs, pages 46-61. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2014. URL: https://doi.org/10.4230/OASICS.ATMOS.2014.46.
  7. Edith Cohen, Eran Halperin, Haim Kaplan, and Uri Zwick. Reachability and distance queries via 2-hop labels. SIAM J. Comput., 32(5):1338-1355, 2003. URL: https://doi.org/10.1137/S0097539702403098.
  8. Feliciano Colella, Mattia D'Emidio, and Guido Proietti. Simple and practically efficient fault-tolerant 2-hop cover labelings. In Dario Della Monica, Aniello Murano, Sasha Rubin, and Luigi Sauro, editors, Joint Proceedings of the 18th Italian Conference on Theoretical Computer Science (ICTCS 2017) and the 32nd Italian Conference on Computational Logic (CILC 2017), Naples, Italy, volume 1949 of CEUR Workshop Proceedings, pages 51-62. CEUR-WS.org, 2017. Google Scholar
  9. David Coudert, Andrea D'Ascenzo, and Mattia D'Emidio. D-hash/ShortestBeerDistanceQueries. Software (visited on 2024-09-20). URL: https://github.com/D-hash/ShortestBeerDistanceQueries.
  10. Gianlorenzo D'Angelo, Mattia D'Emidio, and Daniele Frigioni. Fully dynamic 2-hop cover labeling. ACM J. Exp. Algorithmics, 24(1):1.6:1-1.6:36, 2019. URL: https://doi.org/10.1145/3299901.
  11. Rathish Das, Meng He, Eitan Kondratovsky, J. Ian Munro, Anurag Murty Naredla, and Kaiyu Wu. Shortest beer path queries in interval graphs. In Sang Won Bae and Heejin Park, editors, 33rd International Symposium on Algorithms and Computation (ISAAC 2022), Seoul, Korea, volume 248 of LIPIcs, pages 59:1-59:17. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2022. URL: https://doi.org/10.4230/LIPICS.ISAAC.2022.59.
  12. Andrea D'Ascenzo and Mattia D'Emidio. Top-k distance queries on large time-evolving graphs. IEEE Access, 11:102228-102242, 2023. URL: https://doi.org/10.1109/ACCESS.2023.3316602.
  13. Daniel Delling, Julian Dibbelt, Thomas Pajor, and Tobias Zündorf. Faster Transit Routing by Hyper Partitioning. In Gianlorenzo D'Angelo and Twan Dollevoet, editors, 17th Workshop on Algorithmic Approaches for Transportation Modelling, Optimization, and Systems (ATMOS 2017), volume 59 of Open Access Series in Informatics (OASIcs), pages 8:1-8:14, Dagstuhl, Germany, 2017. Schloss Dagstuhl - Leibniz-Zentrum für Informatik. URL: https://doi.org/10.4230/OASIcs.ATMOS.2017.8.
  14. Daniel Delling, Andrew V. Goldberg, Thomas Pajor, and Renato F. Werneck. Robust distance queries on massive networks. In Andreas S. Schulz and Dorothea Wagner, editors, Proceedings of the 22th Annual European Symposium on Algorithms (ESA 2014), Wroclaw, Poland, volume 8737 of Lecture Notes in Computer Science, pages 321-333. Springer, 2014. URL: https://doi.org/10.1007/978-3-662-44777-2_27.
  15. Julian Dibbelt, Thomas Pajor, Ben Strasser, and Dorothea Wagner. Connection scan algorithm. ACM J. Exp. Algorithmics, 23, 2018. URL: https://doi.org/10.1145/3274661.
  16. Edsger W. Dijkstra. A note on two problems in connexion with graphs. In Krzysztof R. Apt and Tony Hoare, editors, Edsger Wybe Dijkstra: His Life, Work, and Legacy, volume 45 of ACM Books, pages 287-290. ACM / Morgan & Claypool, 2022. URL: https://doi.org/10.1145/3544585.3544600.
  17. Jochen Eisner and Stefan Funke. Sequenced route queries: getting things done on the way back home. In Proceedings of the 20th International Conference on Advances in Geographic Information Systems, SIGSPATIAL 2012, pages 502-505, New York, NY, USA, 2012. ACM. URL: https://doi.org/10.1145/2424321.2424400.
  18. Muhammad Farhan, Koehler Henning, and Qing Wang. BatchHL^+: batch dynamic labelling for distance queries on large-scale networks. The VLDB Journal, pages 1-29, 2023. URL: https://doi.org/10.1007/s00778-023-00799-9.
  19. Muhammad Farhan and Qing Wang. Efficient maintenance of highway cover labelling for distance queries on large dynamic graphs. World Wide Web (WWW), 26(5):2427-2452, 2023. URL: https://doi.org/10.1007/S11280-023-01146-2.
  20. Muhammad Farhan, Qing Wang, Yu Lin, and Brendan D. McKay. A highly scalable labelling approach for exact distance queries in complex networks. In Melanie Herschel, Helena Galhardas, Berthold Reinwald, Irini Fundulaki, Carsten Binnig, and Zoi Kaoudi, editors, Proceedings of 22nd International Conference on Extending Database Technology (EDBT 2019), Lisbon, Portugal, pages 13-24. OpenProceedings.org, 2019. URL: https://doi.org/10.5441/002/EDBT.2019.03.
  21. Roy Friedman and Alex Kogan. Deterministic dominating set construction in networks with bounded degree. In Marcos K. Aguilera, Haifeng Yu, Nitin H. Vaidya, Vikram Srinivasan, and Romit Roy Choudhury, editors, Distributed Computing and Networking, pages 65-76, Berlin, Heidelberg, 2011. Springer Berlin Heidelberg. Google Scholar
  22. Joachim Gudmundsson and Yuan Sha. Shortest beer path queries in digraphs with bounded treewidth. In Satoru Iwata and Naonori Kakimura, editors, 34th International Symposium on Algorithms and Computation, ISAAC 2023, December 3-6, 2023, Kyoto, Japan, volume 283 of LIPIcs, pages 35:1-35:17. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2023. URL: https://doi.org/10.4230/LIPICS.ISAAC.2023.35.
  23. Tesshu Hanaka, Hirotaka Ono, Kunihiko Sadakane, and Kosuke Sugiyama. Shortest beer path queries based on graph decomposition. In Satoru Iwata and Naonori Kakimura, editors, 34th International Symposium on Algorithms and Computation (ISAAC 2023), Kyoto, Japan, volume 283 of LIPIcs, pages 37:1-37:20. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2023. URL: https://doi.org/10.4230/LIPICS.ISAAC.2023.37.
  24. Vassilis Kaffes, Alexandros Belesiotis, Dimitrios Skoutas, and Spiros Skiadopoulos. Finding shortest keyword covering routes in road networks. In Proceedings of the 30th International Conference on Scientific and Statistical Database Management, pages 1-12, 2018. Google Scholar
  25. Vassilissa Lehoux and Christelle Loiodice. Faster preprocessing for the trip-based public transit routing algorithm. In Dennis Huisman and Christos D. Zaroliagis, editors, 20th Symposium on Algorithmic Approaches for Transportation Modelling, Optimization, and Systems, ATMOS 2020, September 7-8, 2020, Pisa, Italy (Virtual Conference), volume 85 of OASIcs, pages 3:1-3:12. Schloss Dagstuhl - Leibniz-Zentrum für Informatik, 2020. URL: https://doi.org/10.4230/OASICS.ATMOS.2020.3.
  26. Jure Leskovec and Rok Sosič. Snap: A general-purpose network analysis and graph-mining library. ACM Trans. Intell. Syst. Technol., 8(1), July 2016. URL: https://doi.org/10.1145/2898361.
  27. Huiping Liu, Cheqing Jin, Bin Yang, and Aoying Zhou. Finding top-k optimal sequenced routes. In 34th IEEE International Conference on Data Engineering, ICDE 2018, Paris, France, April 16-19, 2018, pages 569-580. IEEE Computer Society, 2018. URL: https://doi.org/10.1109/ICDE.2018.00058.
  28. Catherine C. McGeoch. A Guide to Experimental Algorithmics. Cambridge University Press, 2012. Google Scholar
  29. Michael N. Rice and Vassilis J. Tsotras. Engineering generalized shortest path queries. In Christian S. Jensen, Christopher M. Jermaine, and Xiaofang Zhou, editors, 29th IEEE International Conference on Data Engineering, ICDE 2013, Brisbane, Australia, April 8-12, 2013, pages 949-960. IEEE Computer Society, 2013. URL: https://doi.org/10.1109/ICDE.2013.6544888.
  30. Mehdi Sharifzadeh, Mohammad Kolahdouzan, and Cyrus Shahabi. The optimal sequenced route query. The VLDB journal, 17:765-787, 2008. Google Scholar
  31. Chao Zhang, Angela Bonifati, and M. Tamer Özsu. An overview of reachability indexes on graphs. In Companion of the 2023 International Conference on Management of Data, SIGMOD 2023, pages 61-68, New York, NY, USA, 2023. ACM. URL: https://doi.org/10.1145/3555041.3589408.
  32. Junhua Zhang, Long Yuan, Wentao Li, Lu Qin, Ying Zhang, and Wenjie Zhang. Label-constrained shortest path query processing on road networks. The VLDB Journal, 33:569-593, 2024. URL: https://doi.org/10.1007/s00778-023-00825-w.
  33. Yikai Zhang and Jeffrey Xu Yu. Hub labeling for shortest path counting. In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, SIGMOD 2020, pages 1813-1828, New York, NY, USA, 2020. Association for Computing Machinery. URL: https://doi.org/10.1145/3318464.3389737.
  34. Zibin Zheng, Fanghua Ye, Rong-Hua Li, Guohui Ling, and Tan Jin. Finding weighted k-truss communities in large networks. Information Sciences, 417:344-360, 2017. URL: https://doi.org/10.1016/j.ins.2017.07.012.
  35. Huaijie Zhu, Wenbin Li, Wei Liu, Jian Yin, and Jianliang Xu. Top k optimal sequenced route query with POI preferences. Data Sci. Eng., 7(1):3-15, 2022. URL: https://doi.org/10.1007/S41019-022-00177-5.
Questions / Remarks / Feedback
X

Feedback for Dagstuhl Publishing


Thanks for your feedback!

Feedback submitted

Could not send message

Please try again later or send an E-mail