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
12502
Venue
VLDB
Year
2021
Pagerank
0.00011094717
Overall Rank
1,344 | 90.79%
DOI
10.14778/3450980.3450992

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 36 of 36 citing papers.

Rank Citing Paper Year Venue Pagerank
1,337 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011117488
2,298 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.7886538e-05
2,740 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.1855759e-05
3,343 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.4983591e-05
3,586 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.2834069e-05
3,587 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2829345e-05
3,926 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.0128068e-05
4,011 Towards Dynamic and Safe Configuration Tuning for Cloud Databases 2022 SIGMOD 6.959982e-05
4,434 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.7079088e-05
5,169 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.3349035e-05
5,171 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.3347618e-05
5,340 Machine Learning for Databases 2021 VLDB 6.2603359e-05
5,974 Towards instance-optimized data systems 2021 VLDB 6.0230488e-05
6,600 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.8250114e-05
6,843 Learning to Optimize LSM-trees: Towards A Reinforcement Learning based Key-Value Store for Dynamic Workloads 2023 SIGMOD 5.7573899e-05
6,997 E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model 2025 VLDB 5.7300324e-05
7,582 A Progress Report on DBOS: A Database-oriented Operating System 2022 CIDR 5.5918081e-05
7,757 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.5508469e-05
7,846 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.5331459e-05
7,978 ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning 2023 VLDB 5.514996e-05
8,016 Two is Better Than One: The Case for 2-Tree for Skewed Data Sets 2023 CIDR 5.5070057e-05
8,410 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.4309397e-05
8,669 Demonstrating DB-BERT: A Database Tuning Tool that "Reads" the Manual 2022 SIGMOD 5.3879261e-05
9,257 MLOS in Action: Bridging the Gap Between Experimentation and Auto-Tuning in the Cloud 2024 VLDB 5.2972217e-05
9,441 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.2678428e-05
9,536 Database Gyms 2023 CIDR 5.2529727e-05
9,739 Waffle: In-memory Grid Index for Moving Objects with Reinforcement Learning-based Configuration Tuning System 2022 VLDB 5.227679e-05
10,340 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.093636e-05
10,384 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 5.093636e-05
10,453 ESTune: Bayesian Uncertainty-Guided Early Stopping for Database Configuration Tuning 2026 SIGMOD 5.093636e-05
10,535 Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents 2026 VLDB 5.093636e-05
10,599 DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning 2026 VLDB 5.093636e-05
10,626 Libra: One-Shot Parameter Sensitivity Estimation for Transfer Learning in Database Performance Prediction 2026 VLDB 5.093636e-05
11,076 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 5.093636e-05
11,426 Auto-Tuning with Reinforcement Learning for Permissioned Blockchain Systems 2023 VLDB 5.093636e-05
11,478 Demonstrating Waffle: A Self-driving Grid Index 2023 VLDB 5.093636e-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
86 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00035316107
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
126 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030779127
199 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025612088
226 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00024027277
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
347 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00020651582
387 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019442332
471 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.0001793564
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
625 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.0001566968
854 Index Selection in a Self-Adaptive Data Base Management System 1976 SIGMOD 0.00013581028
895 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013357681
996 A Heuristic Approach to Attribute Partitioning 1979 SIGMOD 0.00012758481
1,315 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.00011181796
1,686 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 0.00010008686
1,706 SQL Memory Management in Oracle9i 2002 VLDB 9.9628446e-05
3,063 Oracle Database Replay 2008 SIGMOD 7.802088e-05
3,219 iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases 2019 VLDB 7.6283153e-05
Previous Page 1 / 1 Next

Semantically Similar Papers