DBScholar

Back to papers

Selectivity Estimation using Probabilistic Models

Summary: Probabilistic Relational Models (PRMs) model attribute distributions across tables and joins to estimate selectivity. Efficient DB-driven construction enables a unified select-join framework, delivering accurate, compact estimates for broad query families. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hae1a3404c9d5c6c7
Venue
SIGMOD
Year
2001
Pagerank
0.0002211981
Overall Rank
286 | 98.08%
DOI
10.1145/375663.375727

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{getoor_sigmod01,
        title = {{Selectivity Estimation using Probabilistic Models}},
        author = {Getoor, Lise and Taskar, Ben and Koller, Daphne},
        series = {{SIGMOD} '01},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/375663.375727},
        url = {https://dl.acm.org/doi/10.1145/375663.375727},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 58 citing papers.

Rank Citing Paper Year Venue Pagerank
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027837289
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021167555
343 Model-Driven Data Acquisition in Sensor Networks 2004 VLDB 0.00020519525
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
518 Query by Output 2009 SIGMOD 0.00016944862
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016245271
692 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014741011
822 On Schema Matching with Opaque Column Names and Data Values 2003 SIGMOD 0.00013651306
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,060 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224575
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,109 A Formal Analysis of Information Disclosure in Data Exchange 2004 SIGMOD 0.00011987291
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777105
1,164 A Case for A Collaborative Query Management System 2009 CIDR 0.00011745383
1,257 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011310561
1,454 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.00010601431
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
1,785 Approximate Lineage for Probabilistic Databases 2008 VLDB 9.6482655e-05
1,929 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3546057e-05
2,004 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2065719e-05
2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9682092e-05
2,216 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8177753e-05
2,291 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.6872323e-05
2,413 Data Generation using Declarative Constraints 2011 SIGMOD 8.5094338e-05
2,415 Using Probabilistic Models for Data Management in Acquisitional Environments 2005 CIDR 8.4985276e-05
2,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
2,974 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.7938744e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4207879e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-05
3,562 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2046519e-05
3,851 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 6.9785886e-05
4,106 Content-Based Routing: Different Plans for Different Data 2005 VLDB 6.8032891e-05
4,253 Sample Debiasing in the Themis Open World Database System 2020 SIGMOD 6.7015395e-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
4,563 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5320994e-05
5,209 SAM: Database Generation from Query Workloads with Supervised Autoregressive Models 2022 SIGMOD 6.2262056e-05
5,840 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737703e-05
5,973 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.9306716e-05
6,469 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.7743636e-05
6,791 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6811782e-05
6,846 Capturing Data Uncertainty in High-Volume Stream Processing 2009 CIDR 5.6662335e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank Cited Paper Year Venue Pagerank
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036487763
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033894985
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003137356
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029627449
169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027134723
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024218831
309 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021384073
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,203 Fixed-Precision Estimation of Join Selectivity 1993 PODS
2 3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
3 51 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB
4 1,542 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
5 2,216 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB
6 956 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
7 79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD
8 3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB
9 1,060 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB
10 1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD