DBScholar

Back to papers

Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings

Summary: Workload-driven cost models for big data queries, integrated into a Cascade-style optimizer to optimize plans and containers. In production, Cleo/SCOPE sees 2–3 orders higher accuracy and 20x correlation; ~70% plan changes cut latency and save resources. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h3d30e05cbad3b0e4
Venue
SIGMOD
Year
2020
Pagerank
7.9560627e-05
Overall Rank
2,834 | 80.95%
DOI
10.1145/3318464.3380584

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{siddiqui_sigmod20,
        title = {{Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings}},
        author = {Siddiqui, Tarique and Jindal, Alekh and Qiao, Shi and Patel, Hiren and Le, Wangchao},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3380584},
        url = {https://dl.acm.org/doi/10.1145/3318464.3380584},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 40 of 40 citing papers.

Rank Citing Paper Year Venue Pagerank
2,207 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.8487039e-05
2,250 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7533306e-05
2,885 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 7.9094988e-05
3,683 Cloudy with High Chance of DBMS: A 10-year Prediction for Enterprise-Grade ML 2020 CIDR 7.1006425e-05
3,949 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9052796e-05
4,258 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6994722e-05
5,058 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.2926774e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.269351e-05
5,716 Detect, Distill and Update: Learned DB Systems Facing Out of Distribution Data 2023 SIGMOD 6.0194657e-05
5,865 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9659203e-05
5,871 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.9639223e-05
5,902 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9536872e-05
6,245 The Cosmos Big Data Platform at Microsoft: Over a Decade of Progress and a Decade to Look Forward 2021 VLDB 5.837329e-05
6,416 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7920805e-05
6,576 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.7448779e-05
7,033 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.6168499e-05
7,157 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 5.5972283e-05
7,160 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5962258e-05
7,363 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5418564e-05
7,460 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5215755e-05
7,759 AutoToken: Predicting Peak Parallelism for Big Data Analytics at Microsoft 2020 VLDB 5.4575614e-05
7,806 Machine Learning for Cloud Data Systems: the Progress so far and the Path Forward 2021 VLDB 5.4500623e-05
7,900 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4303143e-05
8,346 SparkCruise: Workload Optimization in Managed Spark Clusters at Microsoft 2021 VLDB 5.3510511e-05
8,352 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3488341e-05
8,872 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.2584643e-05
8,947 Machine Unlearning in Learned Databases: An Experimental Analysis 2024 SIGMOD 5.2532248e-05
9,012 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.2375369e-05
9,358 Phoebe: A Learning-based Checkpoint Optimizer 2021 VLDB 5.1869771e-05
9,781 Optimizing Dataflow Systems for Scalable Interactive Visualization 2024 SIGMOD 5.1300393e-05
9,790 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1260323e-05
9,956 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1038322e-05
10,309 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0386264e-05
10,604 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,693 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9793485e-05
10,741 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9793485e-05
11,224 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9793485e-05
11,283 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.9793485e-05
11,430 AXE: A Task Decomposition Approach to Learned LSM Tuning 2025 VLDB 4.9793485e-05
11,777 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 24 of 24 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.00061066921
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050495102
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046284649
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
555 SageDB: A Learned Database System 2019 CIDR 0.00016506678
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.0001481781
692 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014741011
892 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013227162
1,159 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011771949
1,433 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010677711
1,568 HELIX: Holistic Optimization for Accelerating Iterative Machine Learning 2019 VLDB 0.0001021302
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.0001014156
1,745 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.7343818e-05
2,446 Azure Data Lake Store: A Hyperscale Distributed File Service for Big Data Analytics 2017 SIGMOD 8.4547121e-05
3,297 Automated Verification of Query Equivalence Using Satisfiability Modulo Theories 2019 VLDB 7.4452842e-05
3,545 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.2134803e-05
3,636 Advanced Join Strategies for Large-Scale Distributed Computation 2014 VLDB 7.1471007e-05
4,470 Recurring Job Optimization in Scope 2012 SIGMOD 6.5853561e-05
4,818 Continuous Cloud-Scale Query Optimization and Processing 2013 VLDB 6.3964573e-05
7,312 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.5555613e-05
9,548 Redoop Infrastructure for Recurring Big Data Queries 2014 VLDB 5.1601681e-05
9,993 SparkCruise: Handsfree Computation Reuse in Spark 2019 VLDB 5.0988164e-05
Previous Page 1 / 1 Next

Semantically Similar Papers