LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans
Summary: LOGER models table/predicate relations with a Graph Transformer and predicts operator-restriction masks (not per-join operator picks), delegating physical operator choice to the DBMS for robustness. With epsilon-beam search and reward-weighted, log-transformed loss to stabilize DRL, LOGER yields superior plans (2.07× on JOB vs PostgreSQL). (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Tianyi Chen (Peking University)
- 2. Jun Gao (Peking University)
- 3. Hedui Chen (ZTE Corporation)
- 4. Yaofeng Tu (ZTE Corporation)
BibTeX Citation
@article{chen_vldb23,
title = {{LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans}},
author = {Chen, Tianyi and Gao, Jun and Chen, Hedui and Tu, Yaofeng},
journal = {PVLDB},
series = {{VLDB} '23},
volume = {16},
number = {7},
pages = {1777--1789},
doi = {10.14778/3587136.3587150},
url = {https://doi.org/10.14778/3587136.3587150},
year = {2023}
}Incoming Citations (Sorted by Pagerank)
Showing 26 of 26 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 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 |
| 40 | The Case for Learned Index Structures | 2018 | SIGMOD | 0.00046363107 |
| 144 | Neo: A Learned Query Optimizer | 2019 | VLDB | 0.00029090793 |
| 361 | Bao: Making Learned Query Optimization Practical | 2021 | SIGMOD | 0.00020000855 |
| 437 | QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning | 2019 | VLDB | 0.00018310278 |
| 462 | An End-to-End Learning-based Cost Estimator | 2020 | VLDB | 0.00017836105 |
| 1,195 | Balsa: Learning a Query Optimizer Without Expert Demonstrations | 2022 | SIGMOD | 0.00011574218 |
| 1,391 | Creating Embeddings of Heterogeneous Relational Datasets for Data Integration Tasks | 2020 | SIGMOD | 0.00010812249 |
| 2,720 | TPC-DS, Taking Decision Support Benchmarking to the Next Level | 2002 | SIGMOD | 8.0936194e-05 |
| 5,043 | LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems | 2022 | SIGMOD | 6.2979214e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 11,291 | Robust Plan Evaluation based on Approximate Probabilistic Machine Learning | 2025 | VLDB |
| 2 | 9,962 | Graph Transformers for Query Plan Representation: Potentials and Challenges | 2025 | VLDB |
| 3 | 8,373 | GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints | 2026 | SIGMOD |
| 4 | 4,485 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD |
| 5 | 6,636 | Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges | 2023 | VLDB |
| 6 | 6,575 | Can Large Language Models Be Query Optimizer for Relational Databases? | 2026 | SIGMOD |
| 7 | 2,209 | Lero: A Learning-to-Rank Query Optimizer | 2023 | VLDB |
| 8 | 3,057 | Towards a Hands-Free Query Optimizer through Deep Learning | 2019 | CIDR |
| 9 | 5,438 | Eraser: Eliminating Performance Regression on Learned Query Optimizer | 2024 | VLDB |
| 10 | 6,298 | Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective | 2024 | VLDB |