A hashing-based dynamic file structure is introduced for partial match retrieval using overflow bucket sharing. The sharing of overflow buckets is dynamic in the sense that an overflow bucket is shared by a varying number of primary buckets according to the local conditions of the file. The use and sharing of overflow buckets defers splitting of the data buckets, thereby increasing the storage utilization. For the same reason, plus the fact that the sharing is dynamic, the growth of the directory is slowed down. Under the proposed organization, the records are stored more compactly in the data buckets, and for those partial match queries in which few attributes are specified, groups of neighboring directory entries have high probability of being referenced together, so that the retrieval costs for these types of partial match queries are reduced. This file organization is found to be space efficient and is also time efficient for queries in which the number of specified attributes is small.
[1]
Kotagiri Ramamohanarao,et al.
Partial-match retrieval for dynamic files
,
1982,
BIT.
[2]
Per-Åke Larson,et al.
Linear Hashing with Partial Expansions
,
1980,
VLDB.
[3]
Ronald Fagin,et al.
Extendible hashing—a fast access method for dynamic files
,
1979,
ACM Trans. Database Syst..
[4]
SchollMichel.
New file organization based on dynamic hashing
,
1981
.
[5]
Witold Litwin,et al.
Linear Hashing: A new Algorithm for Files and Tables Addressing
,
1980,
ICOD.
[6]
Haim Mendelson,et al.
Analysis of Extendible Hashing
,
1982,
IEEE Transactions on Software Engineering.
[7]
Per-Åke Larson,et al.
Dynamic hashing
,
1978,
BIT.
[8]
Alfred V. Aho,et al.
Optimal partial-match retrieval when fields are independently specified
,
1979,
ACM Trans. Database Syst..