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.8151982e-05
Overall Rank
2,217 | 85.11%
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
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019050182
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
1,065 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202293
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010177136
1,735 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7566604e-05
2,002 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2076835e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589842e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
3,053 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7041081e-05
3,161 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.5771609e-05
3,563 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2023194e-05
3,742 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0564546e-05
4,299 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6766173e-05
4,459 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5883555e-05
5,006 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.3159614e-05
7,099 Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs 2023 SIGMOD 5.5991152e-05
7,426 Learning to be a Statistician: Learned Estimator for Number of Distinct Values 2022 VLDB 5.5295692e-05
7,958 Robust Query Processing: Mission Possible 2020 VLDB 5.4164639e-05
9,983 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.1007226e-05
10,222 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0560976e-05
10,329 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0322912e-05
11,265 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9769913e-05
11,513 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 4.9769913e-05
11,542 Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality 2024 SIGMOD 4.9769913e-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.0023943337
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
57 On Random Sampling over Joins 1999 SIGMOD 0.00040095727
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034748721
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034099838
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027827605
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022112534
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019822444
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
429 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018445263
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017744392
688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014749318
746 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014282427
749 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014261044
857 Hardware-Oblivious Parallelism for In-Memory Column-Stores 2013 VLDB 0.00013422539
995 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00012629969
1,058 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224038
1,467 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010563809
1,509 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010436933
2,432 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4742372e-05
2,601 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2325291e-05
4,960 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3365273e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,543 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,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD
7 4,936 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,509 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD