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
13762
Venue
VLDB
Year
2024
Pagerank
5.3395569e-05
Overall Rank
8,984 | 38.37%
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
86 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00035316107
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
156 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028636811
234 Self-Driving Database Management Systems 2017 CIDR 0.00023810722
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00018068441
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
563 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001650812
770 Parametric Query Optimization 1992 VLDB 0.00014166811
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
1,108 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012145154
1,143 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011999403
1,241 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011521639
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,562 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010354429
1,832 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 9.6607418e-05
2,129 Data Synthesis based on Generative Adversarial Networks 2018 VLDB 9.1266572e-05
2,270 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.8310714e-05
2,313 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.762627e-05
2,413 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.6116764e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
2,499 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4993549e-05
2,812 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0979597e-05
3,063 Oracle Database Replay 2008 SIGMOD 7.802088e-05
3,162 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.6785856e-05
3,586 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.2834069e-05
3,926 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.0128068e-05
3,961 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.987575e-05
5,059 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.3807509e-05
5,091 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3669569e-05
5,107 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3623786e-05
5,171 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.3347618e-05
5,767 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0945741e-05
5,869 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0610922e-05
5,906 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 6.0457047e-05
6,024 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 6.0031118e-05
6,138 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.9640712e-05
6,333 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.9094287e-05
6,357 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.9020843e-05
7,750 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.5523652e-05
7,785 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.5450355e-05
7,846 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.5331459e-05
8,193 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.4696038e-05
9,536 Database Gyms 2023 CIDR 5.2529727e-05
9,615 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.2436464e-05
10,082 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 5.1587525e-05
Previous Page 1 / 1 Next

Semantically Similar Papers