Geo: A Query Rewrite Framework for Graph Pattern Mining
Nazanin Yousefian, Kasra Jamshidi, Keval Vora, Anders Miltner
Abstract
Graph pattern mining is important for analyzing graph data. Graph mining systems typically require answering pattern matching queries, which involve solving the NP-complete subgraph isomorphism problem. To address this, domain experts often develop custom pattern matching query optimization strategies based on exploiting substructural similarities across different patterns. While these optimizers can be effective, their development is challenging due to the complex structural properties of the patterns (e.g., subsymmetries), which are difficult to address. This complexity limits the exploration of interactions between different optimization strategies and restricts experts from continuously improving the optimizers—such as by incorporating additional custom or general pattern-based equivalences over time. In this paper, we present a programmable pattern matching query optimizer called Geo , which automatically manages the interactions between various equivalences, ensures the optimizations maintain correctness of results, and simplifies the management of substructure equivalences. Geo exposes a simple but flexible language for expressing pattern equivalences as rewrite rules. By maintaining canonical representations of generated patterns during equality saturation, Geo avoids issues arising from syntactic differences in isomorphic patterns. Additionally, we develop embedded reconstructablility ( EmRec ) that tracks provenance across equivalences to ensure various reconstructability needs of desired outputs. Our evaluation demonstrates that Geo can discover novel query equivalences through complex composition of various rewrite rules, enabling our optimized queries to achieve a cost reduction of up to 99% compared to the queries in prior work. We further test Geo ’s effectiveness at speeding up practical graph mining problems by using it in two representative case studies – approximate pattern matching and quasi-clique mining, and find it is highly effective at optimizing these tasks, enabling cost reductions of up to 71%.
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.
Builds on25
- egg: Fast and extensible equality saturationMax Willsey, Chandrakana Nandi, Yisu Remy Wang, Oliver Flatt et al.POPL 2021 · 170 citations
- In-Memory Subgraph Matching: An In-depth StudyShixuan Sun, Qiong LuoSIGMOD 2020 · 159 citations
- Peregrine: a pattern-aware graph mining systemKasra Jamshidi, Rakesh Mahadasa, Keval VoraEuroSys 2020 · 107 citations
- A Learned Query Rewrite System using Monte Carlo Tree SearchXuanhe Zhou, Guoliang Li, Chengliang Chai, Jianhua FengVLDB 2022 · 85 citations
- GraphPi: high performance graph pattern matching through effective redundancy eliminationTianhui Shi, Mingshu Zhai, Yi Xu, Jidong ZhaiSC 2020 · 72 citations
Related papers
- Accelerating Graph Mining Systems with Subgraph MorphingKasra Jamshidi, Harry Xu, Keval VoraEuroSys 2023 · 17 citations
- Accelerating Subgraph Matching through Fine-grained and Powerful EquivalencesYujie Lu, Zhijie Zhang, Weiguo Zheng, Lei ZouVLDB 2025 · 1 citation
- Jupiter: Pushing Speed and Scalability Limitations for Subgraph Matching on Multi-GPUsZhiheng Lin, Ke Meng, Changjie Xu, Weichen Cao et al.EuroSys 2025 · 2 citations
- Efficient Graph Matching with Pattern ReductionPingpeng Yuan, Yujiang Wang, Jiangji Peng, Tianyu Ma et al.ICDE 2026
- Synthesizing Graph Queries from DemonstrationsXiaoyu Liu, Qikang Liu, Evan Dyce, Keval Vora et al.OOPSLA 2026
