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.00023363722
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.00035978046
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029627449
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00028633995
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
267 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022722971
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022509573
312 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021311793
336 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020657819
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019829769
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
428 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.0001845349
448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00018129161
450 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00018032912
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017962189
519 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00016942879
566 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD 0.00016295476
742 Dynamic Multidimensional Histograms 2002 SIGMOD 0.0001431602
842 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013540697
858 What’s Hot and What’s Not: Tracking Most Frequent Items Dynamically 2003 PODS 0.000134266
862 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013396995
931 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013011667
948 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012914559
1,004 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012594522
1,242 Compressing SQL Workloads 2002 SIGMOD 0.00011373611
1,741 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7382372e-05
1,826 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 9.5575424e-05
1,891 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4184294e-05
2,171 Summarizing and Mining Inverse Distributions on Data Streams via Dynamic Inverse Sampling 2005 VLDB 8.9239861e-05
2,625 Statistical Learning Techniques for Costing XML Queries 2005 VLDB 8.2089383e-05
2,807 Sampling Time-Based Sliding Windows in Bounded Space 2008 SIGMOD 7.982663e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
3,094 Holistic UDAFs at Streaming Speeds 2004 SIGMOD 7.6533343e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-05
3,984 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8741188e-05
4,251 Selectivity Estimation for Spatio-Temporal Queries to Moving Objects 2002 SIGMOD 6.7020655e-05
4,932 Space efficiency in Synopsis construction algorithms 2005 VLDB 6.3483816e-05
5,534 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 6.0923159e-05
5,580 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0769576e-05
6,182 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8588933e-05
6,639 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7259633e-05
6,781 Robust Estimation With Sampling and Approximate Pre-Aggregation 2003 VLDB 5.6836871e-05
7,493 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.5103311e-05
10,316 Distributed Wavelet Thresholding for Maximum Error Metrics 2016 SIGMOD 5.0377739e-05
11,939 Data-Independent Space Partitionings for Summaries 2021 PODS 4.9793485e-05
12,319 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.9793485e-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.0023947656
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.0003475226
3,967 Estimation of Query-Result Distribution and its Application in Parallel-Join Load Balancing 1996 VLDB 6.8905715e-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 742 Dynamic Multidimensional Histograms 2002 SIGMOD
3 806 Universality of Serial Histograms 1993 VLDB
4 5,534 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,568 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 519 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD
9 283 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