DBScholar

Back to papers

Learned Offline Query Planning via Bayesian Optimization

Summary: Offline query planning for repeated analytics workloads; learned exploration. Variational auto-encoders + Bayesian optimization search broad plan space, using execution as feedback; outperforms PostgreSQL-optimal and RL baselines on several datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hee0793c233b0c19f
Venue
SIGMOD
Year
2025
Pagerank
5.4784915e-05
Overall Rank
7,561 | 49.32%
DOI
10.1145/3725316

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{tao_sigmod25,
        title = {{Learned Offline Query Planning via Bayesian Optimization}},
        author = {Tao, Jeffrey and Maus, Natalie and Jones, Haydn and Zeng, Yimeng and Gardner, Jacob R. and Marcus, Ryan},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725316},
        url = {https://dl.acm.org/doi/10.1145/3725316},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 46 of 46 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
322 Measuring the Complexity of Join Enumeration in Query Optimization 1990 VLDB 0.00021032289
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
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
628 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD 0.00015421836
651 Amazon Redshift Re-invented 2022 SIGMOD 0.00015126716
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
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,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
1,791 Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet 2024 VLDB 9.6212919e-05
1,803 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.5987229e-05
2,169 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.9151935e-05
2,190 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8848923e-05
2,227 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 8.7924681e-05
2,389 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5228689e-05
2,619 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.1985665e-05
2,696 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1068354e-05
2,779 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0085666e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
3,057 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.6865211e-05
3,172 CGPTuner: a Contextual Gaussian Process Bandit Approach for the Automatic Tuning of IT Configurations Under Varying Workload Conditions 2021 VLDB 7.5556865e-05
3,481 LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans 2023 VLDB 7.2463722e-05
3,687 openGauss: An Autonomous Database System 2021 VLDB 7.0797286e-05
3,951 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.8884038e-05
4,202 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7258607e-05
4,247 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6920059e-05
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
4,683 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4545989e-05
5,126 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2493606e-05
5,453 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1077838e-05
5,457 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1058928e-05
5,673 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.0252485e-05
5,713 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.0090633e-05
5,794 Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries 2023 SIGMOD 5.9759435e-05
6,038 Proactive Re-optimization with Rio 2005 SIGMOD 5.8901698e-05
6,250 Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses 2024 SIGMOD 5.818039e-05
6,779 Guided automated learning for query workload re-optimization 2019 VLDB 5.6686556e-05
7,941 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4056478e-05
8,594 The Fittest Survives: An Adaptive Approach to Query Optimization 1995 VLDB 5.2933942e-05
9,154 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2050937e-05
9,662 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1283524e-05
Previous Page 1 / 1 Next

Semantically Similar Papers