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.4079121e-05
Overall Rank
2,478 | 83.35%
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,199 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011563985
1,250 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011339256
1,373 High-Throughput Vector Similarity Search in Knowledge Graphs 2023 SIGMOD 0.0001088854
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0439015e-05
2,885 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 7.9094988e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8742664e-05
3,645 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1397796e-05
4,538 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.553705e-05
4,741 Machine Learning for Databases 2021 VLDB 6.4410027e-05
5,674 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0430252e-05
5,854 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9708829e-05
6,598 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7405915e-05
6,719 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.6985717e-05
6,726 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6948731e-05
7,385 Towards Foundation Database Models 2025 CIDR 5.5385053e-05
7,386 Lachesis: Automatic Partitioning for UDF-Centric Analytics 2021 VLDB 5.538189e-05
8,202 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.378708e-05
8,223 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.3751366e-05
8,563 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3138647e-05
8,850 SkinnerMT: Parallelizing for Efficiency and Robustness in Adaptive Query Processing on Multicore Platforms 2023 VLDB 5.2645282e-05
9,133 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2229655e-05
9,682 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1426922e-05
10,242 Redbench: Workload Synthesis From Cloud Traces 2026 VLDB 5.0525742e-05
10,703 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9793485e-05
11,330 HAWK: A Workload-driven Hierarchical Deadlock Detection Approach in Distributed Database System 2025 VLDB 4.9793485e-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.00061066921
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030762995
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
187 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0002592488
224 Self-Driving Database Management Systems 2017 CIDR 0.00024013745
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023358891
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021282642
461 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017829982
472 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017692264
491 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017413042
555 SageDB: A Learned Database System 2019 CIDR 0.00016506678
1,883 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.4391795e-05
2,704 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.1149334e-05
3,239 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.5007569e-05
4,533 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.5565658e-05
5,159 NashDB: An End-to-End Economic Method for Elastic Database Fragmentation, Replication, and Provisioning 2018 SIGMOD 6.2482448e-05
7,315 Model-Free Control for Distributed Stream Data Processing using Deep Reinforcement Learning 2018 VLDB 5.554799e-05
7,706 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4730676e-05
Previous Page 1 / 1 Next

Semantically Similar Papers