DBScholar

Back to papers

Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models

Summary: Bandwidth-optimized KDE for join selectivity; builds from join-result samples and combines base-table KDEs for single- and multi-join cardinalities. Outperforms sketching and sampling baselines on synthetic and real data with GPU-efficient evaluation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h03040697000903ac
Venue
VLDB
Year
2017
Pagerank
8.8177753e-05
Overall Rank
2,216 | 85.11%
DOI
10.14778/3137765.3137767

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{kiefer_vldb17,
        title = {{Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models}},
        author = {Kiefer, Martin and Heimel, Max and Breß, Sebastian and Markl, Volker},
        journal = {PVLDB},
        series = {{VLDB} '17},
        volume = {10},
        number = {13},
        pages = {2085--2096},
        doi = {10.14778/3137765.3137767},
        url = {https://doi.org/10.14778/3137765.3137767},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank Citing Paper Year Venue Pagerank
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
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,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589758e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,160 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.5807496e-05
3,562 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2046519e-05
3,741 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0594076e-05
4,311 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6727978e-05
4,457 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5913732e-05
5,003 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.3188773e-05
7,097 Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs 2023 SIGMOD 5.601767e-05
7,429 Learning to be a Statistician: Learned Estimator for Number of Distinct Values 2022 VLDB 5.5300853e-05
7,954 Robust Query Processing: Mission Possible 2020 VLDB 5.4190023e-05
9,976 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.1031384e-05
10,216 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0584922e-05
10,322 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0346745e-05
11,257 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9793485e-05
11,507 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 4.9793485e-05
11,536 Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality 2024 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 22 of 22 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023947656
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
57 On Random Sampling over Joins 1999 SIGMOD 0.00040108301
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.0003475226
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027837289
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.0002211981
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019829769
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019444411
428 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.0001845349
481 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017603972
688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014753664
745 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014288286
750 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014265196
856 Hardware-Oblivious Parallelism for In-Memory Column-Stores 2013 VLDB 0.00013428547
996 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012634603
1,060 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224575
1,467 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010567959
1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010440205
2,433 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4766785e-05
2,600 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2363864e-05
4,958 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3394776e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,542 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
2 3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
3 1,465 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD
4 1,678 Two-Level Sampling for Join Size Estimation 2017 SIGMOD
5 688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR
6 2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD
7 4,933 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD
8 1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
9 286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
10 1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD