Database Theory in Action: Cypher, GQL, and Regular Path Queries

Authors Amélie Gheerbrant , Leonid Libkin , Liat Peterfreund , Alexandra Rogova



PDF
Thumbnail PDF

File

LIPIcs.ICDT.2025.36.pdf
  • Filesize: 0.59 MB
  • 5 pages

Document Identifiers

Author Details

Amélie Gheerbrant
  • Université Paris Cité, CNRS, IRIF, France
Leonid Libkin
  • RelationalAI and IRIF, CNRS, Paris, France
  • University of Edinburgh, UK
Liat Peterfreund
  • The Hebrew University of Jerusalem, Israel
Alexandra Rogova
  • Université Paris Cité, CNRS, IRIF, France

Cite As Get BibTex

Amélie Gheerbrant, Leonid Libkin, Liat Peterfreund, and Alexandra Rogova. Database Theory in Action: Cypher, GQL, and Regular Path Queries. In 28th International Conference on Database Theory (ICDT 2025). Leibniz International Proceedings in Informatics (LIPIcs), Volume 328, pp. 36:1-36:5, Schloss Dagstuhl – Leibniz-Zentrum für Informatik (2025) https://doi.org/10.4230/LIPIcs.ICDT.2025.36

Abstract

Cypher has so far been the most commonly used query language for property graphs, and served as the foundation of the recently standardized graph query language GQL. In designing the features of GQL, the standards committee addressed the perceived limitations of Cypher. One such limitation is the inability of Cypher, as originally designed, to express all regular path queries (RPQs). Despite this claim having been stated many times as a folklore result, we could not find any proof of it. In this note we formalize the core of Cypher’s pattern matching and formally prove that indeed it falls short of all RPQs, justifying the inclusion of new pattern matching features in GQL.

Subject Classification

ACM Subject Classification
  • Information systems → Graph-based database models
Keywords
  • Regular path queries
  • Cypher
  • GQL
  • inexpressibility

Metrics

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

References

  1. Renzo Angles, Marcelo Arenas, Pablo Barceló, Aidan Hogan, Juan L. Reutter, and Domagoj Vrgoč. Foundations of modern query languages for graph databases. ACM Comput. Surv., 50(5):68:1-68:40, 2017. URL: https://doi.org/10.1145/3104031.
  2. Angela Bonifati, George H. L. Fletcher, Hannes Voigt, and Nikolay Yakovets. Querying Graphs. Morgan & Claypool Publishers, 2018. URL: https://doi.org/10.2200/S00873ED1V01Y201808DTM051.
  3. Alin Deutsch, Nadime Francis, Alastair Green, Keith Hare, Bei Li, Leonid Libkin, Tobias Lindaaker, Victor Marsault, Wim Martens, Jan Michels, Filip Murlak, Stefan Plantikow, Petra Selmer, Hannes Voigt, Oskar van Rest, Domagoj Vrgoč, Mingxi Wu, and Fred Zemke. Graph pattern matching in GQL and SQL/PGQ. In SIGMOD, pages 1-12. ACM, 2022. URL: https://arxiv.org/abs/2112.06217.
  4. Nadime Francis, Amélie Gheerbrant, Paolo Guagliardo, Leonid Libkin, Victor Marsault, Wim Martens, Filip Murlak, Liat Peterfreund, Alexandra Rogova, and Domagoj Vrgoc. GPC: A pattern calculus for property graphs. In Floris Geerts, Hung Q. Ngo, and Stavros Sintos, editors, Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, PODS 2023, Seattle, WA, USA, June 18-23, 2023, pages 241-250. ACM, 2023. URL: https://doi.org/10.1145/3584372.3588662.
  5. Nadime Francis, Alastair Green, Paolo Guagliardo, Leonid Libkin, Tobias Lindaaker, Victor Marsault, Stefan Plantikow, Mats Rydberg, Petra Selmer, and Andrés Taylor. Cypher: An evolving query language for property graphs. In Proceedings of the 2018 International Conference on Management of Data, pages 1433-1445, New York, NY, USA, 2018. Association for Computing Machinery. URL: https://doi.org/10.1145/3183713.3190657.
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