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: 2563
Venue: SIGMOD
Year: 1990
Pagerank: 0.00011663837
Overall Rank: 1,206 | 91.73%
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
210	An Evaluation of Non-Equijoin Algorithms	1991	VLDB	0.00024797689
481	Practical Skew Handling in Parallel Joins	1992	VLDB	0.00017780716
1,064	Scalable Approximate Query Processing With The DBO Engine	2007	SIGMOD	0.00012336248
1,435	Online Maintenance of Very Large Random Samples on Flash Storage	2008	VLDB	0.00010800274
1,440	On the Relative Cost of Sampling for Join Selectivity Estimation	1994	PODS	0.00010778889
2,271	Online Maintenance of Very Large Random Samples	2004	SIGMOD	8.8254873e-05
4,138	A Disk-Based Join With Probabilistic Guarantees*	2005	SIGMOD	6.8779166e-05
4,222	Density Biased Sampling: An Improved Method for Data Mining and Clustering	2000	SIGMOD	6.8227421e-05
7,385	Algebraic Optimization of Computations over Scientific Databases	1993	VLDB	5.6278655e-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
55	Statistical Estimators for Relational Algebra Expressions	1988	PODS	0.00040746149
178	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD	0.00026881845
467	Random Sampling from B+ trees	1989	VLDB	0.00018002218
1,086	New Strategies for Computing the Transitive Closure of a Database Relation	1987	VLDB	0.00012252192
1,382	Estimating the Size of Generalized Transitive Closures	1989	VLDB	0.00010965236

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,961	Distribution-Dependent Hashing Functions and Their Characteristics	1975	SIGMOD
2	467	Random Sampling from B+ trees	1989	VLDB
3	5,150	External Perfect Hashing	1985	SIGMOD
4	2,801	Concurrency and Linear Hashing	1985	PODS
5	5,577	A Mapping Function for the Directory of a Multidimensional Extendible Hashing	1984	VLDB
6	2,758	Unified Dynamic Hashing	1984	VLDB
7	13,242	A Dynamic Perfect Hash Function Defined by an Extended Hash Indicator Table	1984	VLDB
8	8,995	Hashing in Practice, Analysis of Hashing and Universal Hashing	1988	SIGMOD
9	8,371	A Dynamic Hash File for Random and Sequential Accessing	1983	VLDB
10	3,848	A Single-File Version of Linear Hashing with Partial Expansions	1982	VLDB