Design of a balanced multiple-valued file-organization scheme with the least redundancy

  • Authors:
  • Sumiyasu Yamamoto;Shinsei Tazawa;Kazuhiko Ushio;Hideto Ikeda

  • Affiliations:
  • Hiroshima Univ., Hiroshima City, Japan;Hiroshima College of Economics., Hiroshima City, Japan;Niihama Technical College, Niihama City, Japan;Hiroshima Univ., Hiroshima City, Japan

  • Venue:
  • ACM Transactions on Database Systems (TODS)
  • Year:
  • 1979

Quantified Score

Hi-index 0.00

Visualization

Abstract

A new balanced file-organization scheme of order two for multiple-valued records is presented. This scheme is called HUBMFS2 (Hiroshima University Balanced Multiple-valued File-organization Scheme of order two). It is assumed that records are characterized by m attributes having n possible values each, and the query set consists of queries which specify values of two attributes. It is shown that the redundancy of the bucket (the probability of storing a record in the bucket) is minimized if and only if the structure of the bucket is a partite-claw. A necessary and sufficient condition for the existence of an HUBMFS2, which is composed exclusively of partite-claw buckets, is given. A construction algorithm is also given. The proposed HUBMFS2 is superior to existing BMFS2 (Balanced Multiple-valued File-organization Schemes of order two) in that it has the least redundancy among all possible BMFS2's having the same parameters and that it can be constructed for a less restrictive set of parameters.