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.00022999992
Overall Rank
254 | 98.30%
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 52 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
315 Order Preserving Encryption for Numeric Data 2004 SIGMOD 0.00021247386
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
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
711 On Synopses for Distinct-Value Estimation Under Multiset Operations 2007 SIGMOD 0.00014589586
890 Pay-as-you-go User Feedback for Dataspace Systems 2008 SIGMOD 0.00013212032
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,117 Adaptive Range Filters for Cold Data: Avoiding Trips to Siberia 2013 VLDB 0.00011928965
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010408003
1,539 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010292787
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,901 Generating Targeted Queries for Database Testing 2008 SIGMOD 9.3902763e-05
2,019 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.1666472e-05
2,168 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9159881e-05
2,305 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.6550507e-05
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
2,739 Weighted Hypertree Decompositions and Optimal Query Plans 2004 PODS 8.0598805e-05
2,792 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 7.9895218e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
3,093 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6378811e-05
3,361 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3621595e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
4,480 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.566036e-05
5,591 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0553413e-05
5,815 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 5.9683874e-05
5,837 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9600736e-05
5,986 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.9085861e-05
6,502 Approximate Summaries for Why and Why-not Provenance 2020 VLDB 5.7468661e-05
6,653 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7044094e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
7,537 Computing A Well-Representative Summary of Conjunctive Query Results 2024 PODS 5.4841462e-05
8,205 Probabilistic Histograms for Probabilistic Data 2009 VLDB 5.3616572e-05
8,295 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.344057e-05
8,297 Consistent and Flexible Selectivity Estimation for High-Dimensional Data 2021 SIGMOD 5.3438874e-05
8,600 Histograms as a Side Effect of Data Movement for Big Data 2014 SIGMOD 5.2913419e-05
9,141 Presto’s History-based Query Optimizer 2024 VLDB 5.2078543e-05
9,422 Optimality and Scalability in Lattice Histogram Construction 2009 VLDB 5.1672232e-05
9,603 Determining Exact Quantiles with Randomized Summaries 2024 SIGMOD 5.1376962e-05
9,667 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.1278365e-05
9,952 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.0910746e-05
10,249 Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections 2022 VLDB 5.0412674e-05
10,392 E-LQO: A Comprehensive Energy Evaluation Framework for Learned Query Optimization 2027 SIGMOD 4.9605343e-05
10,979 Incremental Query Optimizer Statistics in Amazon Redshift 2026 VLDB 4.9605343e-05
11,321 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9605343e-05
11,353 Cardinality Estimation for Having-Clauses 2025 VLDB 4.9605343e-05
12,368 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.9605343e-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.00076079812
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047770864
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047654188
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033847446
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031291457
124 Approximate Frequency Counts over Data Streams 2002 VLDB 0.00030503973
135 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00029805026
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029532435
171 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027063233
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024136952
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
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
277 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002235043
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
311 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021315058
316 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021238056
350 The Query By Image Content (QBIC) System 1995 SIGMOD 0.0002018411
372 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019768921
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
518 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00016918797
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015166402
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
806 Universality of Serial Histograms 1993 VLDB 0.00013752086
861 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013374869
868 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013336675
919 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013042589
1,006 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012551491
1,080 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012114187
1,164 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001170903
1,174 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.0001165008
1,187 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011580993
1,466 Substring Selectivity Estimation 1999 PODS 0.00010546176
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,832 A Scalable Hash Ripple Join Algorithm 2002 SIGMOD 9.5365548e-05
1,969 StatiX: Making XML Count 2002 SIGMOD 9.2805411e-05
2,176 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9031141e-05
2,193 Probabilistic Optimization of Top N Queries 1999 VLDB 8.8828694e-05
2,378 Statistical Synopses for Graph-Structured XML Databases 2002 SIGMOD 8.5315761e-05
2,838 Estimating the Selectivity of Spatial Queries Using the 'Correlation' Fractal Dimension 1995 VLDB 7.9401525e-05
3,195 Structure and Value Synopses for XML Data Graphs 2002 VLDB 7.530952e-05
3,281 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB 7.4493372e-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,693 Global Optimization of Histograms 2001 SIGMOD
3 12,368 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS
4 285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
5 11,989 Data-Independent Space Partitionings for Summaries 2021 PODS
6 6,653 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,173 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD
9 5,552 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS
10 745 Dynamic Multidimensional Histograms 2002 SIGMOD