Database Paper Browser

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
7239
Venue
SIGMOD
Year
2025
Pagerank
4.4680058e-05
Overall Rank
8,660 | 39.82%
DOI
10.1145/3725316

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank Citing Paper Year Venue Pagerank
9,581 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 4.3186744e-05
9,980 Survivorship Bias in Industrial Database Workloads 2026 CIDR 4.1905499e-05
10,217 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 4.1905499e-05
10,271 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.1905499e-05
10,300 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 4.1905499e-05
10,784 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 4.1905499e-05
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
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059446482
203 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00034868567
329 Neo: A Learned Query Optimizer 2019 VLDB 0.00027301488
422 Measuring the Complexity of Join Enumeration in Query Optimization 1990 VLDB 0.00023654556
634 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00018844568
716 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD 0.00017623897
804 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001643674
876 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00015660534
905 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00015423174
1,273 Amazon Redshift Re-invented 2022 SIGMOD 0.00012870386
1,727 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00010731889
2,090 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 9.5668285e-05
2,154 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.4176683e-05
2,781 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 8.1282042e-05
2,937 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 7.8552033e-05
3,105 GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization 2024 VLDB 7.5567226e-05
3,131 Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet 2024 VLDB 7.5054309e-05
3,167 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 7.4561078e-05
3,241 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 7.32744e-05
3,345 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 7.1908499e-05
3,402 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.134261e-05
3,655 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 6.8723042e-05
3,729 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 6.8078013e-05
3,819 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 6.7267885e-05
4,151 openGauss: An Autonomous Database System 2021 VLDB 6.4020605e-05
4,180 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 6.3725334e-05
4,235 CGPTuner: a Contextual Gaussian Process Bandit Approach for the Automatic Tuning of IT Configurations Under Varying Workload Conditions 2021 VLDB 6.3297728e-05
4,464 LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans 2023 VLDB 6.1552798e-05
4,687 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 5.9915268e-05
5,339 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 5.5596755e-05
5,405 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 5.5243727e-05
5,412 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 5.5200608e-05
5,654 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 5.3882121e-05
5,737 Enabling Incremental Query Re-Optimization 2016 SIGMOD 5.3459609e-05
5,941 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 5.2594013e-05
5,994 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 5.2367998e-05
6,382 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 5.0835686e-05
6,384 Proactive Re-optimization with Rio 2005 SIGMOD 5.0828986e-05
6,883 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 4.8918682e-05
6,971 Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses 2024 SIGMOD 4.8738633e-05
7,126 Guided automated learning for query workload re-optimization 2019 VLDB 4.8184704e-05
7,326 Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries 2023 SIGMOD 4.7563708e-05
8,192 The Fittest Survives: An Adaptive Approach to Query Optimization 1995 VLDB 4.5575625e-05
8,339 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 4.5383933e-05
9,012 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 4.4059413e-05
9,581 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 4.3186744e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
11,352 DeepO: A Learned Query Optimizer 2022 SIGMOD 4.1905499e-05
10,271 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.1905499e-05
6,779 Explaining Inference Queries with Bayesian Optimization 2021 VLDB 4.9232829e-05
8,479 Can Large Language Models Be Query Optimizer for Relational Databases? 2026 SIGMOD 4.4967983e-05
10,219 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.1905499e-05
9,581 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 4.3186744e-05
6,639 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 4.976781e-05
3,658 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 6.8700949e-05
7,009 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8597992e-05
3,729 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 6.8078013e-05