DBScholar

Back to papers

A Learned Query Rewrite System using Monte Carlo Tree Search

Summary: Frames SQL rewriting as policy-tree search rather than fixed-order heuristics, using Monte Carlo Tree Search to avoid rewrite-order local optima. A learned improvement estimator guides rule selection, with parallel exploration yielding superior rewrites and performance. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
13110
Venue
VLDB
Year
2022
Pagerank
8.5584e-05
Overall Rank
2,452 | 83.18%
DOI
10.14778/3485450.3485456

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zhou_vldb22,
        title = {{A Learned Query Rewrite System using Monte Carlo Tree Search}},
        author = {Zhou, Xuanhe and Li, Guoliang and Chai, Chengliang and Feng, Jianhua},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {1},
        pages = {46--58},
        doi = {10.14778/3485450.3485456},
        url = {https://doi.org/10.14778/3485450.3485456},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 36 of 36 citing papers.

Rank Citing Paper Year Venue Pagerank
1,920 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.4846185e-05
1,982 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.3573897e-05
2,553 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB 8.4283807e-05
2,762 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1539867e-05
3,769 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.1403543e-05
4,363 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 6.7423909e-05
4,398 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.7248611e-05
4,909 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.4486671e-05
4,929 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4423294e-05
5,169 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.3349035e-05
6,101 LLM for Data Management 2024 VLDB 5.9774273e-05
6,259 R-Bot: An LLM-based Query Rewrite System 2025 VLDB 5.93967e-05
6,600 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.8250114e-05
6,921 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.7388557e-05
7,846 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 5.5331459e-05
8,003 Towards Designing and Learning Piecewise Space-Filling Curves 2023 VLDB 5.5084586e-05
8,042 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.5015896e-05
8,163 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4751517e-05
8,164 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4750309e-05
8,423 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 5.4275169e-05
8,453 A Learned Query Rewrite System 2023 VLDB 5.4229225e-05
8,643 PACE: Poisoning Attacks on Learned Cardinality Estimation 2024 SIGMOD 5.3940849e-05
8,984 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.3395569e-05
9,433 FEBench: A Benchmark for Real-Time Relational Data Feature Extraction 2023 VLDB 5.2696166e-05
9,536 Database Gyms 2023 CIDR 5.2529727e-05
9,617 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.2434488e-05
9,626 Spatial Query Optimization With Learning 2024 VLDB 5.2434488e-05
10,082 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 5.1587525e-05
10,139 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR 5.093636e-05
10,190 AgenticScholar: Agentic Data Management with Pipeline Orchestration for Scholarly Corpora 2026 SIGMOD 5.093636e-05
10,220 Dialect-Agnostic SQL Parsing via LLM-Based Segmentation 2026 SIGMOD 5.093636e-05
10,253 HAMMER: An Automatic RAG Tuning System via Hierarchical Memory-Guided Monte Carlo Tree Search 2026 SIGMOD 5.093636e-05
10,296 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD 5.093636e-05
10,508 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 5.093636e-05
11,007 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 5.093636e-05
11,489 Demo of QueryBooster: Supporting Middleware-Based SQL Query Rewriting as a Service 2023 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 23 of 23 cited papers.

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

Rank Cited Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
110 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003309592
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
401 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019092557
445 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00018336751
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
563 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001650812
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00015014887
1,468 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010686496
1,559 Cloud-Native Database Systems at Alibaba: Opportunities and Challenges 2019 VLDB 0.00010362456
1,712 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 9.9492299e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
2,812 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0979597e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,662 openGauss: An Autonomous Database System 2021 VLDB 7.2166682e-05
4,617 Learned Cardinality Estimation for Similarity Queries 2021 SIGMOD 6.604437e-05
5,059 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.3807509e-05
5,340 Machine Learning for Databases 2021 VLDB 6.2603359e-05
7,394 DBMind: A Self-Driving Platform in openGauss 2021 VLDB 5.6259065e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 13,684 Rewrite Rules for Search Database Systems 2011 PODS
2 10,296 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD
3 7,921 Monte Carlo Tree Search for Generating Interactive Data Analysis Interfaces 2020 SIGMOD
4 12,287 Probabilistic Query Rewriting for Efficient and Effective Keyword Search on Graph Data 2013 VLDB
5 3,268 Efficient and Provable Multi-Query Optimization 2017 PODS
6 6,090 Scalable Query Rewriting: A Graph-Based Approach 2011 SIGMOD
7 4,363 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD
8 50 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB
9 2,553 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB
10 8,453 A Learned Query Rewrite System 2023 VLDB