DBScholar

Back to papers

Grep: A Graph Learning Based Database Partitioning System

Summary: Grep leverages a graph-based encoding of data and queries (columns as nodes, query relations as edges; weights from data diversity and joins) with graph neural networks to learn partitioning keys. An evaluation model predicts partitioning performance without repartitioning; deployed in a commercial DB, it delivers 68% throughput gain on 30K banking queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h49d8abf6ef744902
Venue
SIGMOD
Year
2023
Pagerank
5.378708e-05
Overall Rank
8,202 | 44.86%
DOI
10.1145/3588948

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhou_sigmod23,
        title = {{Grep: A Graph Learning Based Database Partitioning System}},
        author = {Zhou, Xuanhe and Li, Guoliang and Feng, Jianhua and Liu, Luyang and Guo, Wei},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3588948},
        url = {https://dl.acm.org/doi/10.1145/3588948},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 34 of 34 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030762995
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023358891
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018315867
461 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017829982
491 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017413042
1,036 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012377471
1,200 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011563303
1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010440205
1,536 Cardinality Estimation: An Experimental Survey 2018 VLDB 0.00010327422
1,699 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 9.8445322e-05
2,288 Clay: Fine-Grained Adaptive Partitioning for General Database Schemas 2017 VLDB 8.6912082e-05
2,395 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5281914e-05
2,478 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4079121e-05
2,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
2,668 Combating Web Spam with TrustRank 2004 VLDB 8.1549459e-05
2,690 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1258173e-05
2,704 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.1149334e-05
2,842 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.949193e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8742664e-05
3,143 Query Optimization Techniques for Partitioned Tables 2011 SIGMOD 7.5981026e-05
3,239 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.5007569e-05
3,486 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2636102e-05
3,590 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1865343e-05
3,682 openGauss: An Autonomous Database System 2021 VLDB 7.1013922e-05
3,741 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0594076e-05
4,482 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5802486e-05
4,533 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.5565658e-05
5,199 Exact Cardinality Query Optimization with Bounded Execution Cost 2019 SIGMOD 6.2327836e-05
6,080 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 5.8924903e-05
6,277 Fast and Effective Distribution-Key Recommendation for Amazon Redshift 2020 VLDB 5.8266146e-05
7,598 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 5.4871733e-05
7,706 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4730676e-05
8,232 Demonstrating UDO: A Unified Approach for Optimizing Transaction Code, Physical Design, and System Parameters via Reinforcement Learning 2021 SIGMOD 5.3721763e-05
Previous Page 1 / 1 Next

Semantically Similar Papers