DBScholar

Back to papers

PAR2QO: Parametric Penalty-Aware Robust Query Optimization

Summary: PAR2QO: probe workload-informed selectivities, cache plan–penalty profiles, pick runtime plans minimizing expected penalty under selectivity uncertainty. Adds CARVER, a subquery-cardinality-aware generator for better PQO evaluation/training; yields substantial speedups and improved robustness. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
14253
Venue
VLDB
Year
2025
Pagerank
5.093636e-05
Overall Rank
10,986 | 24.63%
DOI
10.14778/3749646.3749711

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@article{xiu_vldb25,
        title = {{PAR2QO: Parametric Penalty-Aware Robust Query Optimization}},
        author = {Xiu, Haibo and Li, Yang and Yang, Qianyu and Agarwal, Pankaj K. and Yang, Jun},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {11},
        pages = {4532--4545},
        doi = {10.14778/3749646.3749711},
        url = {https://doi.org/10.14778/3749646.3749711},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank Citing Paper Year Venue Pagerank
10,151 Coresets for Robust Query Optimization 2026 PODS 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 34 of 34 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
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
411 Worst-case Optimal Join Algorithms 2012 PODS 0.00018902089
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
770 Parametric Query Optimization 1992 VLDB 0.00014166811
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
984 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012825643
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,795 Least Expected Cost Query Optimization: What Can We Expect? 2002 PODS 9.738718e-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
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,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,770 Closing The Query Processing Loop in Oracle 11g 2008 VLDB 6.0934173e-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,316 QUEST: An Exploratory Approach to Robust Query Processing 2014 VLDB 5.9151861e-05
6,760 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.7826781e-05
7,193 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6770249e-05
7,495 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.6041473e-05
8,004 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 5.5082745e-05
8,305 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.4568571e-05
9,796 ROME: Robust Query Optimization via Parallel Multi-Plan Execution 2024 SIGMOD 5.21848e-05
11,035 Hint-QPT: Hints for Robust Query Performance Tuning 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Semantically Similar Papers