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
- 14106
- Venue
- VLDB
- Year
- 2025
- Pagerank
- 4.8518029e-05
- Overall Rank
- 7,030 | 51.15%
- 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 |
| 363 |
CockroachDB: The Resilient Geo-Distributed SQL Database |
2020 |
SIGMOD |
0.00025750338 |
| 542 |
Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources |
2018 |
SIGMOD |
0.00020522627 |
| 1,056 |
Cosette: An Automated Prover for SQL |
2017 |
CIDR |
0.00014391317 |
| 1,953 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.9701097e-05 |
| 2,595 |
WeTune: Automatic Discovery and Verification of Query Rewrite Rules |
2022 |
SIGMOD |
8.4725961e-05 |
| 2,937 |
DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems |
2021 |
VLDB |
7.8552033e-05 |
| 3,105 |
GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization |
2024 |
VLDB |
7.5567226e-05 |
| 3,167 |
QueryFormer: A Tree Transformer Model for Query Plan Representation |
2022 |
VLDB |
7.4561078e-05 |
| 3,241 |
A Learned Query Rewrite System using Monte Carlo Tree Search |
2022 |
VLDB |
7.32744e-05 |
| 3,465 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0668293e-05 |
| 3,666 |
The Dawn of Natural Language to SQL: Are We Fully Ready? |
2024 |
VLDB |
6.8606092e-05 |
| 4,151 |
openGauss: An Autonomous Database System |
2021 |
VLDB |
6.4020605e-05 |
| 4,385 |
Proving Query Equivalence Using Linear Integer Arithmetic |
2023 |
SIGMOD |
6.2247394e-05 |
| 4,658 |
PreQR: Pre-training Representation for SQL Understanding |
2022 |
SIGMOD |
6.0084453e-05 |
| 4,908 |
Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL |
2024 |
VLDB |
5.835596e-05 |
| 5,001 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.7634197e-05 |
| 5,533 |
QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting |
2023 |
VLDB |
5.4555519e-05 |
| 6,202 |
Chat2Data: An Interactive Data Analysis System with RAG, Vector Databases and LLMs |
2024 |
VLDB |
5.1554849e-05 |
| 6,328 |
A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies |
2024 |
VLDB |
5.1034426e-05 |
| 7,016 |
LLM for Data Management |
2024 |
VLDB |
4.8561622e-05 |
| 7,703 |
AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries |
2025 |
CIDR |
4.668568e-05 |
| 8,099 |
GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation |
2024 |
VLDB |
4.58218e-05 |
| 8,339 |
SlabCity: Whole-Query Optimization using Program Synthesis |
2023 |
VLDB |
4.5383933e-05 |
| 8,975 |
A Learned Query Rewrite System |
2023 |
VLDB |
4.4146872e-05 |
| 10,442 |
D-Bot: An LLM-Powered DBA Copilot |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,485 |
Cracking SQL Barriers: An LLM-based Dialect Translation System |
2025 |
SIGMOD |
4.1905499e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 10,461 |
RTS+: Reliable Text to SQL |
2025 |
SIGMOD |
4.1905499e-05 |
| 5,429 |
Logical and Physical Optimizations for SQL Query Execution over Large Language Models |
2025 |
SIGMOD |
5.511638e-05 |
| 8,479 |
Can Large Language Models Be Query Optimizer for Relational Databases? |
2026 |
SIGMOD |
4.4967983e-05 |
| 4,529 |
Hybrid Querying Over Relational Databases and Large Language Models |
2025 |
CIDR |
6.1057096e-05 |
| 10,442 |
D-Bot: An LLM-Powered DBA Copilot |
2025 |
SIGMOD |
4.1905499e-05 |
| 7,351 |
Reliable Text-to-SQL with Adaptive Abstention |
2025 |
SIGMOD |
4.7484027e-05 |
| 1,953 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.9701097e-05 |
| 5,001 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.7634197e-05 |
| 9,992 |
Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! |
2026 |
CIDR |
4.1905499e-05 |
| 3,465 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0668293e-05 |