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
6659
Venue
SIGMOD
Year
2023
Pagerank
5.5015896e-05
Overall Rank
8,042 | 44.83%
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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
126 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030779127
246 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023457421
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
501 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001738508
1,044 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.0001244236
1,199 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011703966
1,503 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.000105564
1,516 Cardinality Estimation: An Experimental Survey 2018 VLDB 0.00010520885
1,686 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 0.00010008686
2,363 Clay: Fine-Grained Adaptive Partitioning for General Database Schemas 2017 VLDB 8.6873235e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
2,499 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4993549e-05
2,618 Combating Web Spam with TrustRank 2004 VLDB 8.3380047e-05
2,666 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.2764713e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
2,762 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1539867e-05
2,812 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0979597e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,199 Query Optimization Techniques for Partitioned Tables 2011 SIGMOD 7.6423984e-05
3,200 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.642132e-05
3,586 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.2834069e-05
3,587 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2829345e-05
3,662 openGauss: An Autonomous Database System 2021 VLDB 7.2166682e-05
3,688 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.201795e-05
4,456 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.692321e-05
5,137 Exact Cardinality Query Optimization with Bounded Execution Cost 2019 SIGMOD 6.3507372e-05
5,169 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.3349035e-05
5,978 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 6.0212877e-05
6,279 Fast and Effective Distribution-Key Recommendation for Amazon Redshift 2020 VLDB 5.9286872e-05
7,585 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.5912479e-05
8,068 Demonstrating UDO: A Unified Approach for Optimizing Transaction Code, Physical Design, and System Parameters via Reinforcement Learning 2021 SIGMOD 5.4941082e-05
8,323 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 5.4539294e-05
Previous Page 1 / 1 Next

Semantically Similar Papers