• DocumentCode
    834082
  • Title

    Optimal distribution of signatures in signature hashing

  • Author

    Ramakrishna, M.V. ; Ramos, Edgar A.

  • Author_Institution
    Dept. of Comput. Sci., Michigan State Univ., East Lansing, MI, USA
  • Volume
    4
  • Issue
    1
  • fYear
    1992
  • fDate
    2/1/1992 12:00:00 AM
  • Firstpage
    83
  • Lastpage
    88
  • Abstract
    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
  • Keywords
    database theory; file organisation; optimisation; asymptotic analysis; external files; load factor; optimization problem; signature hashing; single access retrieval; skew distribution; Books; Cost function; Particle separators; Terminology;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.124899
  • Filename
    124899