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
h59bad86d8e781ff0
Venue
SIGMOD
Year
1996
Pagerank
0.00047654188
Overall Rank
37 | 99.76%
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 50 of 112 citing papers.

Rank Citing Paper Year Venue Pagerank
82 Space-Efficient Online Computation of Quantile Summaries 2001 SIGMOD 0.00036097627
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033847446
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029532435
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028910892
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.0002855087
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024136952
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023327437
252 Approximate Medians and other Quantiles in One Pass and with Limited Memory 1998 SIGMOD 0.00023058622
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
268 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022654182
277 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002235043
296 Towards Estimation Error Guarantees for Distinct Values 2000 PODS 0.00021874894
311 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021315058
337 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020593498
372 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019768921
374 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019698889
381 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019497061
397 Worst-case Optimal Join Algorithms 2012 PODS 0.0001911958
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
442 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00018182341
450 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.0001806593
457 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017915659
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
518 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00016918797
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016251304
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015166402
647 Evaluating Top-k Selection Queries 1999 VLDB 0.00015165562
701 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.0001464136
745 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014267268
785 A One-Pass Algorithm for Accurately Estimating Quantiles for Disk-Resident Data 1997 VLDB 0.0001399349
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
1,006 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012551491
1,044 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.0001232071
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,080 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012114187
1,124 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00011898749
1,466 Substring Selectivity Estimation 1999 PODS 0.00010546176
1,569 Reducing the Braking Distance of an SQL Query Engine 1998 VLDB 0.00010177494
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,693 Global Optimization of Histograms 2001 SIGMOD 9.8377504e-05
1,754 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7111856e-05
1,828 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 9.5396315e-05
1,935 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3407959e-05
1,969 StatiX: Making XML Count 2002 SIGMOD 9.2805411e-05
2,154 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9382906e-05
2,176 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9031141e-05
Previous Page 1 / 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.0023948467
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047770864
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036394222
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031291457
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
470 Optimization of Large Join Queries 1988 SIGMOD 0.00017699145
489 Randomized Algorithms For Optimizing Large Join Queries 1990 SIGMOD 0.00017402488
806 Universality of Serial Histograms 1993 VLDB 0.00013752086
1,187 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011580993
Previous Page 1 / 1 Next

Semantically Similar Papers

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