DBScholar

Back to papers

A Spark Optimizer for Adaptive, Fine-Grained Parameter Tuning

Summary: Controls all per-query tunable parameters in Spark’s Adaptive Query Execution via a hybrid compile-time/runtime, multi-granularity scheme to handle diverse, correlated parameters. Poses tuning as multi-objective (latency vs cost), with models/solvers achieving sub-second solves and much better latency/cost tradeoffs (63–65% latency reduction vs 18–25% for prior MOO methods) and superior adaptability to user preferences. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h58217a1be23952b9
Venue
VLDB
Year
2024
Pagerank
5.3884724e-05
Overall Rank
8,026 | 46.21%
DOI
10.14778/3681954.3682021
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{lyu_vldb24,
        title = {{A Spark Optimizer for Adaptive, Fine-Grained Parameter Tuning}},
        author = {Lyu, Chenghao and Fan, Qi and Guyard, Philippe and Diao, Yanlei},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {11},
        pages = {3565--3579},
        doi = {10.14778/3681954.3682021},
        url = {https://doi.org/10.14778/3681954.3682021},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 39 of 39 cited papers.

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

Rank Cited Paper Year Venue Pagerank
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055523999
31 Hive - A Warehousing Solution Over a Map-Reduce Framework 2009 VLDB 0.00049707539
74 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00037164008
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
411 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.0001874043
436 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018274105
655 Building a High-Level Dataflow System on top of Map-Reduce: The Pig Experience 2009 VLDB 0.00015076669
1,304 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011088983
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,700 Black or White? How to Develop an AutoTuner for Memory-based Analytics 2020 SIGMOD 9.8224761e-05
1,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
1,783 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 9.6536753e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,162 Towards Cost-Optimal Query Processing in the Cloud 2021 VLDB 8.9192007e-05
2,181 Fuxi: a Fault-Tolerant Resource Management and Job Scheduling System at Internet Scale 2014 VLDB 8.9007414e-05
2,531 Multi-Objective Parametric Query Optimization 2015 VLDB 8.3140235e-05
2,572 ResTune: Resource Oriented Tuning Boosted by Meta-Learning for Cloud Databases 2021 SIGMOD 8.2581875e-05
2,584 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2435322e-05
2,892 WiSeDB: A Learning-based Workload Management Advisor for Cloud Databases 2016 VLDB 7.8872299e-05
3,060 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.6828463e-05
3,655 UDO: Universal Database Optimization using Reinforcement Learning 2021 VLDB 7.1137504e-05
3,740 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0398782e-05
3,847 Presto: A Decade of SQL Analytics at Meta 2023 SIGMOD 6.9668258e-05
4,101 Towards Dynamic and Safe Configuration Tuning for Cloud Databases 2022 SIGMOD 6.7930727e-05
4,209 Schedule Optimization for Data Processing Flows on the Cloud 2011 SIGMOD 6.7214185e-05
4,343 Intelligent Scaling in Amazon Redshift 2024 SIGMOD 6.6397106e-05
4,698 LOCAT: Low-Overhead Online Configuration Auto-Tuning of Spark SQL Applications 2022 SIGMOD 6.4476818e-05
4,703 Learned Cardinality Estimation for Similarity Queries 2021 SIGMOD 6.4458272e-05
5,006 An Incremental Anytime Algorithm for Multi-Objective Query Optimization 2015 SIGMOD 6.3057396e-05
5,043 Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing 2022 VLDB 6.28918e-05
5,248 Approximation Schemes for Many-Objective Query Optimization 2014 SIGMOD 6.1980997e-05
5,837 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9600736e-05
6,464 Towards General and Efficient Online Tuning for Spark 2023 VLDB 5.759941e-05
7,387 Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries 2021 SIGMOD 5.5212177e-05
8,675 PostCENN: PostgreSQL with Machine Learning Models for Cardinality Estimation 2021 VLDB 5.2751633e-05
9,219 Tempo: Robust and Self-Tuning Resource Management in Multi-tenant Parallel Databases 2016 VLDB 5.191841e-05
9,863 Trident: Task Scheduling over Tiered Storage Systems in Big Data Platforms 2021 VLDB 5.1063146e-05
9,864 Optimistic Recovery for Iterative Dataflows in Action 2015 SIGMOD 5.1063146e-05
10,127 UDAO: A Next-Generation Unified Data Analytics Optimizer 2019 VLDB 5.0638787e-05
Previous Page 1 / 1 Next

Semantically Similar Papers