DBScholar

Back to papers

Improved Histograms for Selectivity Estimation of Range Predicates

Summary: Proposes a systematic taxonomy of histograms for range-predicate selectivity estimation, unifying prior types and enabling novel design combinations. Demonstrates sampling to reduce histogram construction cost and empirically evaluates types on range queries to identify the best performers. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
2954
Venue
SIGMOD
Year
1996
Pagerank
0.00048481081
Overall Rank
35 | 99.77%
DOI
10.1145/233269.233342

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{poosala_sigmod96,
        title = {{Improved Histograms for Selectivity Estimation of Range Predicates}},
        author = {Poosala, Viswanath and Ioannidis, Yannis E. and Haas, Peter J. and Shekita, Eugene J.},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233342},
        url = {https://dl.acm.org/doi/10.1145/233269.233342},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 112 citing papers.

Rank Citing Paper Year Venue Pagerank
8,998 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD 5.3355988e-05
9,209 Optimality and Scalability in Lattice Histogram Construction 2009 VLDB 5.3058708e-05
9,515 Analyzing Quantitative Databases: Image is Everything 2001 VLDB 5.2567112e-05
9,793 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.2193018e-05
9,867 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 5.2043672e-05
10,206 Bridging the Gap: Cardinality Estimation for Semantic Queries on Unstructured Data 2026 SIGMOD 5.093636e-05
10,515 Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries 2026 VLDB 5.093636e-05
11,625 Accelerating Complex Analytics using Speculation 2021 CIDR 5.093636e-05
11,700 In the Land of Data Streams where Synopses are Missing, One Framework to Bring Them All 2021 VLDB 5.093636e-05
12,024 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 5.093636e-05
12,258 Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects 2013 VLDB 5.093636e-05
12,613 Community-Driven Data Grids 2008 VLDB 5.093636e-05
Previous Page 3 / 3 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 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.0024089429
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00048351457
75 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00037277061
76 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00037054261
89 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00035031529
118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031922279
222 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00024193708
274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022645621
463 Optimization of Large Join Queries 1988 SIGMOD 0.00018064961
479 Randomized Algorithms For Optimizing Large Join Queries 1990 SIGMOD 0.00017789732
786 Universality of Serial Histograms 1993 VLDB 0.00014053885
1,172 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011825923
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 168 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
2 267 Optimal Histograms with Quality Guarantees 1998 VLDB
3 1,536 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
4 786 Universality of Serial Histograms 1993 VLDB
5 235 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB
6 3,241 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS
7 4,846 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD
8 934 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
9 118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD
10 274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD