DBScholar

Back to papers

WeTune: Automatic Discovery and Verification of Query Rewrite Rules

Summary: WeTune automatically discovers rewrite rules by enumerating relational plans up to a size, proposing equivalent rewrites. SMT-based verifier checks equivalence under enumerated constraints; on GitHub-app SQL, 247 queries are optimized beyond standard DBs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
haacfdb1fe1530f6b
Venue
SIGMOD
Year
2022
Pagerank
9.4126198e-05
Overall Rank
1,893 | 87.28%
DOI
10.1145/3514221.3526125

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{wang_sigmod22,
        title = {{WeTune: Automatic Discovery and Verification of Query Rewrite Rules}},
        author = {Wang, Zhaoguo and Zhou, Zhou and Yang, Yicun and Ding, Haoran and Hu, Gansen and Ding, Ding and Tang, Chuzhe and Chen, Haibo and Li, Jinyang},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526125},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526125},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 25 of 25 citing papers.

Rank Citing Paper Year Venue Pagerank
1,658 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.9642078e-05
2,039 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB 9.1493268e-05
2,961 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.8068219e-05
3,336 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.4137763e-05
4,108 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8020689e-05
4,229 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.7165534e-05
4,385 R-Bot: An LLM-based Query Rewrite System 2025 VLDB 6.6235293e-05
5,149 LLM for Data Management 2024 VLDB 6.2551644e-05
5,544 Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency 2025 SIGMOD 6.0887243e-05
6,726 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6948731e-05
7,905 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4291824e-05
7,931 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4238328e-05
8,153 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3891786e-05
8,622 A Learned Query Rewrite System 2023 VLDB 5.3012467e-05
8,879 Spatial Query Optimization With Learning 2024 VLDB 5.2568354e-05
8,962 GEqO: ML-Accelerated Semantic Equivalence Detection 2023 SIGMOD 5.2493925e-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,436 Dialect-Agnostic SQL Parsing via LLM-Based Segmentation 2026 SIGMOD 4.9793485e-05
10,832 ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling 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,596 Optimizing Video Queries with Declarative Clues 2024 VLDB 4.9793485e-05
11,798 Demo of QueryBooster: Supporting Middleware-Based SQL Query Rewriting as a Service 2023 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 20 of 20 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
17 Provenance Semirings 2007 PODS 0.00059752575
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003276959
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031392616
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
196 Grammar-like Functional Rules for Representing Query Optimization Alternatives 1988 SIGMOD 0.00025626873
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019514689
790 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013976438
1,015 Improved Unnesting Algorithms for Join Aggregate SQL Queries 1992 VLDB 0.00012500439
1,032 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012401489
1,119 Query Optimization by Predicate Move-Around 1994 VLDB 0.00011950395
1,438 Magic is Relevant 1990 SIGMOD 0.00010648031
1,680 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.9031411e-05
2,395 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5281914e-05
2,618 The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database 2016 VLDB 8.2217101e-05
3,060 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6928239e-05
3,297 Automated Verification of Query Equivalence Using Satisfiability Modulo Theories 2019 VLDB 7.4452842e-05
3,718 A Formal Semantics of SQL Queries, Its Validation, and Applications 2018 VLDB 7.0721776e-05
4,149 SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns 2020 SIGMOD 6.7796171e-05
Previous Page 1 / 1 Next

Semantically Similar Papers