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.2229655e-05
Overall Rank
9,133 | 38.60%
DOI
10.14778/3681954.3682030

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.00036684414
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028672526
224 Self-Driving Database Management Systems 2017 CIDR 0.00024013745
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021167555
362 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019989474
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018315867
460 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017842695
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016403151
792 Parametric Query Optimization 1992 VLDB 0.00013942753
836 Proactive Re-Optimization 2005 SIGMOD 0.00013557047
1,082 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012122749
1,159 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011771949
1,199 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011563985
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010417728
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.0001014156
2,165 Data Synthesis based on Generative Adversarial Networks 2018 VLDB 8.933677e-05
2,275 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7090584e-05
2,318 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6464837e-05
2,395 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5281914e-05
2,456 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4377192e-05
2,478 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4079121e-05
2,842 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.949193e-05
3,102 Oracle Database Replay 2008 SIGMOD 7.6485305e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-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
3,965 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.8918628e-05
4,968 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3348803e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.269351e-05
5,214 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.2248104e-05
5,286 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1971399e-05
5,481 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.1125124e-05
5,630 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0582762e-05
6,004 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 5.9166815e-05
6,141 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8733296e-05
6,241 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8381762e-05
6,416 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7920805e-05
6,456 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.7782179e-05
7,900 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4303143e-05
7,915 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.4276987e-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,352 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3488341e-05
9,706 Database Gyms 2023 CIDR 5.1376763e-05
9,790 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1260323e-05
10,297 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 5.0430432e-05
Previous Page 1 / 1 Next

Semantically Similar Papers