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.3862675e-05
Overall Rank
2,481 | 83.38%
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,175 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011630532
1,238 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011375179
1,371 High-Throughput Vector Similarity Search in Knowledge Graphs 2023 SIGMOD 0.00010874981
2,619 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.1985665e-05
2,772 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0148928e-05
2,913 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.855786e-05
3,655 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1137504e-05
4,549 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.5328866e-05
4,765 Machine Learning for Databases 2021 VLDB 6.4166895e-05
5,687 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0201937e-05
5,856 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9514226e-05
6,429 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7691021e-05
6,730 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.6801409e-05
6,752 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6733557e-05
7,388 Towards Foundation Database Models 2025 CIDR 5.5211011e-05
7,405 Lachesis: Automatic Partitioning for UDF-Centric Analytics 2021 VLDB 5.5172664e-05
7,745 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4457135e-05
8,225 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.3583852e-05
8,589 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.2937865e-05
8,872 SkinnerMT: Parallelizing for Efficiency and Robustness in Adaptive Query Processing on Multicore Platforms 2023 VLDB 5.2459616e-05
9,154 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2050937e-05
9,718 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1232608e-05
10,278 Redbench: Workload Synthesis From Cloud Traces 2026 VLDB 5.0334833e-05
10,774 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9605343e-05
11,391 HAWK: A Workload-driven Hierarchical Deadlock Detection Approach in Distributed Database System 2025 VLDB 4.9605343e-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.00061463175
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
122 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030701814
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
189 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00025846085
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023296011
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
474 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017638418
493 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001735831
550 SageDB: A Learned Database System 2019 CIDR 0.00016525249
1,892 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.405261e-05
2,714 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 8.0855228e-05
3,258 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 7.4730157e-05
4,550 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.5327021e-05
5,181 NashDB: An End-to-End Economic Method for Elastic Database Fragmentation, Replication, and Provisioning 2018 SIGMOD 6.2255681e-05
7,333 Model-Free Control for Distributed Stream Data Processing using Deep Reinforcement Learning 2018 VLDB 5.5344269e-05
7,725 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4526728e-05
Previous Page 1 / 1 Next

Semantically Similar Papers