Random Sampling from Hash Files

Summary: Evaluates random sampling from hash files on storage across static (open addressing, overflow chains) and dynamic hash schemes (Linear/Extendible). Iterative and batch sampling; analyzes cost by successful search; dynamic hashing boosts sampling efficiency. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h445bb258c1b7c1eb
Venue: SIGMOD
Year: 1990
Pagerank: 0.00011381076
Overall Rank: 1,237 | 91.71%
DOI: 10.1145/93597.98746

Incoming Non-self Citations Over Time

Authors

1. Frank Olken (Lawrence Berkeley National Laboratory)
2. Doron Rotem (Lawrence Berkeley National Laboratory)
3. Ping Xu (San Francisco State University)

BibTeX Citation

@inproceedings{olken_sigmod90,
        title = {{Random Sampling from Hash Files}},
        author = {Olken, Frank and Rotem, Doron and Xu, Ping},
        series = {{SIGMOD} '90},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/93597.98746},
        url = {https://dl.acm.org/doi/10.1145/93597.98746},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
220	An Evaluation of Non-Equijoin Algorithms	1991	VLDB	0.00024275691
491	Practical Skew Handling in Parallel Joins	1992	VLDB	0.00017383221
1,095	Scalable Approximate Query Processing With The DBO Engine	2007	SIGMOD	0.00012036913
1,465	Online Maintenance of Very Large Random Samples on Flash Storage	2008	VLDB	0.00010546726
1,469	On the Relative Cost of Sampling for Join Selectivity Estimation	1994	PODS	0.00010533259
2,335	Online Maintenance of Very Large Random Samples	2004	SIGMOD	8.6050778e-05
4,236	A Disk-Based Join With Probabilistic Guarantees*	2005	SIGMOD	6.7028998e-05
4,331	Density Biased Sampling: An Improved Method for Data Mining and Clustering	2000	SIGMOD	6.644974e-05
7,549	Algebraic Optimization of Computations over Scientific Databases	1993	VLDB	5.4809567e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
58	Statistical Estimators for Relational Algebra Expressions	1988	PODS	0.00039922419
183	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD	0.00026316699
480	Random Sampling from B+ trees	1989	VLDB	0.00017573936
1,112	New Strategies for Computing the Transitive Closure of a Database Relation	1987	VLDB	0.00011945358
1,423	Estimating the Size of Generalized Transitive Closures	1989	VLDB	0.00010696781

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,033	Distribution-Dependent Hashing Functions and Their Characteristics	1975	SIGMOD
2	480	Random Sampling from B+ trees	1989	VLDB
3	5,289	External Perfect Hashing	1985	SIGMOD
4	2,872	Concurrency and Linear Hashing	1985	PODS
5	5,718	A Mapping Function for the Directory of a Multidimensional Extendible Hashing	1984	VLDB
6	13,579	A Dynamic Perfect Hash Function Defined by an Extended Hash Indicator Table	1984	VLDB
7	2,807	Unified Dynamic Hashing	1984	VLDB
8	9,187	Hashing in Practice, Analysis of Hashing and Universal Hashing	1988	SIGMOD
9	8,573	A Dynamic Hash File for Random and Sequential Accessing	1983	VLDB
10	3,943	A Single-File Version of Linear Hashing with Partial Expansions	1982	VLDB