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.3413016e-05
Overall Rank
8,389 | 43.60%
DOI
10.14778/3704965.3704971

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.00061066921
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
362 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019989474
479 The Making of TPC-DS 2006 VLDB 0.00017622471
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016245271
836 Proactive Re-Optimization 2005 SIGMOD 0.00013557047
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
996 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012634603
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,122 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.0001193884
1,298 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011120288
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010417728
1,603 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 0.00010097649
1,789 Plan Selection based on Query Clustering 2002 VLDB 9.6293635e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.250242e-05
2,538 Applying the Golden Rule of Sampling for Query Estimation 2001 SIGMOD 8.3284106e-05
3,367 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719456e-05
3,396 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3418098e-05
3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2310714e-05
4,202 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7374091e-05
4,657 On the Production of Anorexic Plan Diagrams 2007 VLDB 6.4824233e-05
4,855 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 6.3799739e-05
5,022 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3100988e-05
5,039 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.3023214e-05
5,078 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2857912e-05
5,988 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.9257426e-05
6,003 MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education 2022 VLDB 5.9172558e-05
6,110 On the Complexity of Generating Optimal Plans with Cross Products (extended abstract) 1997 PODS 5.8843027e-05
6,113 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.8823242e-05
6,393 QUEST: An Exploratory Approach to Robust Query Processing 2014 VLDB 5.8002013e-05
6,791 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6811782e-05
7,332 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 5.5499953e-05
7,597 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.4872821e-05
7,954 Robust Query Processing: Mission Possible 2020 VLDB 5.4190023e-05
8,159 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 5.3873068e-05
9,632 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.1472849e-05
Previous Page 1 / 1 Next

Semantically Similar Papers