DBScholar

Back to papers

Learning a Partitioning Advisor for Cloud Databases

Summary: DRL-based partitioning advisor for cloud DBMS automates partitioning decisions for OLAP workloads by learning cost tradeoffs and placement policies. Evaluations show it finds non-trivial partitionings across diverse workloads and outperforms classical automated approaches. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5981
Venue
SIGMOD
Year
2020
Pagerank
8.4993549e-05
Overall Rank
2,499 | 82.86%
DOI
10.1145/3318464.3389704

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{hilprecht_sigmod20,
        title = {{Learning a Partitioning Advisor for Cloud Databases}},
        author = {Hilprecht, Benjamin and Binnig, Carsten and Röhm, Uwe},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3389704},
        url = {https://dl.acm.org/doi/10.1145/3318464.3389704},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 24 of 24 citing papers.

Rank Citing Paper Year Venue Pagerank
1,241 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011521639
1,337 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011117488
1,631 High-Throughput Vector Similarity Search in Knowledge Graphs 2023 SIGMOD 0.00010174628
2,844 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.0608767e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,035 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 7.8297746e-05
3,926 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.0128068e-05
4,468 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.6819041e-05
5,340 Machine Learning for Databases 2021 VLDB 6.2603359e-05
5,558 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.1749098e-05
6,042 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9970052e-05
6,480 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.8669819e-05
6,600 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.8250114e-05
6,670 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.8074043e-05
7,311 Lachesis: Automatic Partitioning for UDF-Centric Analytics 2021 VLDB 5.6491618e-05
8,042 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.5015896e-05
8,204 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4667903e-05
8,410 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.4309397e-05
8,698 SkinnerMT: Parallelizing for Efficiency and Robustness in Adaptive Query Processing on Multicore Platforms 2023 VLDB 5.3830073e-05
8,854 Towards Foundation Database Models 2025 CIDR 5.357608e-05
8,984 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.3395569e-05
10,059 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1664022e-05
10,518 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 5.093636e-05
10,942 HAWK: A Workload-driven Hierarchical Deadlock Detection Approach in Distributed Database System 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 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
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
126 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030779127
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
184 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00026256101
234 Self-Driving Database Management Systems 2017 CIDR 0.00023810722
246 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023457421
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
471 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.0001793564
501 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001738508
568 SageDB: A Learned Database System 2019 CIDR 0.0001641553
1,852 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.6134443e-05
2,666 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.2764713e-05
3,200 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.642132e-05
4,456 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.692321e-05
5,072 NashDB: An End-to-End Economic Method for Elastic Database Fragmentation, Replication, and Provisioning 2018 SIGMOD 6.3753956e-05
7,194 Model-Free Control for Distributed Stream Data Processing using Deep Reinforcement Learning 2018 VLDB 5.6766532e-05
7,585 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.5912479e-05
Previous Page 1 / 1 Next

Semantically Similar Papers