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.9793485e-05
Overall Rank
11,375 | 23.53%
DOI
10.14778/3750601.3750622

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.0023947656
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055406774
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003276959
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031392616
185 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00026072278
362 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019989474
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019514689
790 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013976438
1,276 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00011239266
1,680 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.9031411e-05
1,893 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.4126198e-05
2,039 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB 9.1493268e-05
2,395 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5281914e-05
2,961 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.8068219e-05
3,202 Demonstration of the Cosette Automated SQL Prover 2017 SIGMOD 7.5411821e-05
3,336 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.4137763e-05
4,102 QED: A Powerful Query Equivalence Decider for SQL 2024 VLDB 6.8070264e-05
4,108 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8020689e-05
4,683 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4716143e-05
6,604 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB 5.7392648e-05
7,931 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4238328e-05
8,332 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.3528188e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,622 A Learned Query Rewrite System 2023 VLDB
2 10,917 No Silver Bullet: Boosting GaussDB Performance on the 30TB TPC-H Workload 2026 VLDB
3 1,893 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD
4 10,359 Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! 2026 CIDR
5 2,039 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB
6 6,604 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB
7 11,798 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,108 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB
10 3,336 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD