Definition

ISAM (Indexed Sequential Access Method)

ISAM (Indexed Sequential Access Method) is a file management system developed at IBM that allows records to be accessed either sequentially (in the order they were entered) or randomly (with an index). Each index defines a different ordering of the records. An employee database may have several indexes, based on the information being sought. For example, a name index may order employees alphabetically by last name, while a department index may order employees by their department. A key is specified in each index. For an alphabetical index of employee names, the last name field would be the key.

ISAM was developed prior to VSAM (Virtual Storage Access Method) and relational databases.

This was last updated in November 2005

Dig Deeper on IBM system z and mainframe systems

PRO+

Content

Find more PRO+ content and other member only offers, here.

Join the conversation

2 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

ISAM: I use many Flat Files, with fixed-length records, and "text" fields, working in tandem with Perl SDBM binary files of key/value pairs tied to Perl program hash tables. These key/value pairs offer persistent, instantaneous, random access to Flat File records. For random access, the file pointer is first set to a single record location byte offset, where the offset is the number of bytes to seek to from either TOP of file or END of file. Then the record is read into memory. Once in memory, the contents of the record can be changed/modified and written back out to the Flat File, overwriting the existing data stored in that record. NO SQL (ISAM) is faster than SQL because it does not use a query optimizer. THIS IS FREE DB TECHNOLOGY FOLKS !!! AND YOU DON'T NEED A HIGHLY SKILLED DBA TO MAINTAIN IT. NO DATA ACCESS COMPONENTS HAVE TO BE INSTALLED EITHER.
Cancel
Joint Database Technology https://en.wikipedia.org/wiki/Dbm
Using Flat File, fixed-length record databases in tandem with binary SDBM database files of key/value pairs tied to program hash tables for persistent random access indexing to Flat File records by the information contained within the fields of the Flat File records.
Cancel

-ADS BY GOOGLE

File Extensions and File Formats

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close