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

Summary: LLM-R2 augments rule-based SQL rewriting by using an LLM to recommend rewrite rules, with a curriculum-trained contrastive model producing query embeddings and selecting effective demonstrations. Reduces search and estimator reliance, achieving significant, robust speedups. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 14140
Venue: VLDB
Year: 2025
Pagerank: 7.0639229e-05
Overall Rank: 3,472 | 75.85%
DOI: 10.14778/3696435.3696440

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,023	GenRewrite: Query Rewriting via Large Language Models	2026	SIGMOD	5.75363e-05
7,035	R-Bot: An LLM-based Query Rewrite System	2025	VLDB	4.8548467e-05
7,931	In-depth Analysis of Graph-based RAG in a Unified Framework	2025	VLDB	4.613363e-05
8,207	SQLStorm: Taking Database Benchmarking into the LLM Era	2025	VLDB	4.5583637e-05
8,488	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD	4.4998609e-05
9,936	VIDEX: A Disaggregated and Extensible Virtual Index for the Cloud and AI Era	2025	VLDB	4.2482599e-05
9,993	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	4.1945683e-05
10,047	AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning	2026	SIGMOD	4.1945683e-05
10,093	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	4.1945683e-05
10,096	NeuSO: Neural Optimizer for Subgraph Queries	2026	SIGMOD	4.1945683e-05
10,099	PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL	2026	SIGMOD	4.1945683e-05
10,212	SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads	2026	SIGMOD	4.1945683e-05
10,215	Task Cascades for Efficient Unstructured Data Processing	2026	SIGMOD	4.1945683e-05
10,217	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.1945683e-05
10,219	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	4.1945683e-05
10,475	Cracking SQL Barriers: An LLM-based Dialect Translation System	2025	SIGMOD	4.1945683e-05
10,658	LLMLog: Advanced Log Template Generation via LLM-driven Multi-Round Annotation	2025	VLDB	4.1945683e-05
10,778	GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB	2025	VLDB	4.1945683e-05

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
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
106	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048400734
132	The EXODUS Optimizer Generator	1987	SIGMOD	0.00042994082
544	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00020521965
1,729	Cloud-Native Database Systems at Alibaba: Opportunities and Challenges	2019	VLDB	0.0001073728
2,596	WeTune: Automatic Discovery and Verification of Query Rewrite Rules	2022	SIGMOD	8.4729982e-05
2,985	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB	7.7795847e-05
3,169	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	7.4498425e-05
3,248	A Learned Query Rewrite System using Monte Carlo Tree Search	2022	VLDB	7.3258782e-05
5,525	QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting	2023	VLDB	5.4600815e-05
6,328	A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies	2024	VLDB	5.1082882e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
369	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.0002547515
7,354	Reliable Text-to-SQL with Adaptive Abstention	2025	SIGMOD	4.7529612e-05
10,217	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.1945683e-05
8,969	A Learned Query Rewrite System	2023	VLDB	4.4189226e-05
9,151	The Power of Constraints in Natural Language to SQL Translation	2025	VLDB	4.3849295e-05
5,840	Logical and Physical Optimizations for SQL Query Execution over Large Language Models	2025	SIGMOD	5.3042561e-05
8,488	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD	4.4998609e-05
9,993	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	4.1945683e-05
5,023	GenRewrite: Query Rewriting via Large Language Models	2026	SIGMOD	5.75363e-05
7,035	R-Bot: An LLM-based Query Rewrite System	2025	VLDB	4.8548467e-05