DBScholar

Back to papers

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)

Paper ID
hd8cf239ee8c3c91d
Venue
SIGMOD
Year
2023
Pagerank
7.8068219e-05
Overall Rank
2,961 | 80.10%
DOI
10.1145/3626768

Incoming Non-self Citations Over Time

Authors

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 16 of 16 citing papers.

Rank Citing Paper Year Venue Pagerank
3,336 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.4137763e-05
4,385 R-Bot: An LLM-based Query Rewrite System 2025 VLDB 6.6235293e-05
5,544 Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency 2025 SIGMOD 6.0887243e-05
7,638 Test Data Generation for Complex SQL Queries 2026 SIGMOD 5.4772833e-05
8,972 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2458797e-05
10,129 ParSEval: Plan-aware Test Database Generation for SQL Equivalence Evaluation 2025 VLDB 5.0751052e-05
10,359 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR 4.9793485e-05
10,415 Automated Discovery of Test Oracles for Database Management Systems Using LLMs 2026 SIGMOD 4.9793485e-05
10,622 Beyond Relational: Semantic-Aware Multi-Modal Analytics with LLM-Native Query Optimization 2026 SIGMOD 4.9793485e-05
10,832 ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling 2026 VLDB 4.9793485e-05
10,843 I-Rex: An Interactive Debugger for SQL 2026 VLDB 4.9793485e-05
10,966 Qr-Hint: Formally Verified and AI-Explained SQL Tutoring 2026 VLDB 4.9793485e-05
10,971 Verified LLM-Based Query Rewriting for Microsoft SQL Server 2026 VLDB 4.9793485e-05
11,242 QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach 2025 VLDB 4.9793485e-05
11,375 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 4.9793485e-05
11,644 Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries 2024 VLDB 4.9793485e-05
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