Database Paper Browser

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
13036
Venue
VLDB
Year
2023
Pagerank
6.1552798e-05
Overall Rank
4,464 | 68.98%
DOI
10.14778/3587136.3587150

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 24 of 24 citing papers.

Rank Citing Paper Year Venue Pagerank
6,382 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 5.0835686e-05
6,862 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB 4.9004921e-05
7,009 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8597992e-05
8,660 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 4.4680058e-05
9,233 LeaFi: Data Series Indexes on Steroids with Learned Filters 2025 SIGMOD 4.3648789e-05
9,350 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 4.3494621e-05
9,408 CAFE: Towards Compact, Adaptive, and Fast Embedding for Large-scale Recommendation Models 2024 SIGMOD 4.3399748e-05
9,414 Experimental Analysis of Large-scale Learnable Vector Storage Compression 2024 VLDB 4.3399748e-05
9,581 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 4.3186744e-05
9,824 Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement 2025 SIGMOD 4.2710095e-05
9,947 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 4.2391999e-05
9,959 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 4.2254157e-05
10,018 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 4.1905499e-05
10,032 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.1905499e-05
10,096 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 4.1905499e-05
10,112 SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer 2026 SIGMOD 4.1905499e-05
10,156 Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload 2026 SIGMOD 4.1905499e-05
10,217 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 4.1905499e-05
10,225 LIO: A lightweight and interpretable query optimizer based on an evolutionary forest 2026 VLDB 4.1905499e-05
10,635 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.1905499e-05
10,778 veDB-HTAP: a Highly Integrated, Efficient and Adaptive HTAP System 2025 VLDB 4.1905499e-05
10,844 Learned Cost Models for Query Optimization: From Batch to Streaming Systems 2025 VLDB 4.1905499e-05
10,863 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 4.1905499e-05
10,872 LEAP: A Low-cost Spark SQL Query Optimizer using Pairwise Comparison 2025 VLDB 4.1905499e-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
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059446482
101 The Case for Learned Index Structures 2018 SIGMOD 0.00049778866
329 Neo: A Learned Query Optimizer 2019 VLDB 0.00027301488
634 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00018844568
779 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00016719473
804 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001643674
1,914 Creating Embeddings of Heterogeneous Relational Datasets for Data Integration Tasks 2020 SIGMOD 0.00010111859
2,090 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 9.5668285e-05
3,236 TPC-DS, Taking Decision Support Benchmarking to the Next Level 2002 SIGMOD 7.3294564e-05
5,682 LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems 2022 SIGMOD 5.3752251e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
10,863 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 4.1905499e-05
10,635 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.1905499e-05
10,018 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 4.1905499e-05
5,289 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 5.5790771e-05
6,862 Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges 2023 VLDB 4.9004921e-05
8,479 Can Large Language Models Be Query Optimizer for Relational Databases? 2026 SIGMOD 4.4967983e-05
3,345 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 7.1908499e-05
3,658 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 6.8700949e-05
5,941 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 5.2594013e-05
7,009 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8597992e-05