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
13223
Venue
VLDB
Year
2023
Pagerank
7.3524442e-05
Overall Rank
3,516 | 75.88%
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 25 of 25 citing papers.

Rank Citing Paper Year Venue Pagerank
5,712 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1123894e-05
6,271 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 5.9326197e-05
6,735 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB 5.7878855e-05
8,163 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4751517e-05
9,377 LeaFi: Data Series Indexes on Steroids with Learned Filters 2025 SIGMOD 5.2755515e-05
9,428 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2709145e-05
9,520 Experimental Analysis of Large-scale Learnable Vector Storage Compression 2024 VLDB 5.2561283e-05
9,556 CAFE: Towards Compact, Adaptive, and Fast Embedding for Large-scale Recommendation Models 2024 SIGMOD 5.2528121e-05
9,601 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.2487799e-05
9,617 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.2434488e-05
9,971 Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement 2025 SIGMOD 5.1845938e-05
10,097 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.1502319e-05
10,108 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.1347137e-05
10,196 Are Learned DBMS Components Robust to Workload Drift?: [Experiments & Analysis] 2026 SIGMOD 5.093636e-05
10,316 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.093636e-05
10,327 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 5.093636e-05
10,401 SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer 2026 SIGMOD 5.093636e-05
10,445 Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload 2026 SIGMOD 5.093636e-05
10,506 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.093636e-05
10,513 LIO: A lightweight and interpretable query optimizer based on an evolutionary forest 2026 VLDB 5.093636e-05
10,881 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 5.093636e-05
11,001 veDB-HTAP: a Highly Integrated, Efficient and Adaptive HTAP System 2025 VLDB 5.093636e-05
11,065 Learned Cost Models for Query Optimization: From Batch to Streaming Systems 2025 VLDB 5.093636e-05
11,083 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.093636e-05
11,091 LEAP: A Low-cost Spark SQL Query Optimizer using Pairwise Comparison 2025 VLDB 5.093636e-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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
43 The Case for Learned Index Structures 2018 SIGMOD 0.00046060254
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
1,241 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011521639
1,402 Creating Embeddings of Heterogeneous Relational Datasets for Data Integration Tasks 2020 SIGMOD 0.00010888094
2,726 TPC-DS, Taking Decision Support Benchmarking to the Next Level 2002 SIGMOD 8.203274e-05
5,148 LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems 2022 SIGMOD 6.3465986e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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