DBScholar

Back to papers

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)

Paper ID
h798906c6677787c2
Venue
VLDB
Year
2025
Pagerank
6.6232918e-05
Overall Rank
4,384 | 70.54%
DOI
10.14778/3750601.3750625
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

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.

Rank Citing Paper Year Venue Pagerank
3,321 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.427185e-05
3,467 In-depth Analysis of Graph-based RAG in a Unified Framework 2025 VLDB 7.2749538e-05
3,900 SQLStorm: Taking Database Benchmarking into the LLM Era 2025 VLDB 6.9320915e-05
10,371 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR 4.9769913e-05
10,434 Bridging the Gap: Cardinality Estimation for Semantic Queries on Unstructured Data 2026 SIGMOD 4.9769913e-05
10,477 HAMMER: An Automatic RAG Tuning System via Hierarchical Memory-Guided Monte Carlo Tree Search 2026 SIGMOD 4.9769913e-05
10,591 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9769913e-05
10,607 SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer 2026 SIGMOD 4.9769913e-05
10,801 BookRAG: A Hierarchical Structure-aware Index-based Approach for Retrieval-Augmented Generation on Complex Documents 2026 VLDB 4.9769913e-05
10,842 ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling 2026 VLDB 4.9769913e-05
10,927 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9769913e-05
10,980 Verified LLM-Based Query Rewriting for Microsoft SQL Server 2026 VLDB 4.9769913e-05
11,038 Graph-Based Retrieval-Augmented Generation: Applications, Challenges, Solutions, and Opportunities 2026 VLDB 4.9769913e-05
13,614 TrustBCI: A Trustworthy Platform for Collaborative Brain-Computer Interface Data Exchange 2026 VLDB -
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.

Rank Cited Paper Year Venue Pagerank
185 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00026060465
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019507406
790 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013971102
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,659 D-Bot: Database Diagnosis System using Large Language Models 2024 VLDB 9.9625133e-05
1,890 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.4234723e-05
2,037 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB 9.1494269e-05
2,227 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.8007923e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,349 The Dawn of Natural Language to SQL: Are We Fully Ready? 2024 VLDB 8.5969105e-05
2,393 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5298464e-05
2,963 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.8035846e-05
3,321 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.427185e-05
3,489 Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL 2024 VLDB 7.2594757e-05
3,680 openGauss: An Autonomous Database System 2021 VLDB 7.1016555e-05
4,085 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8129946e-05
4,133 AOP: Automated and Interactive LLM Pipeline Orchestration for Answering Complex Queries 2025 CIDR 6.7850201e-05
4,229 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.7133739e-05
4,346 Chat2Data: An Interactive Data Analysis System with RAG, Vector Databases and LLMs 2024 VLDB 6.646096e-05
4,708 PreQR: Pre-training Representation for SQL Understanding 2022 SIGMOD 6.4559477e-05
4,727 LLM for Data Management 2024 VLDB 6.4461562e-05
5,482 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.1123461e-05
6,606 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB 5.7365479e-05
7,929 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4231855e-05
8,620 A Learned Query Rewrite System 2023 VLDB 5.3001197e-05
10,299 D-Bot: An LLM-Powered DBA Copilot 2025 SIGMOD 5.0407989e-05
Previous Page 1 / 1 Next

Semantically Similar Papers