DBScholar

Back to papers

PARQO: Penalty-Aware Robust Plan Selection in Query Optimization

Summary: PARQO lets DBAs specify penalty-based robustness metrics to evaluate a plan's expected loss versus the true optimum under selectivity uncertainty. It builds workload-informed selectivity error models and uses sensitivity analysis to surface interpretable selectivity dimensions and choose robust, parametric plans. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h762208e1e91b98c8
Venue
VLDB
Year
2024
Pagerank
5.3211467e-05
Overall Rank
8,412 | 43.62%
DOI
10.14778/3704965.3704971
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{xiu_vldb24,
        title = {{PARQO: Penalty-Aware Robust Plan Selection in Query Optimization}},
        author = {Xiu, Haibo and Agarwal, Pankaj K. and Yang, Jun},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {13},
        pages = {4627--4640},
        doi = {10.14778/3704965.3704971},
        url = {https://doi.org/10.14778/3704965.3704971},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 36 of 36 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
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
473 The Making of TPC-DS 2006 VLDB 0.00017656775
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
996 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012595827
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,124 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00011898749
1,304 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011088983
1,513 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010394557
1,609 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 0.0001007196
1,799 Plan Selection based on Query Clustering 2002 VLDB 9.6001575e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.2323722e-05
2,544 Applying the Golden Rule of Sampling for Query Estimation 2001 SIGMOD 8.2988657e-05
3,361 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3621595e-05
3,406 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3151509e-05
3,531 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2065332e-05
4,202 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7258607e-05
4,674 On the Production of Anorexic Plan Diagrams 2007 VLDB 6.4584193e-05
4,876 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 6.357646e-05
5,044 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.2888728e-05
5,062 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2791511e-05
5,101 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2623728e-05
5,999 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.9034324e-05
6,016 MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education 2022 VLDB 5.8948982e-05
6,125 On the Complexity of Generating Optimal Plans with Cross Products (extended abstract) 1997 PODS 5.862077e-05
6,128 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.860258e-05
6,405 QUEST: An Exploratory Approach to Robust Query Processing 2014 VLDB 5.7791099e-05
6,812 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6597129e-05
7,355 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 5.529034e-05
7,619 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.4665491e-05
7,975 Robust Query Processing: Mission Possible 2020 VLDB 5.3985544e-05
8,182 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 5.3669522e-05
9,667 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.1278365e-05
Previous Page 1 / 1 Next

Semantically Similar Papers