Database Paper Browser

Back to papers

Random Sampling for Histogram Construction: How much is enough?

Summary: Optimal sampling bounds for equi-height histograms; region-sensitive error metric; adaptive page-level sampling leveraging value clustering. Distinct-value estimation is hard; practical estimator for optimizers; SQL Server 7.0 prototype confirms accuracy. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3035
Venue
SIGMOD
Year
1998
Pagerank
0.0002079072
Overall Rank
531 | 96.32%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 41 of 41 citing papers.

Rank Citing Paper Year Venue Pagerank
34 Similarity Search in High Dimensions via Hashing 1999 VLDB 0.00076824554
43 Models and Issues in Data Stream Systems 2002 PODS 0.00072660894
126 Space-Efficient Online Computation of Quantile Summaries 2001 SIGMOD 0.00044753012
316 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00027981848
325 The History of Histograms (abridged) 2003 VLDB 0.00027398081
430 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00023406426
446 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00023002059
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022796106
517 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021193179
759 To Search or to Crawl? Towards a Query Optimizer for Text-Centric Tasks 2006 SIGMOD 0.00017041917
941 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015147831
1,320 Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters 2016 SIGMOD 0.00012606067
1,574 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00011289028
1,691 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010890775
1,790 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 0.00010529479
2,269 Summarizing and Mining Inverse Distributions on Data Streams via Dynamic Inverse Sampling 2005 VLDB 9.1507118e-05
3,013 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 7.7082045e-05
3,123 Comparing Data Streams Using Hamming Norms (How to Zero In) 2002 VLDB 7.5270618e-05
3,292 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS 7.2598265e-05
3,878 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.6669911e-05
4,024 Approximate Quantiles and the Order of the Stream 2006 PODS 6.5177066e-05
4,679 Adaptive Sampling for Rapidly Matching Histograms 2018 VLDB 5.9978792e-05
5,066 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD 5.7157182e-05
5,114 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 5.6813929e-05
5,128 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 5.6728511e-05
5,465 Fast and Approximate Stream Mining of Quantiles and Frequencies Using Graphics Processors 2005 SIGMOD 5.491937e-05
5,642 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 5.3964761e-05
5,699 PREDIcT: Towards Predicting the Runtime of Large Scale Iterative Analytics 2013 VLDB 5.3655096e-05
5,832 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 5.3085972e-05
6,154 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 5.1795738e-05
6,448 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.0532741e-05
6,543 Query Sampling in DB2 Universal Database 2004 SIGMOD 5.0139217e-05
6,634 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 4.9784928e-05
7,340 Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries 2021 SIGMOD 4.7526052e-05
8,433 Histograms as a Side Effect of Data Movement for Big Data 2014 SIGMOD 4.5078508e-05
8,609 Efficient Dynamic Weighted Set Sampling and Its Extension 2024 VLDB 4.4810481e-05
9,162 Estimating Quantiles from the Union of Historical and Streaming Data 2017 VLDB 4.380727e-05
10,215 Task Cascades for Efficient Unstructured Data Processing 2026 SIGMOD 4.1905499e-05
10,507 PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models 2025 SIGMOD 4.1905499e-05
10,543 AdaNDV: Adaptive Number of Distinct Value Estimation via Learning to Select and Fuse Estimators 2025 VLDB 4.1905499e-05
11,829 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 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.0040465394
28 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00080571183
37 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00075597514
60 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00064450997
63 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063595699
92 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00051431888
133 Processing Aggregate Relational Queries with Hard Time Constraints 1989 SIGMOD 0.00043220055
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031727601
270 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00029648047
291 Error-Constrained COUNT Query Evaluation in Relational Databases 1991 SIGMOD 0.00028778973
328 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027301497
369 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00025502381
751 Query Size Estimation by Adaptive Sampling (Extended Abstract) 1990 PODS 0.00017155121
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
801 Universality of Serial Histograms 1993 VLDB 0.00016440976
3,563 Counting, Enumerating, and Sampling of Execution Plans in a Cost-Based Query Optimizer 2000 SIGMOD 6.9686532e-05
4,100 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD 6.4473679e-05
3,013 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 7.7082045e-05
5,258 Error-bounded Sampling for Analytics on Big Sparse Data 2014 VLDB 5.5973455e-05
7,150 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS 4.8128138e-05
92 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00051431888
328 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027301497
360 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00025768448
270 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00029648047