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
13896
Venue
VLDB
Year
2024
Pagerank
5.4568571e-05
Overall Rank
8,305 | 43.03%
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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
476 The Making of TPC-DS 2006 VLDB 0.00017860667
566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016436005
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
984 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012825643
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,104 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00012157634
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,321 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011162369
1,712 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 9.9492299e-05
1,771 Plan Selection based on Query Clustering 2002 VLDB 9.7942089e-05
1,832 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 9.6607418e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.3517129e-05
2,493 Applying the Golden Rule of Sampling for Query Estimation 2001 SIGMOD 8.5070756e-05
3,426 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.4218997e-05
3,506 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.3581509e-05
3,513 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.354613e-05
4,470 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.6817353e-05
4,616 On the Production of Anorexic Plan Diagrams 2007 VLDB 6.6048588e-05
4,817 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 6.4944225e-05
5,010 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.4023732e-05
5,281 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2842378e-05
5,394 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2336084e-05
5,881 MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education 2022 VLDB 6.0529753e-05
5,898 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 6.0471908e-05
6,019 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 6.0060149e-05
6,164 On the Complexity of Generating Optimal Plans with Cross Products (extended abstract) 1997 PODS 5.9532278e-05
6,316 QUEST: An Exploratory Approach to Robust Query Processing 2014 VLDB 5.9151861e-05
7,193 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6770249e-05
7,206 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 5.6731116e-05
7,495 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.6041473e-05
7,829 Robust Query Processing: Mission Possible 2020 VLDB 5.5360082e-05
8,004 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 5.5082745e-05
9,455 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.2653318e-05
Previous Page 1 / 1 Next

Semantically Similar Papers