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.2050937e-05
Overall Rank
9,154 | 38.64%
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
74 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00037164008
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028611216
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
411 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.0001874043
458 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017870238
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
545 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001657599
792 Parametric Query Optimization 1992 VLDB 0.00013903954
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
1,065 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012181098
1,159 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011739527
1,175 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011630532
1,513 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010394557
1,517 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010385462
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010119368
2,180 Data Synthesis based on Generative Adversarial Networks 2018 VLDB 8.9007609e-05
2,290 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.6813363e-05
2,329 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6188984e-05
2,389 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5228689e-05
2,461 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4123214e-05
2,481 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.3862675e-05
2,768 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0199086e-05
3,113 Oracle Database Replay 2008 SIGMOD 7.6200856e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-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
3,959 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.8804723e-05
4,833 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3834856e-05
4,990 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3120056e-05
5,126 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2493606e-05
5,304 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1758143e-05
5,484 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0980944e-05
5,645 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0354456e-05
6,014 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 5.8956963e-05
6,113 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8662826e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8220831e-05
6,402 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7800842e-05
6,470 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.7564896e-05
7,715 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.4556951e-05
7,921 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4098206e-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,372 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3287108e-05
9,731 Database Gyms 2023 CIDR 5.120066e-05
9,829 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1066866e-05
9,983 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 5.0860177e-05
Previous Page 1 / 1 Next

Semantically Similar Papers