Proving Query Equivalence Using Linear Integer Arithmetic
Summary: Introduces SQLSolver, an SQL-equivalence prover that handles unbounded summations with the LIA* theory for principled algebraic modeling and SMT-based decision. Extends LIA* to nested summations; evaluates on 359 Calcite/Spark-derived query pairs and proves 346, outperforming existing provers. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Haoran Ding (Shanghai Jiao Tong University)
- 2. Zhaoguo Wang (Shanghai Jiao Tong University)
- 3. Yicun Yang (Shanghai Jiao Tong University)
- 4. Dexin Zhang (Shanghai Jiao Tong University)
- 5. Zhenglin Xu (Shanghai Jiao Tong University)
- 6. Haibo Chen (Shanghai Jiao Tong University)
- 7. Ruzica Piskac (Yale University)
- 8. Jinyang Li (New York University)
BibTeX Citation
@inproceedings{ding_sigmod23,
title = {{Proving Query Equivalence Using Linear Integer Arithmetic}},
author = {Ding, Haoran and Wang, Zhaoguo and Yang, Yicun and Zhang, Dexin and Xu, Zhenglin and Chen, Haibo and Piskac, Ruzica and Li, Jinyang},
series = {{SIGMOD} '23},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3626768},
url = {https://dl.acm.org/doi/10.1145/3626768},
year = {2023}
}
Incoming Citations (Sorted by Pagerank)
Showing 12 of 12 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 16 of 16 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 11,146 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS |
| 2 | 12,492 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS |
| 3 | 11,384 | LinCQA: Faster Consistent Query Answering with Linear Time Guarantees | 2023 | SIGMOD |
| 4 | 10,139 | Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! | 2026 | CIDR |
| 5 | 5,062 | Equivalence of Queries Combining Set and Bag-Set Semantics | 2006 | PODS |
| 6 | 2,238 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 7 | 5,353 | QED: A Powerful Query Equivalence Decider for SQL | 2024 | VLDB |
| 8 | 11,326 | Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries | 2024 | VLDB |
| 9 | 3,327 | Automated Verification of Query Equivalence Using Satisfiability Modulo Theories | 2019 | VLDB |
| 10 | 1,829 | Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries | 2018 | VLDB |