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
6527
Venue
SIGMOD
Year
2022
Pagerank
8.4445934e-05
Overall Rank
2,543 | 82.56%
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 29 of 29 citing papers.

Rank Citing Paper Year Venue Pagerank
3,338 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.5068221e-05
4,470 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.6817353e-05
4,929 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4423294e-05
5,576 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.1663946e-05
5,712 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1123894e-05
5,767 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0945741e-05
6,088 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 5.9813965e-05
6,257 Join Size Bounds using l_p-Norms on Degree Sequences 2024 PODS 5.9397944e-05
6,323 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9141228e-05
6,327 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.9124005e-05
6,704 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.797374e-05
8,193 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.4696038e-05
8,448 Towards Query Optimizer as a Service (QOaaS) in a Unified LakeHouse Ecosystem: Can One QO Rule Them All? 2025 CIDR 5.4235725e-05
8,643 PACE: Poisoning Attacks on Learned Cardinality Estimation 2024 SIGMOD 5.3940849e-05
9,192 Efficient and Effective Cardinality Estimation for Skyline Family 2023 SIGMOD 5.3058708e-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,920 Still Asking: How Good Are Query Optimizers, Really? 2025 VLDB 5.1955087e-05
9,958 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1879626e-05
10,028 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.1745962e-05
10,108 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.1347137e-05
10,272 NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis] 2026 SIGMOD 5.093636e-05
10,312 BEE: Towards Redundancy Reduction via Block-Separator Decomposition for Subgraph Matching 2026 SIGMOD 5.093636e-05
10,438 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 5.093636e-05
10,486 Qualitative Join Discovery in Data Lakes using Examples 2026 SIGMOD 5.093636e-05
10,508 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 5.093636e-05
11,059 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.093636e-05
11,103 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB 5.093636e-05
11,290 Presto’s History-based Query Optimizer 2024 VLDB 5.093636e-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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
401 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019092557
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
476 The Making of TPC-DS 2006 VLDB 0.00017860667
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
694 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014911698
697 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014888851
802 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013907725
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,170 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011827259
1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010328171
1,876 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.5717543e-05
1,988 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.3501502e-05
2,620 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.3363963e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7708642e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
4,789 Learned Approximate Query Processing: Make it Light, Accurate and Fast 2021 CIDR 6.5072039e-05
5,551 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.1782856e-05
Previous Page 1 / 1 Next

Semantically Similar Papers