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 14 of 14 citing papers.
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 | 6,586 | Can Large Language Models Be Query Optimizer for Relational Databases? | 2026 | SIGMOD |
| 2 | 4,787 | Hybrid Querying Over Relational Databases and Large Language Models | 2025 | CIDR |
| 3 | 10,293 | D-Bot: An LLM-Powered DBA Copilot | 2025 | SIGMOD |
| 4 | 7,012 | Reliable Text-to-SQL with Adaptive Abstention | 2025 | SIGMOD |
| 5 | 10,971 | Verified LLM-Based Query Rewriting for Microsoft SQL Server | 2026 | VLDB |
| 6 | 1,658 | D-Bot: Database Diagnosis System using Large Language Models | 2024 | VLDB |
| 7 | 3,336 | GenRewrite: Query Rewriting via Large Language Models | 2026 | SIGMOD |
| 8 | 10,832 | ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling | 2026 | VLDB |
| 9 | 10,359 | Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! | 2026 | CIDR |
| 10 | 2,039 | LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency | 2025 | VLDB |