R-Bot: An LLM-based Query Rewrite System
Summary: R-Bot uses LLMs for SQL rewriting while mitigating hallucinations via multi-source rewrite evidence and hybrid structural-semantic retrieval. Its iterative, self-reflective rule selection outperforms prior methods and reduces latency in Huawei/customer deployments. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Zhaoyan Sun (Tsinghua University)
- 2. Xuanhe Zhou (Shanghai Jiao Tong University)
- 3. Guoliang Li (Tsinghua University)
- 4. Xiang Yu (Huawei)
- 5. Jianhua Feng (Tsinghua University)
- 6. Yong Zhang (Tsinghua University)
BibTeX Citation
@article{sun_vldb25,
title = {{R-Bot: An LLM-based Query Rewrite System}},
author = {Sun, Zhaoyan and Zhou, Xuanhe and Li, Guoliang and Yu, Xiang and Feng, Jianhua and Zhang, Yong},
journal = {PVLDB},
series = {{VLDB} '25},
volume = {18},
number = {12},
pages = {5031--5044},
doi = {10.14778/3750601.3750625},
url = {https://doi.org/10.14778/3750601.3750625},
year = {2025}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,363 | GenRewrite: Query Rewriting via Large Language Models | 2026 | SIGMOD | 6.7423909e-05 |
| 5,744 | SQLStorm: Taking Database Benchmarking into the LLM Era | 2025 | VLDB | 6.1019672e-05 |
| 6,254 | In-depth Analysis of Graph-based RAG in a Unified Framework | 2025 | VLDB | 5.9405174e-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,206 | Bridging the Gap: Cardinality Estimation for Semantic Queries on Unstructured Data | 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,384 | MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration | 2026 | SIGMOD | 5.093636e-05 |
| 10,401 | SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer | 2026 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
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.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,732 | RTS+: Reliable Text to SQL | 2025 | SIGMOD |
| 2 | 4,045 | Logical and Physical Optimizations for SQL Query Execution over Large Language Models | 2025 | SIGMOD |
| 3 | 7,809 | Can Large Language Models Be Query Optimizer for Relational Databases? | 2026 | SIGMOD |
| 4 | 4,944 | Hybrid Querying Over Relational Databases and Large Language Models | 2025 | CIDR |
| 5 | 10,713 | D-Bot: An LLM-Powered DBA Copilot | 2025 | SIGMOD |
| 6 | 6,936 | Reliable Text-to-SQL with Adaptive Abstention | 2025 | SIGMOD |
| 7 | 1,920 | D-Bot: Database Diagnosis System using Large Language Models | 2024 | VLDB |
| 8 | 4,363 | GenRewrite: Query Rewriting via Large Language Models | 2026 | SIGMOD |
| 9 | 10,139 | Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! | 2026 | CIDR |
| 10 | 2,553 | LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency | 2025 | VLDB |