DBScholar

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
he41024073c98c7b0
Venue
SIGMOD
Year
1998
Pagerank
0.00016918797
Overall Rank
518 | 96.53%
DOI
10.1145/276304.276343

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{chaudhuri_sigmod98,
        title = {{Random Sampling for Histogram Construction: How much is enough?}},
        author = {Chaudhuri, Surajit and Motwani, Rajeev and Narasayya, Vivek},
        series = {{SIGMOD} '98},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/276304.276343},
        url = {https://dl.acm.org/doi/10.1145/276304.276343},
        year = {1998}
}

Incoming Citations (Sorted by Pagerank)

Showing 41 of 41 citing papers.

Rank Citing Paper Year Venue Pagerank
20 Similarity Search in High Dimensions via Hashing 1999 VLDB 0.00057610161
26 Models and Issues in Data Stream Systems 2002 PODS 0.00051942573
82 Space-Efficient Online Computation of Quantile Summaries 2001 SIGMOD 0.00036097627
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
268 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022654182
374 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019698889
380 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019530546
442 Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets 1999 SIGMOD 0.00018182341
594 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015814493
841 Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters 2016 SIGMOD 0.00013503124
998 To Search or to Crawl? Towards a Query Optimizer for Text-Centric Tasks 2006 SIGMOD 0.00012590871
1,065 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012181098
1,754 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7111856e-05
1,828 Effective Use of Block-Level Sampling in Statistics Estimation 2004 SIGMOD 9.5396315e-05
2,184 Summarizing and Mining Inverse Distributions on Data Streams via Dynamic Inverse Sampling 2005 VLDB 8.8972748e-05
2,438 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4532693e-05
3,219 Comparing Data Streams Using Hamming Norms (How to Zero In) 2002 VLDB 7.50928e-05
3,312 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS 7.4165176e-05
3,993 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8565106e-05
4,661 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4656621e-05
4,701 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.44638e-05
4,956 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD 6.326039e-05
5,049 Adaptive Sampling for Rapidly Matching Histograms 2018 VLDB 6.287033e-05
5,192 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.2209024e-05
5,336 Fast and Approximate Stream Mining of Quantiles and Frequencies Using Graphics Processors 2005 SIGMOD 6.1613661e-05
5,394 PREDIcT: Towards Predicting the Runtime of Large Scale Iterative Analytics 2013 VLDB 6.1351004e-05
5,552 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 6.0707348e-05
5,591 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0553413e-05
5,712 Approximate Quantiles and the Order of the Stream 2006 PODS 6.0096683e-05
6,195 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8374071e-05
6,653 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7044094e-05
6,703 Query Sampling in DB2 Universal Database 2004 SIGMOD 5.687355e-05
7,267 Efficient Dynamic Weighted Set Sampling and Its Extension 2024 VLDB 5.5539363e-05
7,387 Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries 2021 SIGMOD 5.5212177e-05
8,600 Histograms as a Side Effect of Data Movement for Big Data 2014 SIGMOD 5.2913419e-05
9,481 Estimating Quantiles from the Union of Historical and Streaming Data 2017 VLDB 5.1569355e-05
10,231 Task Cascades for Efficient Unstructured Data Processing 2026 SIGMOD 5.0432098e-05
10,334 AdaNDV: Adaptive Number of Distinct Value Estimation via Learning to Select and Fuse Estimators 2025 VLDB 5.0225409e-05
11,260 PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models 2025 SIGMOD 4.9605343e-05
12,368 Are Few Bins Enough: Testing Histogram Distributions 2016 PODS 4.9605343e-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.0023948467
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
58 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00039922419
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036394222
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028611216
183 Processing Aggregate Relational Queries with Hard Time Constraints 1989 SIGMOD 0.00026316699
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023327437
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020265363
492 Error-Constrained COUNT Query Evaluation in Relational Databases 1991 SIGMOD 0.00017359343
1,012 Query Size Estimation by Adaptive Sampling (Extended Abstract) 1990 PODS 0.00012489386
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,884 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD
2 4,055 Counting, Enumerating, and Sampling of Execution Plans in a Cost-Based Query Optimizer 2000 SIGMOD
3 806 Universality of Serial Histograms 1993 VLDB
4 2,438 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD
5 4,815 Error-bounded Sampling for Analytics on Big Sparse Data 2014 VLDB
6 7,584 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS
7 79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD
8 285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
9 450 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB
10 242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB