DBScholar

Back to papers

Selectivity Estimation Without the Attribute Value Independence Assumption

Summary: Selectivity estimation without attribute independence: joint frequencies drive results; per-attribute histograms are inaccurate. Proposes two options: (a) multi-d histogram, (b) SVD-based joint modeling; experiments compare accuracy vs independence. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h8b13ee03e0598ebb
Venue
VLDB
Year
1997
Pagerank
0.00033894985
Overall Rank
103 | 99.31%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{poosala_vldb97,
        title = {{Selectivity Estimation Without the Attribute Value Independence Assumption}},
        author = {Poosala, Viswanath and Ioannidis, Yannis E.},
        journal = {PVLDB},
        series = {{VLDB} '97},
        volume = {23},
        pages = {486--495},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 80 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024218831
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022509573
275 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022413521
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.0002211981
309 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021384073
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019829769
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00018129161
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017962189
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016245271
643 Evaluating Top-k Selection Queries 1999 VLDB 0.00015217076
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001520859
692 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014741011
701 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014680907
742 Dynamic Multidimensional Histograms 2002 SIGMOD 0.0001431602
955 Flexible Database Generators 2005 VLDB 0.00012866364
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,004 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012594522
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,077 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012154948
1,257 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011310561
1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010440205
1,574 Reducing the Braking Distance of an SQL Query Engine 1998 VLDB 0.00010194928
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010180835
1,607 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.0001008742
1,662 BHUNT: Automatic Discovery of Fuzzy Algebraic Constraints in Relational Data 2003 VLDB 9.9465656e-05
1,687 Global Optimization of Histograms 2001 SIGMOD 9.8655879e-05
1,734 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7545773e-05
1,891 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4184294e-05
1,960 StatiX: Making XML Count 2002 SIGMOD 9.3125715e-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,162 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.935022e-05
2,198 Integrating the UB-Tree into a Database System Kernel 2000 VLDB 8.8759215e-05
2,368 Statistical Synopses for Graph-Structured XML Databases 2002 SIGMOD 8.5622073e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
2,974 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.7938744e-05
3,092 Compressing Historical Information in Sensor Networks 2004 SIGMOD 7.6563998e-05
3,184 Structure and Value Synopses for XML Data Graphs 2002 VLDB 7.5577589e-05
3,281 Kernel-Based Skyline Cardinality Estimation 2009 SIGMOD 7.4583561e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-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
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 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
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047863192
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036487763
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003137356
283 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022214789
335 Hilbert R-tree: An Improved R-tree Using Fractals 1994 VLDB 0.00020660268
364 Linear Clustering of Objects with Multiple Attributes 1990 SIGMOD 0.00019976696
806 Universality of Serial Histograms 1993 VLDB 0.00013792174
1,184 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011611937
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD
2 1,060 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB
3 1,929 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB
4 1,077 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD
5 169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
6 4,933 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD
7 286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
8 701 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD
9 1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
10 9,976 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD