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
9151
Venue
VLDB
Year
2003
Pagerank
0.00023154793
Overall Rank
257 | 98.24%
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 50 citing papers.

Rank Citing Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
310 Order Preserving Encryption for Numeric Data 2004 SIGMOD 0.00021766789
388 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019410042
411 Worst-case Optimal Join Algorithms 2012 PODS 0.00018902089
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016436005
689 On Synopses for Distinct-Value Estimation Under Multiset Operations 2007 SIGMOD 0.00014940023
866 Pay-as-you-go User Feedback for Dataspace Systems 2008 SIGMOD 0.00013519288
1,071 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012322342
1,126 Adaptive Range Filters for Cold Data: Avoiding Trips to Siberia 2013 VLDB 0.00012078607
1,256 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011457194
1,503 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.000105564
1,519 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010513777
1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010328171
1,967 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.3804693e-05
2,069 Generating Targeted Queries for Database Testing 2008 SIGMOD 9.2293717e-05
2,150 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 9.081101e-05
2,269 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.8328424e-05
2,678 Weighted Hypertree Decompositions and Optimal Query Plans 2004 PODS 8.2680182e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
2,933 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 7.9474026e-05
2,944 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9335187e-05
2,991 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.8880723e-05
3,228 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6215176e-05
3,426 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.4218997e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
4,405 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.7218674e-05
5,459 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.2108888e-05
5,693 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 6.1189424e-05
5,792 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 6.0871213e-05
5,860 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 6.0636893e-05
6,360 Approximate Summaries for Why and Why-not Provenance 2020 VLDB 5.9009081e-05
6,510 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.8569033e-05
6,760 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.7826781e-05
8,059 Probabilistic Histograms for Probabilistic Data 2009 VLDB 5.4979799e-05
8,124 Consistent and Flexible Selectivity Estimation for High-Dimensional Data 2021 SIGMOD 5.4829513e-05
8,420 Histograms as a Side Effect of Data Movement for Big Data 2014 SIGMOD 5.4279873e-05
8,511 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.4119882e-05
8,728 Computing A Well-Representative Summary of Conjunctive Query Results 2024 PODS 5.3766157e-05
9,209 Optimality and Scalability in Lattice Histogram Construction 2009 VLDB 5.3058708e-05
9,386 Determining Exact Quantiles with Randomized Summaries 2024 SIGMOD 5.2755515e-05
9,455 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.2653318e-05
10,016 Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections 2022 VLDB 5.1764556e-05
10,851 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 5.093636e-05
10,891 Cardinality Estimation for Having-Clauses 2025 VLDB 5.093636e-05
11,059 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.093636e-05
11,290 Presto’s History-based Query Optimizer 2024 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,502 Filtered Statistics 2009 SIGMOD 5.093636e-05
Previous Page 1 / 1 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.00077458002
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00048351457
89 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00035031529
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
101 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00034376651
118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031922279
122 Approximate Frequency Counts over Data Streams 2002 VLDB 0.00031260115
131 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00030424509
136 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00030123303
168 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027541029
213 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024723025
222 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00024193708
235 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023783792
261 Approximate Medians and other Quantiles in One Pass and with Limited Memory 1998 SIGMOD 0.00023097188
267 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022798161
274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022645621
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
307 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021792475
311 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021760621
353 The Query By Image Content (QBIC) System 1995 SIGMOD 0.00020370587
365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00020041735
435 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.000185063
443 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00018373044
448 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00018292618
508 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00017275873
664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015167825
692 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014919816
723 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014620977
783 A One-Pass Algorithm for Accurately Estimating Quantiles for Disk-Resident Data 1997 VLDB 0.00014076306
786 Universality of Serial Histograms 1993 VLDB 0.00014053885
842 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013671191
850 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013619394
901 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013334162
977 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012864017
1,053 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012401532
1,140 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001200574
1,156 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.00011929041
1,172 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011825923
1,427 Substring Selectivity Estimation 1999 PODS 0.00010812749
1,668 Global Optimization of Histograms 2001 SIGMOD 0.00010057026
1,729 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.908788e-05
1,785 A Scalable Hash Ripple Join Algorithm 2002 SIGMOD 9.7702627e-05
1,900 StatiX: Making XML Count 2002 SIGMOD 9.5168326e-05
2,127 Selectivity Estimation in Spatial Databases 1999 SIGMOD 9.127762e-05
2,149 Probabilistic Optimization of Top N Queries 1999 VLDB 9.0821709e-05
2,326 Statistical Synopses for Graph-Structured XML Databases 2002 SIGMOD 8.748172e-05
2,774 Estimating the Selectivity of Spatial Queries Using the 'Correlation' Fractal Dimension 1995 VLDB 8.1372328e-05
3,129 Structure and Value Synopses for XML Data Graphs 2002 VLDB 7.7256156e-05
3,207 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB 7.6364508e-05
Previous Page 1 / 2 Next

Semantically Similar Papers

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