DBScholar

Back to papers

GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB

Summary: GRewriter adds a bolt-on, per-query rewrite engine to GaussDB, decoupling rules via G-DSL and automatic offline discovery of formally verified transformations. Rule indexing and history caching keep overhead below 1%, while 100+ rules cut production latency by up to 99.9%. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h1edb71c8bedaa9fb
Venue
VLDB
Year
2025
Pagerank
4.9769913e-05
Overall Rank
11,381 | 23.51%
DOI
10.14778/3750601.3750622
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@article{jiang_vldb25,
        title = {{GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB}},
        author = {Jiang, Zhe and Wang, Zhaoguo and Lan, Haoning and Tang, Chuzhe and Ding, Haoran and Wang, Lefeng and Zou, Songyun and Wei, Zhuoran and Liu, Yongcun and Yu, Xiang and Ren, Yang and Li, Guoliang and Chen, Haibo},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {12},
        pages = {4991--5003},
        doi = {10.14778/3750601.3750622},
        url = {https://doi.org/10.14778/3750601.3750622},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

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.0023943337
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055384955
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032757423
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031381726
185 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00026060465
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
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,277 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00011234276
1,680 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.9000396e-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,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,204 Demonstration of the Cosette Automated SQL Prover 2017 SIGMOD 7.5379936e-05
3,321 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.427185e-05
4,085 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8129946e-05
4,104 QED: A Powerful Query Equivalence Decider for SQL 2024 VLDB 6.8038041e-05
4,677 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4721041e-05
6,606 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB 5.7365479e-05
7,546 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4966669e-05
7,929 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4231855e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,620 A Learned Query Rewrite System 2023 VLDB
2 10,926 No Silver Bullet: Boosting GaussDB Performance on the 30TB TPC-H Workload 2026 VLDB
3 1,890 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD
4 10,371 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR
5 2,037 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB
6 6,606 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB
7 11,804 Demo of QueryBooster: Supporting Middleware-Based SQL Query Rewriting as a Service 2023 VLDB
8 109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD
9 4,085 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB
10 3,321 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD