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.00011159167
Overall Rank
1,289 | 91.34%
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,245 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.0001136308
2,227 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.8007923e-05
2,770 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0343719e-05
3,052 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.704739e-05
3,487 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2603973e-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
4,080 Towards Dynamic and Safe Configuration Tuning for Cloud Databases 2022 SIGMOD 6.8151596e-05
4,240 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.7064546e-05
4,485 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5771335e-05
4,743 Machine Learning for Databases 2021 VLDB 6.4379536e-05
5,284 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1963031e-05
5,973 Towards instance-optimized data systems 2021 VLDB 5.9281867e-05
6,123 Learning to Optimize LSM-trees: Towards A Reinforcement Learning based Key-Value Store for Dynamic Workloads 2023 SIGMOD 5.8771312e-05
6,732 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6921776e-05
7,072 E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model 2025 VLDB 5.6053987e-05
7,372 ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning 2023 VLDB 5.5385404e-05
7,732 A Progress Report on DBOS: A Database-oriented Operating System 2022 CIDR 5.4637552e-05
7,909 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4266123e-05
7,981 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.4117272e-05
8,075 Two is Better Than One: The Case for 2-Tree for Skewed Data Sets 2023 CIDR 5.3921263e-05
8,570 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3113492e-05
8,847 Demonstrating DB-BERT: A Database Tuning Tool that "Reads" the Manual 2022 SIGMOD 5.2645421e-05
9,440 MLOS in Action: Bridging the Gap Between Experimentation and Auto-Tuning in the Cloud 2024 VLDB 5.1759149e-05
9,627 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.1477233e-05
9,711 Database Gyms 2023 CIDR 5.1352441e-05
9,911 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.1079647e-05
9,926 Waffle: In-memory Grid Index for Moving Objects with Reinforcement Learning-based Configuration Tuning System 2022 VLDB 5.1079647e-05
10,297 Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents 2026 VLDB 5.0407989e-05
10,591 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9769913e-05
10,652 ESTune: Bayesian Uncertainty-Guided Early Stopping for Database Configuration Tuning 2026 SIGMOD 4.9769913e-05
10,921 Tuning the Lookahead Distance for PostgreSQL Asynchronous IO 2026 VLDB 4.9769913e-05
10,927 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9769913e-05
11,055 DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning 2026 VLDB 4.9769913e-05
11,081 Libra: One-Shot Parameter Sensitivity Estimation for Transfer Learning in Database Performance Prediction 2026 VLDB 4.9769913e-05
11,439 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 4.9769913e-05
11,746 Auto-Tuning with Reinforcement Learning for Permissioned Blockchain Systems 2023 VLDB 4.9769913e-05
11,794 Demonstrating Waffle: A Self-driving Grid Index 2023 VLDB 4.9769913e-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
78 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00036675568
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035340164
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030749898
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025619089
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
322 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00021034201
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019541534
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018310278
473 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017684278
598 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.0001575517
868 Index Selection in a Self-Adaptive Data Base Management System 1976 SIGMOD 0.00013366108
892 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013221727
1,013 A Heuristic Approach to Attribute Partitioning 1979 SIGMOD 0.00012513898
1,332 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.00010993664
1,660 SQL Memory Management in Oracle9i 2002 VLDB 9.9581502e-05
1,699 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 9.8403606e-05
3,032 iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases 2019 VLDB 7.7317595e-05
3,104 Oracle Database Replay 2008 SIGMOD 7.6450896e-05
Previous Page 1 / 1 Next

Semantically Similar Papers