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
14289
Venue
VLDB
Year
2025
Pagerank
5.093636e-05
Overall Rank
11,007 | 24.49%
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.0024089429
24 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00054865648
110 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003309592
119 The EXODUS Optimizer Generator 1987 SIGMOD 0.0003183602
208 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00024968157
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
445 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00018336751
910 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013285905
1,621 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00010203114
1,829 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.6671311e-05
1,982 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.3573897e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
2,553 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB 8.4283807e-05
3,172 Demonstration of the Cosette Automated SQL Prover 2017 SIGMOD 7.6679093e-05
3,769 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.1403543e-05
4,363 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 6.7423909e-05
4,909 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.4486671e-05
4,929 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4423294e-05
5,353 QED: A Powerful Query Equivalence Decider for SQL 2024 VLDB 6.2519268e-05
7,873 GaussDB: A Cloud-Native Multi-Primary Database with Compute-Memory-Storage Disaggregation 2024 VLDB 5.5257163e-05
8,163 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4751517e-05
8,164 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4750309e-05
Previous Page 1 / 1 Next

Semantically Similar Papers