DBScholar

Back to papers

Learned Cardinality Estimation: An In-depth Study

Summary: Introduces a taxonomy and unified workflow for learned cardinality estimators, enabling fair, apples-to-apples evaluation of join scenarios. Conducts comprehensive experiments on IMDB and TPC-DS beyond toy datasets, demystifies black-box models, identifies error drivers, and links CE to query optimization, suggesting actionable research directions. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hedfac545e976789d
Venue
SIGMOD
Year
2022
Pagerank
8.6060437e-05
Overall Rank
2,342 | 84.26%
DOI
10.1145/3514221.3526154

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{kim_sigmod22,
        title = {{Learned Cardinality Estimation: An In-depth Study}},
        author = {Kim, Kyoungmin and Jung, Jisung and Seo, In and Han, Wook-Shin and Choi, Kangwoo and Chong, Jaehyok},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526154},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526154},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 31 of 31 citing papers.

Rank Citing Paper Year Venue Pagerank
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4207879e-05
4,202 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7374091e-05
4,683 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4716143e-05
5,219 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.222726e-05
5,481 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.1125124e-05
5,649 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.052326e-05
5,683 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 6.0392183e-05
5,865 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9659203e-05
5,918 Join Size Bounds using l_p-Norms on Degree Sequences 2024 PODS 5.9481539e-05
6,105 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.8860941e-05
6,576 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.7448779e-05
6,818 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.672718e-05
8,352 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3488341e-05
8,800 PACE: Poisoning Attacks on Learned Cardinality Estimation 2024 SIGMOD 5.2742531e-05
9,113 Presto’s History-based Query Optimizer 2024 VLDB 5.2276066e-05
9,372 Efficient and Effective Cardinality Estimation for Skyline Family 2023 SIGMOD 5.1868213e-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,718 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1353964e-05
9,910 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.1103839e-05
10,103 Still Asking: How Good Are Query Optimizers, Really? 2025 VLDB 5.0789354e-05
10,216 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0584922e-05
10,253 BEE: Towards Redundancy Reduction via Block-Separator Decomposition for Subgraph Matching 2026 SIGMOD 5.050482e-05
10,336 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0200193e-05
10,484 NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,627 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 4.9793485e-05
10,673 Qualitative Join Discovery in Data Lakes using Examples 2026 SIGMOD 4.9793485e-05
10,693 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9793485e-05
10,882 Efficient GPU-Accelerated Local Subgraph Counting 2026 VLDB 4.9793485e-05
10,938 Towards Industrial-Scale Parametric Query Optimization 2026 VLDB 4.9793485e-05
11,453 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 21 of 21 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
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021167555
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
461 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017829982
479 The Making of TPC-DS 2006 VLDB 0.00017622471
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014753664
692 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014741011
795 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013938779
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777105
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010180835
1,734 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7545773e-05
2,004 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2065719e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589758e-05
2,908 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.8742664e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,562 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2046519e-05
4,781 Learned Approximate Query Processing: Make it Light, Accurate and Fast 2021 CIDR 6.4162085e-05
5,657 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.0488437e-05
Previous Page 1 / 1 Next

Semantically Similar Papers