Worst-Case Optimal Graph Joins in Almost No Space
Diego Arroyuelo, Aidan Hogan, Gonzalo Navarro, Juan L. Reutter, Javiel Rojas-Ledesma, Adrián Soto
Abstract
We present an indexing scheme that supports worst-case optimal (wco) joins over graphs within compact space. Supporting all possible wco joins using conventional data structures -based on B(+)-Trees, tries, etc. -requires 6 index orders in the case of graphs represented as triples. We rather propose a form of index, which we call a ring, that indexes each triple as a set of cyclic bidirectional strings of length 3. Rather than maintaining 6 orderings, we can use one ring to index them all. This ring replaces the graph and uses only sublinear extra space on top of the graph; in order words, the ring supports worst-case optimal graph joins in almost no space beyond storing the graph itself. We perform experiments using our representation to index a large graph (Wikidata) in memory, over which wco join algorithms are implemented. Our experiments show that the ring offers the best overall performance for query times while using only a small fraction of the space when compared with several state-of-the-art approaches.
• Theory of computation → Database query processing and optimization (theory); Data structures and algorithms for data management.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext d41bddc2-7f91-49ca-8061-0445c4d729ecCited by top-tier papers8
- Time- and Space-Efficient Regular Path QueriesDiego Arroyuelo, Aidan Hogan, Gonzalo Navarro, Javiel Rojas-LedesmaICDE 2022 · 17 citations
- Worst-Case-Optimal Similarity Joins on Graph DatabasesDiego Arroyuelo, Benjamin Bustos, Adrián Gómez-Brandón, Aidan Hogan et al.SIGMOD 2024 · 3 citations
- Sorting on Byte-Addressable Storage: The Resurgence of Tree StructureYing Zheng, Kian-Lee TanVLDB 2024 · 2 citations
- MWP: Multi-Window Parallel Evaluation of Regular Path Queries on Streaming GraphsSiyuan Zhang, Zhenying He, Yinan Jing, Kai Zhang et al.SIGMOD 2024 · 2 citations
- Worst-Case-Optimal Joins on Graphs with Topological RelationsJosé Fuentes-Sepúlveda, Adrián Gómez-Brandón, Aidan Hogan, Ayleen Irribarra-Cortés et al.WWW 2025 · 2 citations
Builds on1
Related papers
- Worst-Case Optimal BGPs on Temporal GraphsDiego Arroyuelo, Aidan Hogan, Gonzalo Navarro, Juan L. ReutterVLDB 2026
- Free Join: Unifying Worst-Case Optimal and Traditional JoinsYisu Remy Wang, Max Willsey, Dan SuciuSIGMOD 2023 · 18 citations
- HoneyComb: A Parallel Worst-Case Optimal Join on MulticoresJiacheng Wu, Dan SuciuSIGMOD 2025 · 1 citation
- APEX: Adaptive Variable-Wise Parallel Execution for Worst-Case Optimal Joins on Graph QueriesYipeng Liu, Yuming Lin, Zhicheng Pan, Chengcheng Yang et al.ICDE 2026
- Vertex-centric Parallel Computation of SQL QueriesAinur Smagulova, Alin DeutschSIGMOD 2021 · 1 citation
