DBScholar

Back to papers

The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions

Summary: Proto-X holistically tunes multiple DBMS configuration spaces, learning cross-space similarities and synthesizing proto-actions to coordinate search rather than sequentially tuning knobs, hints, and indexes. On PostgreSQL, it handles orders-of-magnitude larger spaces and improves performance up to 53% over prior methods. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h0d2ec23d398ffd06
Venue
VLDB
Year
2024
Pagerank
5.4117272e-05
Overall Rank
7,981 | 46.36%
DOI
10.14778/3681954.3682007
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zhang_vldb24,
        title = {{The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions}},
        author = {Zhang, William and Lim, Wan Shen and Butrovich, Matthew and Pavlo, Andrew},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {11},
        pages = {3373--3387},
        doi = {10.14778/3681954.3682007},
        url = {https://doi.org/10.14778/3681954.3682007},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 50 of 67 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
78 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00036675568
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
235 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023689995
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021276452
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019541534
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019507406
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018310278
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017841988
492 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017406029
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016408613
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014251362
1,195 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011574218
1,280 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011224914
1,289 An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems 2021 VLDB 0.00011159167
1,396 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010788714
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010398346
2,209 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8360101e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,278 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7057608e-05
2,393 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5298464e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0401855e-05
2,770 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0343719e-05
2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.9495917e-05
3,052 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.704739e-05
3,159 CGPTuner: a Contextual Gaussian Process Bandit Approach for the Automatic Tuning of IT Configurations Under Varying Workload Conditions 2021 VLDB 7.5797912e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4233639e-05
3,588 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1841858e-05
3,648 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1366536e-05
3,708 The Case for a Learned Sorting Algorithm 2020 SIGMOD 7.0781032e-05
3,964 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.889374e-05
4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8561069e-05
4,191 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7425275e-05
4,198 Proteus: A Self-Designing Range Filter 2022 SIGMOD 6.7385809e-05
4,470 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5833414e-05
4,677 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4721041e-05
4,713 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4543291e-05
4,851 The RLR-Tree: A Reinforcement Learning Based R-Tree for Spatial Data 2023 SIGMOD 6.377837e-05
4,970 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3319052e-05
5,020 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3096708e-05
5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2995365e-05
5,062 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.2896995e-05
5,188 Database Workload Characterization with Query Plan Encoders 2022 VLDB 6.2346845e-05
5,216 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.2218868e-05
5,236 FASTgres: Making Learned Query Optimizer Hinting Effective 2023 VLDB 6.2153504e-05
Previous Page 1 / 2 Next

Semantically Similar Papers