Back to papers
R-Bot: An LLM-based Query Rewrite System
Summary: Introduces R-Bot, an LLM-driven SQL rewrite system that mitigates hallucinations via a multi-source evidence-prep pipeline and hybrid structure–semantics retrieval to fetch relevant rewrite evidences. Iterative, self-reflective LLM rewriting composes rule sequences, surpasses prior rewrite methods and is deployed in production (Huawei).
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 14105
- Venue
- VLDB
- Year
- 2025
- Pagerank
- 4.8548467e-05
- Overall Rank
- 7,035 | 51.06%
- DOI
-
10.14778/3750601.3750625
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 26 of 26 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 390 |
CockroachDB: The Resilient Geo-Distributed SQL Database |
2020 |
SIGMOD |
0.00024607299 |
| 544 |
Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources |
2018 |
SIGMOD |
0.00020521965 |
| 1,057 |
Cosette: An Automated Prover for SQL |
2017 |
CIDR |
0.0001439886 |
| 1,956 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.960627e-05 |
| 2,596 |
WeTune: Automatic Discovery and Verification of Query Rewrite Rules |
2022 |
SIGMOD |
8.4729982e-05 |
| 2,985 |
DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems |
2021 |
VLDB |
7.7795847e-05 |
| 3,114 |
GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization |
2024 |
VLDB |
7.5451724e-05 |
| 3,169 |
QueryFormer: A Tree Transformer Model for Query Plan Representation |
2022 |
VLDB |
7.4498425e-05 |
| 3,248 |
A Learned Query Rewrite System using Monte Carlo Tree Search |
2022 |
VLDB |
7.3258782e-05 |
| 3,472 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0639229e-05 |
| 3,662 |
The Dawn of Natural Language to SQL: Are We Fully Ready? |
2024 |
VLDB |
6.8672143e-05 |
| 4,152 |
openGauss: An Autonomous Database System |
2021 |
VLDB |
6.4060406e-05 |
| 4,388 |
Proving Query Equivalence Using Linear Integer Arithmetic |
2023 |
SIGMOD |
6.2303078e-05 |
| 4,661 |
PreQR: Pre-training Representation for SQL Understanding |
2022 |
SIGMOD |
6.0137947e-05 |
| 4,908 |
Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL |
2024 |
VLDB |
5.8339245e-05 |
| 5,023 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.75363e-05 |
| 5,525 |
QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting |
2023 |
VLDB |
5.4600815e-05 |
| 6,328 |
A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies |
2024 |
VLDB |
5.1082882e-05 |
| 6,389 |
Chat2Data: An Interactive Data Analysis System with RAG, Vector Databases and LLMs |
2024 |
VLDB |
5.0844009e-05 |
| 7,020 |
LLM for Data Management |
2024 |
VLDB |
4.8595728e-05 |
| 7,705 |
AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries |
2025 |
CIDR |
4.6730494e-05 |
| 8,095 |
GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation |
2024 |
VLDB |
4.5865778e-05 |
| 8,345 |
SlabCity: Whole-Query Optimization using Program Synthesis |
2023 |
VLDB |
4.5426916e-05 |
| 8,969 |
A Learned Query Rewrite System |
2023 |
VLDB |
4.4189226e-05 |
| 10,432 |
D-Bot: An LLM-Powered DBA Copilot |
2025 |
SIGMOD |
4.1945683e-05 |
| 10,475 |
Cracking SQL Barriers: An LLM-based Dialect Translation System |
2025 |
SIGMOD |
4.1945683e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 10,451 |
RTS+: Reliable Text to SQL |
2025 |
SIGMOD |
4.1945683e-05 |
| 5,840 |
Logical and Physical Optimizations for SQL Query Execution over Large Language Models |
2025 |
SIGMOD |
5.3042561e-05 |
| 4,535 |
Hybrid Querying Over Relational Databases and Large Language Models |
2025 |
CIDR |
6.1049669e-05 |
| 8,488 |
Can Large Language Models Be Query Optimizer for Relational Databases? |
2026 |
SIGMOD |
4.4998609e-05 |
| 10,432 |
D-Bot: An LLM-Powered DBA Copilot |
2025 |
SIGMOD |
4.1945683e-05 |
| 7,354 |
Reliable Text-to-SQL with Adaptive Abstention |
2025 |
SIGMOD |
4.7529612e-05 |
| 1,956 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.960627e-05 |
| 5,023 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.75363e-05 |
| 9,993 |
Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! |
2026 |
CIDR |
4.1945683e-05 |
| 3,472 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0639229e-05 |