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
8638
Venue
VLDB
Year
1997
Pagerank
0.00023783792
Overall Rank
235 | 98.39%
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
82 Space-Efficient Online Computation of Quantile Summaries 2001 SIGMOD 0.00036378991
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
136 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00030123303
149 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00029226907
255 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00023174541
257 The History of Histograms (abridged) 2003 VLDB 0.00023154793
290 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002227038
311 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021760621
327 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00021091539
363 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0002005475
365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00020041735
418 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018812821
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
551 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD 0.00016635191
723 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014620977
817 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013823702
838 What’s Hot and What’s Not: Tracking Most Frequent Items Dynamically 2003 PODS 0.0001370404
842 How to Summarize the Universe: Dynamic Maintenance of Quantiles 2002 VLDB 0.00013671191
909 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013291205
931 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00013125812
977 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012864017
1,266 Compressing SQL Workloads 2002 SIGMOD 0.00011412078
1,729 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.908788e-05
1,806 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 9.7112151e-05
1,893 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.5269935e-05
2,128 Summarizing and Mining Inverse Distributions on Data Streams via Dynamic Inverse Sampling 2005 VLDB 9.1271562e-05
2,589 Statistical Learning Techniques for Costing XML Queries 2005 VLDB 8.371643e-05
2,753 Sampling Time-Based Sliding Windows in Bounded Space 2008 SIGMOD 8.1647557e-05
3,044 Holistic UDAFs at Streaming Speeds 2004 SIGMOD 7.820774e-05
3,137 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.7204167e-05
3,309 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.5368417e-05
3,930 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 7.0102082e-05
4,174 Selectivity Estimation for Spatio-Temporal Queries to Moving Objects 2002 SIGMOD 6.8515543e-05
4,819 Space efficiency in Synopsis construction algorithms 2005 VLDB 6.4940349e-05
5,421 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 6.2245831e-05
5,459 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.2108888e-05
6,059 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.9915079e-05
6,510 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.8569033e-05
6,654 Robust Estimation With Sampling and Approximate Pre-Aggregation 2003 VLDB 5.8131331e-05
7,388 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.6268292e-05
10,094 Distributed Wavelet Thresholding for Maximum Error Metrics 2016 SIGMOD 5.1530576e-05
11,632 Data-Independent Space Partitionings for Summaries 2021 PODS 5.093636e-05
12,024 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 5.093636e-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.0024089429
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
89 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00035031529
3,893 Estimation of Query-Result Distribution and its Application in Parallel-Join Load Balancing 1996 VLDB 7.04191e-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 723 Dynamic Multidimensional Histograms 2002 SIGMOD
3 786 Universality of Serial Histograms 1993 VLDB
4 5,421 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS
5 35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
6 7,443 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS
7 435 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB
8 508 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD
9 274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
10 149 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD