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.7912743e-05
Overall Rank
2,228 | 85.07%
DOI
10.14778/3137765.3137767
PDF
Download (CC BY-NC-ND 4.0)

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
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
2,584 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2435322e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
3,060 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.6828463e-05
3,105 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.6278115e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
3,740 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0398782e-05
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
4,479 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5665703e-05
5,029 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.2952031e-05
7,122 Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs 2023 SIGMOD 5.580601e-05
7,446 Learning to be a Statistician: Learned Estimator for Number of Distinct Values 2022 VLDB 5.5113049e-05
7,975 Robust Query Processing: Mission Possible 2020 VLDB 5.3985544e-05
10,014 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.0838565e-05
10,257 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.039379e-05
10,355 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0156513e-05
11,321 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9605343e-05
11,564 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 4.9605343e-05
11,591 Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality 2024 SIGMOD 4.9605343e-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.0023948467
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
57 On Random Sampling over Joins 1999 SIGMOD 0.0003999751
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027775994
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
372 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019768921
381 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019497061
432 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018400309
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
689 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014725904
750 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014246313
752 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014234789
850 Hardware-Oblivious Parallelism for In-Memory Column-Stores 2013 VLDB 0.00013450864
996 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012595827
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,469 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010533259
1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010408003
2,438 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4532693e-05
2,606 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2118469e-05
4,981 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3161219e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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