An improved index sequential access method using hashed overflow

ABSTRACT

The Index Sequential Access Method (ISAM) is one of the most important file management systems used with moveable head disk devices. This study investigates the use of an unconventional method of treating overflow records. The method is to use hashing techniques to allocate space for such records. If certain conditions are satisfied, this is superior to the conventional ISAM method of chaining the overflow records via linked list techniques. These conditions are: long overflow chains with significant overflow; lack of tight disk space constraints; record keys which are small compared to the total record size; and significant use of the file in the index as opposed to the sequential mode. Using hashed overflow, the time to locate a record is dependent not on the total volume of overflow records as in conventional ISAM, but on the percentage use of space dedicated to overflow records.

REFERENCES

• 1: Coyle, Frank. The hidden speed of ISAM. Datamation (June 15, 1971), 48-49.
• 2: Ivan Flores, Data Structure and Management, Prentice Hall PTR, Upper Saddle River, NJ, 1977
• 3: V. Y. Lum , P. S. T. Yuen , M. Dodd, Key-to-address transform techniques: a fundamental performance study on large existing formatted files, Communications of the ACM, v.14 n.4, p.228-239, April 1971 [doi>10.1145/362575.362578]
• 4: Lum, V.Y., Ling, H., Senko, M.E. Analysis of a complex data management access method by simulation modeling. Proc. AFIPS 1970 FJCC Vol. 37, AFIPS Press, Montvale, N.J., pp. 211-222.
• 5: Robert Morris, Scatter storage techniques, Communications of the ACM, v.11 n.1, p.38-44, Jan. 1968 [doi>10.1145/362851.362882]
• 6: Morals, R. Introduction to IBM System/360 direct access storage device and organization methods. Student Text, C20-1649-3, Apr. 1969 IBM Corp., Armonk, N.Y.

INDEX TERMS

Keywords:
ISAM, cylinder, disk, hashing, index sequential, overflow, scatter storage