DBScholar

Back to papers

LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency

Summary: LLM-R² augments rule-based SQL rewriting with an LLM that recommends effective rewrite rules, guided by curriculum-trained contrastive query representations and demonstrations. It improves execution efficiency while reducing reliance on inaccurate cost estimators and remains robust across datasets. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
14328
Venue
VLDB
Year
2025
Pagerank
8.4283807e-05
Overall Rank
2,553 | 82.49%
DOI
10.14778/3696435.3696440

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{li_vldb25,
        title = {{LLM-R\^{}2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency}},
        author = {Li, Zhaodonghui and Yuan, Haitao and Cong, Gao and Wang, Huiming and Bing, Lidong},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {1},
        pages = {53--65},
        doi = {10.14778/3696435.3696440},
        url = {https://doi.org/10.14778/3696435.3696440},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 24 of 24 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
6,259 R-Bot: An LLM-based Query Rewrite System 2025 VLDB 5.93967e-05
7,809 Can Large Language Models Be Query Optimizer for Relational Databases? 2026 SIGMOD 5.5399022e-05
8,423 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 5.4275169e-05
9,617 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.2434488e-05
10,079 VIDEX: A Disaggregated and Extensible Virtual Index for the Cloud and AI Era 2025 VLDB 5.158939e-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,190 AgenticScholar: Agentic Data Management with Pipeline Orchestration for Scholarly Corpora 2026 SIGMOD 5.093636e-05
10,199 Automated Discovery of Test Oracles for Database Management Systems Using LLMs 2026 SIGMOD 5.093636e-05
10,216 DBugScribe: Automatic Database Bug Reproduction from Community Reports 2026 SIGMOD 5.093636e-05
10,220 Dialect-Agnostic SQL Parsing via LLM-Based Segmentation 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,296 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD 5.093636e-05
10,340 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.093636e-05
10,384 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 5.093636e-05
10,389 PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL 2026 SIGMOD 5.093636e-05
10,501 SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2026 SIGMOD 5.093636e-05
10,504 Task Cascades for Efficient Unstructured Data Processing 2026 SIGMOD 5.093636e-05
10,506 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.093636e-05
10,508 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 5.093636e-05
10,909 LLMLog: Advanced Log Template Generation via LLM-driven Multi-Round Annotation 2025 VLDB 5.093636e-05
11,007 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
110 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003309592
119 The EXODUS Optimizer Generator 1987 SIGMOD 0.0003183602
445 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00018336751
1,559 Cloud-Native Database Systems at Alibaba: Opportunities and Challenges 2019 VLDB 0.00010362456
1,832 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 9.6607418e-05
1,982 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.3573897e-05
2,355 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7022189e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
4,909 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.4486671e-05
5,767 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0945741e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 279 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB
2 6,936 Reliable Text-to-SQL with Adaptive Abstention 2025 SIGMOD
3 10,506 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD
4 8,453 A Learned Query Rewrite System 2023 VLDB
5 9,305 The Power of Constraints in Natural Language to SQL Translation 2025 VLDB
6 4,045 Logical and Physical Optimizations for SQL Query Execution over Large Language Models 2025 SIGMOD
7 7,809 Can Large Language Models Be Query Optimizer for Relational Databases? 2026 SIGMOD
8 10,139 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR
9 4,363 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD
10 6,259 R-Bot: An LLM-based Query Rewrite System 2025 VLDB