DBScholar

Back to papers

Plan-Structured Deep Neural Network Models for Query Performance Prediction

Summary: Plan-structured deep neural networks that mirror optimizer plans to predict query latency. No hand-crafted features; learns operator-input interactions, adapts to workloads, with training optimizations, achieving state-of-the-art performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hee6e281a3bbcfd74
Venue
VLDB
Year
2019
Pagerank
0.00016408613
Overall Rank
560 | 96.24%
DOI
10.14778/3342263.3342646
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{marcus_vldb19,
        title = {{Plan-Structured Deep Neural Network Models for Query Performance Prediction}},
        author = {Marcus, Ryan and Papaemmanouil, Olga},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {11},
        pages = {1733--1746},
        doi = {10.14778/3342263.3342646},
        url = {https://doi.org/10.14778/3342263.3342646},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 77 citing papers.

Rank Citing Paper Year Venue Pagerank
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
1,396 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010788714
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,525 Updatable Learned Index with Precise Positions 2021 VLDB 0.00010355133
2,209 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8360101e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,278 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7057608e-05
2,393 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5298464e-05
2,686 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1300913e-05
2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.9495917e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
2,879 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 7.9126862e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8716173e-05
3,272 Estimating Cardinalities with Deep Sketches 2019 SIGMOD 7.4711788e-05
3,565 Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift 2023 SIGMOD 7.200937e-05
3,588 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1841858e-05
3,680 openGauss: An Autonomous Database System 2021 VLDB 7.1016555e-05
3,701 Stable Learned Bloom Filters for Data Streams 2020 VLDB 7.0820503e-05
3,964 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.889374e-05
4,240 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.7064546e-05
4,536 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.552998e-05
4,713 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4543291e-05
4,743 Machine Learning for Databases 2021 VLDB 6.4379536e-05
5,062 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.2896995e-05
5,129 Monotonic Cardinality Estimation of Similarity Selection: A Deep Learning Approach 2020 SIGMOD 6.2582129e-05
5,188 Database Workload Characterization with Query Plan Encoders 2022 VLDB 6.2346845e-05
5,216 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.2218868e-05
5,316 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 6.1827415e-05
5,438 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1278045e-05
5,482 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.1123461e-05
5,675 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0401656e-05
5,850 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9697921e-05
6,141 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8708409e-05
6,408 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7921918e-05
7,021 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.6168049e-05
7,163 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5935766e-05
7,219 Refactoring Index Tuning Process with Benefit Estimation 2024 VLDB 5.5808392e-05
7,464 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5189616e-05
7,546 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4966669e-05
7,869 Blueprinting the Cloud: Unifying and Automatically Optimizing Cloud Data Infrastructures with BRAD 2024 VLDB 5.4342182e-05
7,909 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4266123e-05
7,915 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.4258674e-05
7,981 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.4117272e-05
8,570 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3113492e-05
8,638 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2965922e-05
8,881 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.255975e-05
8,969 Conformal Prediction for Verifiable Learned Query Optimization 2025 VLDB 5.2477982e-05
9,124 Check Out the Big Brain on BRAD: Simplifying Cloud Data Processing with Learned Automated Data Meshes 2023 VLDB 5.2247088e-05
9,134 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2223611e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 21 of 21 cited papers.

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

Rank Cited Paper Year Venue Pagerank
21 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00056835296
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046363107
53 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.000408505
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034099838
158 Deep Learning for Entity Matching: A Design Space Exploration 2018 SIGMOD 0.00028038831
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017955913
480 The Making of TPC-DS 2006 VLDB 0.00017615432
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016244162
629 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD 0.00015428007
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014814858
1,158 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011767292
1,688 ParaTimer: A Progress Indicator for MapReduce DAGs 2010 SIGMOD 9.860716e-05
2,432 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4742372e-05
2,625 Statistical Learning Techniques for Costing XML Queries 2005 VLDB 8.206615e-05
2,983 WiSeDB: A Learning-based Workload Management Advisor for Cloud Databases 2016 VLDB 7.7831414e-05
3,057 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6960881e-05
3,519 Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads 2013 VLDB 7.2361015e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8357659e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB
2 7,356 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB
3 318 DeepDB: Learn from Data, not from Queries! 2020 VLDB
4 3,057 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR
5 1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
6 9,342 Deep Query Optimization 2019 SIGMOD
7 9,962 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB
8 5,159 Facilitating SQL Query Composition and Analysis 2020 SIGMOD
9 2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB
10 5,188 Database Workload Characterization with Query Plan Encoders 2022 VLDB