This Article 
 Bibliographic References 
 Add to: 
Optimal Distribution of Signatures in Signature Hashing
February 1992 (vol. 4 no. 1)
pp. 83-88

G.H. Gonnet and P.A. Larson (1982) proposed a hashing scheme for external files which guarantees single access retrieval. They provided an asymptotic analysis of the scheme assuming uniform distribution of the signatures. This paper addresses an open problem posed by them in a second work (J. ACM, vol.35, no.1, p.161-84, 1988) about the performance of signatures having a skew distribution. An optimization problem is formulated to obtain the optimal signature distribution which maximizes the resulting load factor. Numerical results indicate that the optimal signature distribution results in significant reduction in the cost of insertions, which is of practical significance.

[1] W. Feller,An Introduction to Probability Theory and its Applications, Vol. 1, New York: Wiley, 1968.
[2] G. H. Gonnet and P. A. Larson, "External hashing with limited internal storage," inProc. ACM Symp. Principles of Database Syst., ACM, New York, 1982, pp. 256-261.
[3] G. H. Gonnet and P. A. Larson, "External hashing with limited internal storage,"J. ACM, vol. 35, no. 1, pp. 161-184, 1988.
[4] P. A. Larson and A. Kajla, "File organization--Implementation of a method guaranteeing retrieval in one access,"Commun. ACM, vol. 27, no. 7, pp. 670-677, 1984.
[5] P. A. Larson, "Analysis of uniform hashing,"J. ACM, vol. 30, no. 4, pp. 805-819, 1983.
[6] A. L. Tharp,File Organization and Processing, New York: Wiley, 1988.

Index Terms:
signature hashing; external files; single access retrieval; asymptotic analysis; skew distribution; optimization problem; load factor; database theory; file organisation; optimisation
M.V. Ramakrishna, E.A. Ramos, "Optimal Distribution of Signatures in Signature Hashing," IEEE Transactions on Knowledge and Data Engineering, vol. 4, no. 1, pp. 83-88, Feb. 1992, doi:10.1109/69.124899
Usage of this product signifies your acceptance of the Terms of Use.