Back to papers
GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB
Summary: GRewriter: a bolt‑on, extensible query rewriter for GaussDB using a rule language (G‑DSL), rule index and history cache to select rewrites per query instead of pipeline‑wide, enabling coexistence of diverse rules with low engineering cost. An offline generator with novel enumeration and an equivalence theorem produces formally verified, highly expressive rules; deployed with 100+ rules, <1% overhead and large production latency reductions.
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 14101
- Venue
- VLDB
- Year
- 2025
- Pagerank
- 4.1945683e-05
- Overall Rank
- 10,778 | 25.02%
- DOI
-
10.14778/3750601.3750622
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 1 |
Access Path Selection in a Relational Database Management System |
1979 |
SIGMOD |
0.0040449103 |
| 66 |
Spark SQL: Relational Data Processing in Spark |
2015 |
SIGMOD |
0.00061639801 |
| 106 |
Extensible/Rule Based Query Rewrite Optimization in Starburst |
1992 |
SIGMOD |
0.00048400734 |
| 132 |
The EXODUS Optimizer Generator |
1987 |
SIGMOD |
0.00042994082 |
| 390 |
CockroachDB: The Resilient Geo-Distributed SQL Database |
2020 |
SIGMOD |
0.00024607299 |
| 544 |
Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources |
2018 |
SIGMOD |
0.00020521965 |
| 640 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018759152 |
| 1,057 |
Cosette: An Automated Prover for SQL |
2017 |
CIDR |
0.0001439886 |
| 2,099 |
Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries |
2018 |
VLDB |
9.5479391e-05 |
| 2,249 |
Orca: A Modular Query Optimizer Architecture for Big Data |
2014 |
SIGMOD |
9.2034693e-05 |
| 2,596 |
WeTune: Automatic Discovery and Verification of Query Rewrite Rules |
2022 |
SIGMOD |
8.4729982e-05 |
| 3,248 |
A Learned Query Rewrite System using Monte Carlo Tree Search |
2022 |
VLDB |
7.3258782e-05 |
| 3,432 |
Demonstration of the Cosette Automated SQL Prover |
2017 |
SIGMOD |
7.1008151e-05 |
| 3,472 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0639229e-05 |
| 4,388 |
Proving Query Equivalence Using Linear Integer Arithmetic |
2023 |
SIGMOD |
6.2303078e-05 |
| 5,023 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.75363e-05 |
| 5,243 |
QED: A Powerful Query Equivalence Decider for SQL |
2024 |
VLDB |
5.6071695e-05 |
| 5,525 |
QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting |
2023 |
VLDB |
5.4600815e-05 |
| 5,640 |
AutoSteer: Learned Query Optimization for Any SQL Database |
2023 |
VLDB |
5.3933314e-05 |
| 8,095 |
GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation |
2024 |
VLDB |
4.5865778e-05 |
| 8,345 |
SlabCity: Whole-Query Optimization using Program Synthesis |
2023 |
VLDB |
4.5426916e-05 |
| 8,659 |
Learned Offline Query Planning via Bayesian Optimization |
2025 |
SIGMOD |
4.4722928e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 7,231 |
Industrial-Strength OLTP Using Main Memory and Many Cores |
2020 |
VLDB |
4.7943888e-05 |
| 8,969 |
A Learned Query Rewrite System |
2023 |
VLDB |
4.4189226e-05 |
| 2,596 |
WeTune: Automatic Discovery and Verification of Query Rewrite Rules |
2022 |
SIGMOD |
8.4729982e-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 |
| 3,472 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0639229e-05 |
| 8,095 |
GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation |
2024 |
VLDB |
4.5865778e-05 |
| 11,290 |
Demo of QueryBooster: Supporting Middleware-Based SQL Query Rewriting as a Service |
2023 |
VLDB |
4.1945683e-05 |
| 106 |
Extensible/Rule Based Query Rewrite Optimization in Starburst |
1992 |
SIGMOD |
0.00048400734 |
| 5,525 |
QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting |
2023 |
VLDB |
5.4600815e-05 |
| 5,023 |
GenRewrite: Query Rewriting via Large Language Models |
2026 |
SIGMOD |
5.75363e-05 |