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.3938336e-05
Overall Rank
7,997 | 46.40%
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.00061463175
74 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00037164008
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
236 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023639649
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
380 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019530546
382 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.0001946654
411 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.0001874043
458 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017870238
493 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001735831
545 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001657599
756 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014209974
1,175 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011630532
1,282 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011197535
1,294 An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems 2021 VLDB 0.00011129451
1,400 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010759064
1,513 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010394557
1,517 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010385462
2,169 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.9151935e-05
2,190 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8848923e-05
2,290 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.6813363e-05
2,389 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5228689e-05
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
2,768 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0199086e-05
2,772 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0148928e-05
2,779 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0085666e-05
3,057 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.6865211e-05
3,172 CGPTuner: a Contextual Gaussian Process Bandit Approach for the Automatic Tuning of IT Configurations Under Varying Workload Conditions 2021 VLDB 7.5556865e-05
3,269 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.463682e-05
3,575 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1769215e-05
3,655 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1137504e-05
3,715 The Case for a Learned Sorting Algorithm 2020 SIGMOD 7.0549546e-05
3,959 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.8804723e-05
4,022 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8345671e-05
4,202 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7258607e-05
4,207 Proteus: A Self-Designing Range Filter 2022 SIGMOD 6.7226406e-05
4,489 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5619575e-05
4,683 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4545989e-05
4,726 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4329878e-05
4,833 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3834856e-05
4,879 The RLR-Tree: A Reinforcement Learning Based R-Tree for Spatial Data 2023 SIGMOD 6.3567479e-05
4,990 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3120056e-05
5,043 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.28918e-05
5,044 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.2888728e-05
5,062 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2791511e-05
5,211 Database Workload Characterization with Query Plan Encoders 2022 VLDB 6.2141929e-05
5,245 FASTgres: Making Learned Query Optimizer Hinting Effective 2023 VLDB 6.1995935e-05
Previous Page 1 / 2 Next

Semantically Similar Papers