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
h1b306650d959d14c
Venue
SIGMOD
Year
2020
Pagerank
8.407183e-05
Overall Rank
2,476 | 83.36%
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 25 of 25 citing papers.

Rank Citing Paper Year Venue Pagerank
1,195 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011574218
1,245 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.0001136308
1,373 High-Throughput Vector Similarity Search in Knowledge Graphs 2023 SIGMOD 0.00010891169
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0401855e-05
2,879 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 7.9126862e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8716173e-05
3,648 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1366536e-05
4,536 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.552998e-05
4,743 Machine Learning for Databases 2021 VLDB 6.4379536e-05
5,675 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0401656e-05
5,842 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.971167e-05
6,600 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.737874e-05
6,715 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.6989853e-05
6,732 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6921776e-05
7,386 Towards Foundation Database Models 2025 CIDR 5.5360368e-05
7,388 Lachesis: Automatic Partitioning for UDF-Centric Analytics 2021 VLDB 5.5355684e-05
7,749 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4585522e-05
8,210 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.3761621e-05
8,570 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3113492e-05
8,860 SkinnerMT: Parallelizing for Efficiency and Robustness in Adaptive Query Processing on Multicore Platforms 2023 VLDB 5.2620362e-05
9,134 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2223611e-05
9,689 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1402577e-05
10,248 Redbench: Workload Synthesis From Cloud Traces 2026 VLDB 5.0501823e-05
10,713 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9769913e-05
11,338 HAWK: A Workload-driven Hierarchical Deadlock Detection Approach in Distributed Database System 2025 VLDB 4.9769913e-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
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030749898
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
187 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00025914764
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023349603
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021276452
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
473 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017684278
492 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017406029
555 SageDB: A Learned Database System 2019 CIDR 0.0001650754
1,884 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.4349703e-05
2,704 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.1112208e-05
3,241 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.4972383e-05
4,534 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.5535468e-05
5,160 NashDB: An End-to-End Economic Method for Elastic Database Fragmentation, Replication, and Provisioning 2018 SIGMOD 6.2454263e-05
7,317 Model-Free Control for Distributed Stream Data Processing using Deep Reinforcement Learning 2018 VLDB 5.5523211e-05
7,712 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4705892e-05
Previous Page 1 / 1 Next

Semantically Similar Papers