DBScholar

Back to papers

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)

Paper ID
h096f91a68f3555ac
Venue
VLDB
Year
2023
Pagerank
7.263041e-05
Overall Rank
3,487 | 76.56%
DOI
10.14778/3587136.3587150

Incoming Non-self Citations Over Time

Authors

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.

Rank Citing Paper Year Venue Pagerank
5,649 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.052326e-05
6,308 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 5.8177833e-05
6,632 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB 5.7270153e-05
8,332 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.3528188e-05
9,300 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.1987909e-05
9,546 Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement 2025 SIGMOD 5.1604755e-05
9,563 LeaFi: Data Series Indexes on Steroids with Learned Filters 2025 SIGMOD 5.1571823e-05
9,610 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.1526493e-05
9,670 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1452097e-05
9,700 Experimental Analysis of Large-scale Learnable Vector Storage Compression 2024 VLDB 5.1381949e-05
9,734 CAFE: Towards Compact, Adaptive, and Fast Embedding for Large-scale Recommendation Models 2024 SIGMOD 5.1349531e-05
9,797 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.1257999e-05
9,956 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1038322e-05
10,290 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.0431863e-05
10,310 veDB-HTAP: a Highly Integrated, Efficient and Adaptive HTAP System 2025 VLDB 5.0386264e-05
10,322 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0346745e-05
10,336 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0200193e-05
10,412 Are Learned DBMS Components Robust to Workload Drift?: [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,532 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.9793485e-05
10,596 SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer 2026 SIGMOD 4.9793485e-05
10,633 Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload 2026 SIGMOD 4.9793485e-05
10,698 LIO: A lightweight and interpretable query optimizer based on an evolutionary forest 2026 VLDB 4.9793485e-05
10,941 Ultron: History-Based Query Optimization at Databricks 2026 VLDB 4.9793485e-05
11,283 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.9793485e-05
11,425 Learned Cost Models for Query Optimization: From Batch to Streaming Systems 2025 VLDB 4.9793485e-05
11,443 LEAP: A Low-cost Spark SQL Query Optimizer using Pairwise Comparison 2025 VLDB 4.9793485e-05
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.00061066921
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046284649
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
362 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019989474
437 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00018315867
461 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017829982
1,199 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011563985
1,391 Creating Embeddings of Heterogeneous Relational Datasets for Data Integration Tasks 2020 SIGMOD 0.00010816237
2,719 TPC-DS, Taking Decision Support Benchmarking to the Next Level 2002 SIGMOD 8.0967665e-05
5,041 LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems 2022 SIGMOD 6.3006152e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 11,283 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB
2 9,956 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB
3 9,300 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD
4 4,482 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD
5 6,632 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB
6 6,586 Can Large Language Models Be Query Optimizer for Relational Databases? 2026 SIGMOD
7 2,210 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB
8 3,060 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR
9 5,456 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB
10 6,308 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB