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.9476509e-05
Overall Rank
2,828 | 81.05%
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,169 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.9151935e-05
2,219 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.8186113e-05
2,619 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.1985665e-05
3,691 Cloudy with High Chance of DBMS: A 10-year Prediction for Enterprise-Grade ML 2020 CIDR 7.0771037e-05
3,951 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.8884038e-05
4,247 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6920059e-05
5,043 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.28918e-05
5,126 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2493606e-05
5,713 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.0090633e-05
5,728 Detect, Distill and Update: Learned DB Systems Facing Out of Distribution Data 2023 SIGMOD 5.9979958e-05
5,854 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9520525e-05
5,911 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9338021e-05
6,158 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.8518237e-05
6,260 The Cosmos Big Data Platform at Microsoft: Over a Decade of Progress and a Decade to Look Forward 2021 VLDB 5.815273e-05
6,402 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7800842e-05
6,590 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.7233093e-05
7,162 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 5.5798063e-05
7,169 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5789764e-05
7,377 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5238616e-05
7,483 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5007125e-05
7,764 AutoToken: Predicting Peak Parallelism for Big Data Analytics at Microsoft 2020 VLDB 5.4403231e-05
7,830 Machine Learning for Cloud Data Systems: the Progress so far and the Path Forward 2021 VLDB 5.4294933e-05
7,921 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4098206e-05
8,362 SparkCruise: Workload Optimization in Managed Spark Clusters at Microsoft 2021 VLDB 5.3308358e-05
8,372 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3287108e-05
8,902 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.2387388e-05
8,975 Machine Unlearning in Learned Databases: An Experimental Analysis 2024 SIGMOD 5.2343759e-05
9,031 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.219814e-05
9,394 Phoebe: A Learning-based Checkpoint Optimizer 2021 VLDB 5.1676892e-05
9,819 Optimizing Dataflow Systems for Scalable Interactive Visualization 2024 SIGMOD 5.1106557e-05
9,829 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1066866e-05
9,995 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.0845476e-05
10,347 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0195882e-05
10,676 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,764 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9605343e-05
10,812 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9605343e-05
11,288 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9605343e-05
11,347 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.9605343e-05
11,489 AXE: A Task Decomposition Approach to Learned LSM Tuning 2025 VLDB 4.9605343e-05
11,827 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9605343e-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.00061463175
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050364918
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046249672
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
550 SageDB: A Learned Database System 2019 CIDR 0.00016525249
676 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014838681
690 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014703258
893 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013199466
1,159 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011739527
1,436 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010658836
1,567 HELIX: Holistic Optimization for Accelerating Iterative Machine Learning 2019 VLDB 0.00010179013
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010119368
1,757 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.7050769e-05
2,452 Azure Data Lake Store: A Hyperscale Distributed File Service for Big Data Analytics 2017 SIGMOD 8.4280184e-05
3,294 Automated Verification of Query Equivalence Using Satisfiability Modulo Theories 2019 VLDB 7.4297513e-05
3,550 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.1895215e-05
3,638 Advanced Join Strategies for Large-Scale Distributed Computation 2014 VLDB 7.1248634e-05
4,492 Recurring Job Optimization in Scope 2012 SIGMOD 6.5612113e-05
4,842 Continuous Cloud-Scale Query Optimization and Processing 2013 VLDB 6.3734445e-05
7,332 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.5351368e-05
9,582 Redoop Infrastructure for Recurring Big Data Queries 2014 VLDB 5.1411627e-05
10,034 SparkCruise: Handsfree Computation Reuse in Spark 2019 VLDB 5.0795508e-05
Previous Page 1 / 1 Next

Semantically Similar Papers