DBScholar

Back to papers

An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems

Summary: ML-based automatic DBMS knob tuning evaluated with OtterTune on Oracle using real workload traces; compares three ML tuning algorithms. Achieves ~45% gains over enterprise configs; reveals deployment and measurement issues absent in synthetic studies. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h140dc404bda7314a
Venue
VLDB
Year
2021
Pagerank
0.00011129451
Overall Rank
1,294 | 91.33%
DOI
10.14778/3450980.3450992
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{aken_vldb21,
        title = {{An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems}},
        author = {Van Aken, Dana and Yang, Dongsheng and Brillard, Sebastien and Fiorino, Ari and Zhang, Bohan and Bilien, Christian and Pavlo, Andrew},
        journal = {PVLDB},
        series = {{VLDB} '21},
        volume = {14},
        number = {7},
        pages = {1241--1253},
        doi = {10.14778/3450980.3450992},
        url = {https://doi.org/10.14778/3450980.3450992},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
1,238 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011375179
2,227 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.7924681e-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,486 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2428834e-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
4,101 Towards Dynamic and Safe Configuration Tuning for Cloud Databases 2022 SIGMOD 6.7930727e-05
4,247 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6920059e-05
4,508 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5553854e-05
4,765 Machine Learning for Databases 2021 VLDB 6.4166895e-05
5,304 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1758143e-05
5,982 Towards instance-optimized data systems 2021 VLDB 5.9096991e-05
6,137 Learning to Optimize LSM-trees: Towards A Reinforcement Learning based Key-Value Store for Dynamic Workloads 2023 SIGMOD 5.8576977e-05
6,752 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6733557e-05
7,092 E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model 2025 VLDB 5.5868637e-05
7,394 ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning 2023 VLDB 5.5202266e-05
7,746 A Progress Report on DBOS: A Database-oriented Operating System 2022 CIDR 5.4456907e-05
7,925 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4086685e-05
7,997 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 5.3938336e-05
8,091 Two is Better Than One: The Case for 2-Tree for Skewed Data Sets 2023 CIDR 5.3744333e-05
8,589 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.2937865e-05
8,866 Demonstrating DB-BERT: A Database Tuning Tool that "Reads" the Manual 2022 SIGMOD 5.2471343e-05
9,243 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 5.1864799e-05
9,469 MLOS in Action: Bridging the Gap Between Experimentation and Auto-Tuning in the Cloud 2024 VLDB 5.1588001e-05
9,655 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.1307018e-05
9,731 Database Gyms 2023 CIDR 5.120066e-05
9,946 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.0910746e-05
9,961 Waffle: In-memory Grid Index for Moving Objects with Reinforcement Learning-based Configuration Tuning System 2022 VLDB 5.0910746e-05
10,324 Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents 2026 VLDB 5.0241309e-05
10,653 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9605343e-05
10,713 ESTune: Bayesian Uncertainty-Guided Early Stopping for Database Configuration Tuning 2026 SIGMOD 4.9605343e-05
10,982 Tuning the Lookahead Distance for PostgreSQL Asynchronous IO 2026 VLDB 4.9605343e-05
10,988 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9605343e-05
11,116 DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning 2026 VLDB 4.9605343e-05
11,142 Libra: One-Shot Parameter Sensitivity Estimation for Transfer Learning in Database Performance Prediction 2026 VLDB 4.9605343e-05
11,790 Auto-Tuning with Reinforcement Learning for Permissioned Blockchain Systems 2023 VLDB 4.9605343e-05
11,838 Demonstrating Waffle: A Self-driving Grid Index 2023 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
74 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00037164008
89 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035265687
122 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030701814
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
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
313 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00021288111
380 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019530546
411 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.0001874043
474 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017638418
583 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.00015964021
869 Index Selection in a Self-Adaptive Data Base Management System 1976 SIGMOD 0.00013326654
893 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013199466
1,013 A Heuristic Approach to Attribute Partitioning 1979 SIGMOD 0.00012475737
1,340 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.00010962559
1,652 SQL Memory Management in Oracle9i 2002 VLDB 9.9624199e-05
1,700 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 9.8224761e-05
2,929 iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases 2019 VLDB 7.830745e-05
3,113 Oracle Database Replay 2008 SIGMOD 7.6200856e-05
Previous Page 1 / 1 Next

Semantically Similar Papers