DBScholar

Back to papers

APQO: An Adaptive Framework for Parametric Query Optimization

Summary: APQO: adaptive PQO that models query parameters and plan embeddings to handle variable/dynamic plan caches vs. fixed-plan PQO. Combines an offline pre-trained foundation model, hybrid data augmentation, and lightweight online calibration to adapt to distribution shifts, improving cache-hit rates and reducing query latency. (summarized by gpt-5-mini on Feb 11 2026)

Paper ID
hb83067003ecd68e5
Venue
SIGMOD
Year
2026
Pagerank
5.1325223e-05
Overall Rank
9,725 | 34.64%
DOI
10.1145/3769761

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{li_sigmod26,
        title = {{APQO: An Adaptive Framework for Parametric Query Optimization}},
        author = {Li, Sijia and Cai, Peng and Zhang, Zhifan and Hu, Huiqi and Zhang, Rong and Zhou, Xuan and Xu, Quanqing and Yang, Chuanhui},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3769761},
        url = {https://dl.acm.org/doi/10.1145/3769761},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank Citing Paper Year Venue Pagerank
10,731 Pisco: An Isolation Bug Case Reduction and Deduplication Framework 2026 VLDB 4.9769913e-05
10,937 Real-time SQL Plan Management in Oracle 2026 VLDB 4.9769913e-05
10,947 Towards Industrial-Scale Parametric Query Optimization 2026 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 26 of 26 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.00061067652
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016408613
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
995 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012629969
1,195 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011574218
1,280 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011224914
1,298 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011122244
1,449 Design and Analysis of Parametric Query Optimization Algorithms 1998 VLDB 0.00010616486
1,612 AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions 2003 VLDB 0.00010068388
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,813 OceanBase: A 707 Million tpmC Distributed Relational Database System 2022 VLDB 7.9773891e-05
2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.9495917e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8716173e-05
3,396 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3386533e-05
3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2283486e-05
3,979 Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021 SIGMOD 6.8791817e-05
4,191 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7425275e-05
4,659 On the Production of Anorexic Plan Diagrams 2007 VLDB 6.4794607e-05
5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2995365e-05
5,081 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2830143e-05
6,636 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB 5.7243042e-05
8,393 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.3387995e-05
9,134 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2223611e-05
11,459 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,298 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB
2 1,612 AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions 2003 VLDB
3 4,191 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD
4 5,081 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD
5 8,393 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB
6 9,735 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB
7 11,459 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB
8 10,703 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD
9 10,947 Towards Industrial-Scale Parametric Query Optimization 2026 VLDB
10 5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB