DBScholar

Back to papers

The History of Histograms (abridged)

Summary: A deliberately compressed, personally biased history of histograms, spanning scientific origins, approximation/compression, industrial adoption, and database problems. Treats the historical narrative itself as a histogram, preserving high-interest events under a fixed space budget and evaluating semantic fidelity. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h6cdc112dd76a9bd6
Venue
VLDB
Year
2003
Pagerank
0.00022974524
Overall Rank
255 | 98.29%
DOI
10.1016/B978-012722442-8/50011-2

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{ioannidis_vldb03,
        title = {{The History of Histograms (abridged)}},
        author = {Ioannidis, Yannis},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50011-2},
        url = {https://doi.org/10.1016/B978-012722442-8/50011-2},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 51 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
311 Order Preserving Encryption for Numeric Data 2004 SIGMOD 0.00021317851
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
402 Worst-case Optimal Join Algorithms 2012 PODS 0.00019095982
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016244162
707 On Synopses for Distinct-Value Estimation Under Multiset Operations 2007 SIGMOD 0.00014633741
888 Pay-as-you-go User Feedback for Dataspace Systems 2008 SIGMOD 0.00013250185
1,058 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224038
1,117 Adaptive Range Filters for Cold Data: Avoiding Trips to Siberia 2013 VLDB 0.00011952597
1,258 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011308863
1,509 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010436933
1,535 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010326646
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010177136
1,893 Generating Targeted Queries for Database Testing 2008 SIGMOD 9.4149369e-05
2,008 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.1956849e-05
2,157 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9425625e-05
2,294 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.6831732e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,728 Weighted Hypertree Decompositions and Optimal Query Plans 2004 PODS 8.08577e-05
2,787 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 8.0121053e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
2,890 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9010819e-05
3,092 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6548729e-05
3,362 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719912e-05
3,563 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2023194e-05
4,463 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.5861255e-05
5,581 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0741907e-05
5,816 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 5.9817821e-05
5,835 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737602e-05
5,974 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.9279222e-05
6,488 Approximate Summaries for Why and Why-not Provenance 2020 VLDB 5.7659318e-05
6,643 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7233159e-05
6,889 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.6536655e-05
7,518 Computing A Well-Representative Summary of Conjunctive Query Results 2024 PODS 5.5023404e-05
8,193 Probabilistic Histograms for Probabilistic Data 2009 VLDB 5.3789502e-05
8,279 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.3617864e-05
8,282 Consistent and Flexible Selectivity Estimation for High-Dimensional Data 2021 SIGMOD 5.3616162e-05
8,583 Histograms as a Side Effect of Data Movement for Big Data 2014 SIGMOD 5.3086664e-05
9,122 Presto’s History-based Query Optimizer 2024 VLDB 5.2251319e-05
9,396 Optimality and Scalability in Lattice Histogram Construction 2009 VLDB 5.1843659e-05
9,578 Determining Exact Quantiles with Randomized Summaries 2024 SIGMOD 5.154741e-05
9,640 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.1448486e-05
9,917 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.1079647e-05
10,212 Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections 2022 VLDB 5.0579923e-05
10,918 Incremental Query Optimizer Statistics in Amazon Redshift 2026 VLDB 4.9769913e-05
11,265 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9769913e-05
11,298 Cardinality Estimation for Having-Clauses 2025 VLDB 4.9769913e-05
12,325 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.9769913e-05
12,555 Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects 2013 VLDB 4.9769913e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 50 of 55 cited papers.

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

Rank Cited Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00076265429
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047864281
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.0004772731
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
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033884854
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003136296
124 Approximate Frequency Counts over Data Streams 2002 VLDB 0.00030586757
135 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00029858107
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029618887
169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027126333
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024210103
232 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.0002378554
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023354266
253 Approximate Medians and other Quantiles in One Pass and with Limited Memory 1998 SIGMOD 0.00023047482
275 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022404363
284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022205848
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022112534
309 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021376597
312 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.0002130211
352 The Query By Image Content (QBIC) System 1995 SIGMOD 0.00020218955
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019822444
448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00018121533
450 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00018025134
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017955913
518 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00016938992
644 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015209065
700 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014675903
743 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014309723
785 A One-Pass Algorithm for Accurately Estimating Quantiles for Disk-Resident Data 1997 VLDB 0.00013999898
806 Universality of Serial Histograms 1993 VLDB 0.00013786471
863 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013390792
867 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013376165
919 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013077728
1,004 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012588952
1,078 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012149796
1,163 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001174542
1,173 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.0001168187
1,184 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011608071
1,462 Substring Selectivity Estimation 1999 PODS 0.00010578962
1,687 Global Optimization of Histograms 2001 SIGMOD 9.8614576e-05
1,743 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7342409e-05
1,820 A Scalable Hash Ripple Join Algorithm 2002 SIGMOD 9.5651265e-05
1,960 StatiX: Making XML Count 2002 SIGMOD 9.3083244e-05
2,164 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9309999e-05
2,183 Probabilistic Optimization of Top N Queries 1999 VLDB 8.9044171e-05
2,370 Statistical Synopses for Graph-Structured XML Databases 2002 SIGMOD 8.5582212e-05
2,827 Estimating the Selectivity of Spatial Queries Using the 'Correlation' Fractal Dimension 1995 VLDB 7.9637452e-05
3,185 Structure and Value Synopses for XML Data Graphs 2002 VLDB 7.5542356e-05
3,270 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB 7.4722097e-05
Previous Page 1 / 2 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB
2 1,687 Global Optimization of Histograms 2001 SIGMOD
3 12,325 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS
4 284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
5 11,945 Data-Independent Space Partitionings for Summaries 2021 PODS
6 6,643 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS
7 37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
8 9,151 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD
9 5,535 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS
10 743 Dynamic Multidimensional Histograms 2002 SIGMOD