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.9539771e-05
Overall Rank
2,833 | 80.97%
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,208 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.8445332e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,879 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 7.9126862e-05
3,685 Cloudy with High Chance of DBMS: A 10-year Prediction for Enterprise-Grade ML 2020 CIDR 7.0972826e-05
3,948 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9051584e-05
4,240 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.7064546e-05
5,062 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.2896995e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2678118e-05
5,700 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.028998e-05
5,715 Detect, Distill and Update: Learned DB Systems Facing Out of Distribution Data 2023 SIGMOD 6.0178585e-05
5,850 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9697921e-05
5,895 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9534254e-05
6,248 The Cosmos Big Data Platform at Microsoft: Over a Decade of Progress and a Decade to Look Forward 2021 VLDB 5.8345657e-05
6,408 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.7921918e-05
6,579 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.7421583e-05
7,021 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.6168049e-05
7,160 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 5.5945786e-05
7,163 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5935766e-05
7,356 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5421826e-05
7,464 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5189616e-05
7,767 AutoToken: Predicting Peak Parallelism for Big Data Analytics at Microsoft 2020 VLDB 5.4550466e-05
7,813 Machine Learning for Cloud Data Systems: the Progress so far and the Path Forward 2021 VLDB 5.4474823e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
8,349 SparkCruise: Workload Optimization in Managed Spark Clusters at Microsoft 2021 VLDB 5.3485189e-05
8,357 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3463255e-05
8,881 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.255975e-05
8,952 Machine Unlearning in Learned Databases: An Experimental Analysis 2024 SIGMOD 5.2517414e-05
9,010 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.2371313e-05
9,367 Phoebe: A Learning-based Checkpoint Optimizer 2021 VLDB 5.1845217e-05
9,787 Optimizing Dataflow Systems for Scalable Interactive Visualization 2024 SIGMOD 5.1276108e-05
9,796 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1236285e-05
9,962 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1014161e-05
10,319 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0362412e-05
10,615 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9769913e-05
10,703 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9769913e-05
10,751 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9769913e-05
11,232 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9769913e-05
11,291 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.9769913e-05
11,436 AXE: A Task Decomposition Approach to Learned LSM Tuning 2025 VLDB 4.9769913e-05
11,783 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9769913e-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.00061067652
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050475202
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046363107
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034099838
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
555 SageDB: A Learned Database System 2019 CIDR 0.0001650754
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014814858
691 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014737455
892 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013221727
1,158 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011767292
1,432 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010676754
1,568 HELIX: Holistic Optimization for Accelerating Iterative Machine Learning 2019 VLDB 0.00010208225
1,588 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010137374
1,747 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.7303647e-05
2,448 Azure Data Lake Store: A Hyperscale Distributed File Service for Big Data Analytics 2017 SIGMOD 8.4508839e-05
3,297 Automated Verification of Query Equivalence Using Satisfiability Modulo Theories 2019 VLDB 7.4421962e-05
3,544 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.2108612e-05
3,637 Advanced Join Strategies for Large-Scale Distributed Computation 2014 VLDB 7.1437959e-05
4,472 Recurring Job Optimization in Scope 2012 SIGMOD 6.5822904e-05
4,820 Continuous Cloud-Scale Query Optimization and Processing 2013 VLDB 6.3935932e-05
7,315 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.5529695e-05
9,557 Redoop Infrastructure for Recurring Big Data Queries 2014 VLDB 5.1577635e-05
9,999 SparkCruise: Handsfree Computation Reuse in Spark 2019 VLDB 5.0964027e-05
Previous Page 1 / 1 Next

Semantically Similar Papers