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.00011162479
Overall Rank
1,289 | 91.34%
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 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
1,250 DB-BERT: A Database Tuning Tool that "Reads the Manual" 2022 SIGMOD 0.00011339256
2,231 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.7982985e-05
2,772 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.035288e-05
3,051 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.7055931e-05
3,486 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2636102e-05
3,590 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1865343e-05
3,645 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1397796e-05
4,079 Towards Dynamic and Safe Configuration Tuning for Cloud Databases 2022 SIGMOD 6.818264e-05
4,258 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6994722e-05
4,482 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5802486e-05
4,741 Machine Learning for Databases 2021 VLDB 6.4410027e-05
5,286 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1971399e-05
5,974 Towards instance-optimized data systems 2021 VLDB 5.9305575e-05
6,124 Learning to Optimize LSM-trees: Towards A Reinforcement Learning based Key-Value Store for Dynamic Workloads 2023 SIGMOD 5.8788211e-05
6,726 A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning 2023 SIGMOD 5.6948731e-05
7,070 E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model 2025 VLDB 5.6080535e-05
7,367 ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning 2023 VLDB 5.5411636e-05
7,726 A Progress Report on DBOS: A Database-oriented Operating System 2022 CIDR 5.4663429e-05
7,905 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4291824e-05
7,977 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.4142519e-05
8,129 Two is Better Than One: The Case for 2-Tree for Skewed Data Sets 2023 CIDR 5.3938156e-05
8,563 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3138647e-05
8,838 Demonstrating DB-BERT: A Database Tuning Tool that "Reads" the Manual 2022 SIGMOD 5.2670355e-05
9,431 MLOS in Action: Bridging the Gap Between Experimentation and Auto-Tuning in the Cloud 2024 VLDB 5.1783663e-05
9,620 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.1501614e-05
9,706 Database Gyms 2023 CIDR 5.1376763e-05
9,904 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.1103839e-05
9,919 Waffle: In-memory Grid Index for Moving Objects with Reinforcement Learning-based Configuration Tuning System 2022 VLDB 5.1103839e-05
10,291 Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents 2026 VLDB 5.0431863e-05
10,580 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9793485e-05
10,641 ESTune: Bayesian Uncertainty-Guided Early Stopping for Database Configuration Tuning 2026 SIGMOD 4.9793485e-05
10,912 Tuning the Lookahead Distance for PostgreSQL Asynchronous IO 2026 VLDB 4.9793485e-05
10,918 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9793485e-05
11,046 DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning 2026 VLDB 4.9793485e-05
11,072 Libra: One-Shot Parameter Sensitivity Estimation for Transfer Learning in Database Performance Prediction 2026 VLDB 4.9793485e-05
11,433 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 4.9793485e-05
11,740 Auto-Tuning with Reinforcement Learning for Permissioned Blockchain Systems 2023 VLDB 4.9793485e-05
11,788 Demonstrating Waffle: A Self-driving Grid Index 2023 VLDB 4.9793485e-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.00036684414
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030762995
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025628849
235 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023697028
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021282642
322 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00021041865
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019549382
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018315867
472 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017692264
598 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.00015761263
867 Index Selection in a Self-Adaptive Data Base Management System 1976 SIGMOD 0.00013371725
892 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013227162
1,013 A Heuristic Approach to Attribute Partitioning 1979 SIGMOD 0.00012519456
1,335 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.0001099401
1,659 SQL Memory Management in Oracle9i 2002 VLDB 9.9624689e-05
1,699 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 9.8445322e-05
3,032 iBTune: Individualized Buffer Tuning for Large-scale Cloud Databases 2019 VLDB 7.7351139e-05
3,102 Oracle Database Replay 2008 SIGMOD 7.6485305e-05
Previous Page 1 / 1 Next

Semantically Similar Papers