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
5859
Venue
SIGMOD
Year
2020
Pagerank
8.0898536e-05
Overall Rank
2,822 | 80.64%
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,355 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7022189e-05
2,651 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.2918086e-05
2,844 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 8.0608767e-05
3,614 Cloudy with High Chance of DBMS: A 10-year Prediction for Enterprise-Grade ML 2020 CIDR 7.2568185e-05
3,998 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9676473e-05
4,434 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.7079088e-05
5,059 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.3807509e-05
5,388 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.2362811e-05
6,121 The Cosmos Big Data Platform at Microsoft: Over a Decade of Progress and a Decade to Look Forward 2021 VLDB 5.9688569e-05
6,132 Detect, Distill and Update: Learned DB Systems Facing Out of Distribution Data 2023 SIGMOD 5.9660278e-05
6,323 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9141228e-05
6,357 A Unified Transferable Model for ML-Enhanced DBMS 2022 CIDR 5.9020843e-05
6,434 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.8799421e-05
6,462 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.8717744e-05
6,921 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.7388557e-05
7,580 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 5.5925285e-05
7,589 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5907048e-05
7,619 AutoToken: Predicting Peak Parallelism for Big Data Analytics at Microsoft 2020 VLDB 5.5810604e-05
7,661 Machine Learning for Cloud Data Systems: the Progress so far and the Path Forward 2021 VLDB 5.5736026e-05
7,750 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.5523652e-05
8,040 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5018396e-05
8,175 SparkCruise: Workload Optimization in Managed Spark Clusters at Microsoft 2021 VLDB 5.4737932e-05
8,193 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.4696038e-05
8,448 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.4235725e-05
8,572 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.4102362e-05
8,783 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.3740362e-05
8,849 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.3577504e-05
9,224 Phoebe: A Learning-based Checkpoint Optimizer 2021 VLDB 5.3035811e-05
9,587 Machine Unlearning in Learned Databases: An Experimental Analysis 2024 SIGMOD 5.2525104e-05
9,615 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.2436464e-05
9,734 Optimizing Dataflow Systems for Scalable Interactive Visualization 2024 SIGMOD 5.227679e-05
10,413 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 5.093636e-05
10,508 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 5.093636e-05
10,559 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 5.093636e-05
10,768 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.093636e-05
10,815 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 5.093636e-05
10,881 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 5.093636e-05
11,073 AXE: A Task Decomposition Approach to Learned LSM Tuning 2025 VLDB 5.093636e-05
11,083 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.093636e-05
11,466 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 5.093636e-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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00051174276
43 The Case for Learned Index Structures 2018 SIGMOD 0.00046060254
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
568 SageDB: A Learned Database System 2019 CIDR 0.0001641553
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00015014887
697 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014888851
895 Runtime Measurements in the Cloud: Observing, Analyzing, and Reducing Variance 2010 VLDB 0.00013357681
1,143 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011999403
1,468 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010686496
1,562 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010354429
1,569 HELIX: Holistic Optimization for Accelerating Iterative Machine Learning 2019 VLDB 0.00010335423
1,765 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.8079546e-05
2,477 Azure Data Lake Store: A Hyperscale Distributed File Service for Big Data Analytics 2017 SIGMOD 8.5239378e-05
3,327 Automated Verification of Query Equivalence Using Satisfiability Modulo Theories 2019 VLDB 7.518491e-05
3,578 Advanced Join Strategies for Large-Scale Distributed Computation 2014 VLDB 7.2899943e-05
3,605 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.2640711e-05
4,400 Recurring Job Optimization in Scope 2012 SIGMOD 6.7239302e-05
4,742 Continuous Cloud-Scale Query Optimization and Processing 2013 VLDB 6.5269203e-05
7,182 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.6793679e-05
9,369 Redoop Infrastructure for Recurring Big Data Queries 2014 VLDB 5.2774963e-05
9,854 SparkCruise: Handsfree Computation Reuse in Spark 2019 VLDB 5.2091816e-05
Previous Page 1 / 1 Next

Semantically Similar Papers