DBScholar

Back to papers

Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems

Summary: Boot accelerates behavior-model training for self-driving DBMSs via macro/micro acceleration: approximate runtime telemetry, altered query semantics, and skipped repetitive executions. In PostgreSQL, it cuts data-collection time up to 268× with modest accuracy loss. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h4c78e0809a59b4cb
Venue
VLDB
Year
2024
Pagerank
5.2223611e-05
Overall Rank
9,134 | 38.61%
DOI
10.14778/3681954.3682030
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{lim_vldb24,
        title = {{Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems}},
        author = {Lim, Wan Shen and Ma, Lin and Zhang, William and Butrovich, Matthew and Arch, Samuel and Pavlo, Andrew},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {11},
        pages = {3680--3693},
        doi = {10.14778/3681954.3682030},
        url = {https://doi.org/10.14778/3681954.3682030},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 48 of 48 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
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028664776
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018310278
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017841988
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016408613
792 Parametric Query Optimization 1992 VLDB 0.00013938197
837 Proactive Re-Optimization 2005 SIGMOD 0.00013551072
1,061 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012208639
1,158 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011767292
1,195 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011574218
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010398346
1,588 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010137374
2,167 Data Synthesis based on Generative Adversarial Networks 2018 VLDB 8.9299807e-05
2,278 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7057608e-05
2,320 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6429103e-05
2,393 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5298464e-05
2,455 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4377251e-05
2,476 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.407183e-05
2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.9495917e-05
3,104 Oracle Database Replay 2008 SIGMOD 7.6450896e-05
3,208 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5355264e-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
3,964 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.889374e-05
4,970 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3319052e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2678118e-05
5,216 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.2218868e-05
5,284 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1963031e-05
5,482 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.1123461e-05
5,632 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0554368e-05
6,002 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 5.9149725e-05
6,141 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8708409e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8357659e-05
6,408 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7921918e-05
6,458 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.7755054e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
7,915 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.4258674e-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,357 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3463255e-05
9,711 Database Gyms 2023 CIDR 5.1352441e-05
9,796 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1236285e-05
9,950 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 5.102891e-05
Previous Page 1 / 1 Next

Semantically Similar Papers