DBScholar

Back to papers

Fast Incremental Maintenance of Approximate Histograms

Summary: Sampling-based incremental maintenance keeps equi-depth and Compressed histograms continuously current, scheduling work only when needed for orders-of-magnitude better cardinality estimates. An efficiently maintained up-to-date uniform backing sample also generalizes to dynamic-sampling applications. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h9f11f3d0d758622f
Venue
VLDB
Year
1997
Pagerank
0.00023354266
Overall Rank
242 | 98.38%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{gibbons_vldb97,
        title = {{Fast Incremental Maintenance of Approximate Histograms}},
        author = {Gibbons, Phillip B. and Matias, Yossi and Poosala, Viswanath},
        journal = {PVLDB},
        series = {{VLDB} '97},
        pages = {466},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 46 of 46 citing papers.

Rank Citing Paper Year Venue Pagerank
83 Space-Efficient Online Computation of Quantile Summaries 2001 SIGMOD 0.00035962466
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034099838
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029618887
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00028621958
255 The History of Histograms (abridged) 2003 VLDB 0.00022974524
267 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022713652
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002251422
312 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.0002130211
335 The Aqua Approximate Query Answering System 1999 SIGMOD 0.000206533
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019822444
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0001971778
429 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018445263
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
566 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD 0.00016288241
743 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014309723
843 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013534623
858 What’s Hot and What’s Not: Tracking Most Frequent Items Dynamically 2003 PODS 0.00013420431
863 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013390792
930 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013009255
947 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012920489
1,004 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012588952
1,244 Compressing SQL Workloads 2002 SIGMOD 0.00011369155
1,743 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7342409e-05
1,826 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 9.5535288e-05
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
2,173 Summarizing and Mining Inverse Distributions on Data Streams via Dynamic Inverse Sampling 2005 VLDB 8.9197633e-05
2,625 Statistical Learning Techniques for Costing XML Queries 2005 VLDB 8.206615e-05
2,808 Sampling Time-Based Sliding Windows in Bounded Space 2008 SIGMOD 7.9788841e-05
3,075 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6742518e-05
3,096 Holistic UDAFs at Streaming Speeds 2004 SIGMOD 7.6497893e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3726415e-05
3,985 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8708857e-05
4,252 Selectivity Estimation for Spatio-Temporal Queries to Moving Objects 2002 SIGMOD 6.6989321e-05
4,933 Space efficiency in Synopsis construction algorithms 2005 VLDB 6.3454089e-05
5,535 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 6.0905677e-05
5,581 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0741907e-05
6,185 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8561596e-05
6,643 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7233159e-05
6,786 Robust Estimation With Sampling and Approximate Pre-Aggregation 2003 VLDB 5.6811262e-05
7,496 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.5081355e-05
10,318 Distributed Wavelet Thresholding for Maximum Error Metrics 2016 SIGMOD 5.0363234e-05
11,945 Data-Independent Space Partitionings for Summaries 2021 PODS 4.9769913e-05
12,325 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 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.0023943337
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
3,969 Estimation of Query-Result Distribution and its Application in Parallel-Join Load Balancing 1996 VLDB 6.8874168e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD
2 743 Dynamic Multidimensional Histograms 2002 SIGMOD
3 806 Universality of Serial Histograms 1993 VLDB
4 5,535 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS
5 37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
6 7,574 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS
7 448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB
8 518 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD
9 284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
10 153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD