ISAM: Difference between revisions
No edit summary |
mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
'''Indexed Sequential Access Method''' (ISAM) is a method for indexing data for fast retrieval that was originally developed by IBM for mainframe computers. ISAM allows database records to be accessed either sequentially as they were created or randomly via an index which in turn represents the same data in a different order. This is in contrast to a relational database that uses query optimising software that automatically creates and chooses indices. | |||
Most modern databases systems that offer ISAM use a B-Tree as the back end for their system, IBM's ISAM and later VSAM (Virtual Storage Access Method) implementations do not and programming languages that offer ISAM implementations usually offer a simpler but more flexible systems. | Most modern databases systems that offer ISAM use a B-Tree as the back end for their system, IBM's ISAM and later [[VSAM]] (Virtual Storage Access Method) implementations do not and programming languages that offer ISAM implementations usually offer a simpler but more flexible systems. | ||
==Links | ==Links== | ||
Robert L. Bogue: [http://www.techrepublic.com/article/explore-the-differences-between-isam-and-relational-databases/ Explore the differences between ISAM and relational databases] - | Robert L. Bogue: [http://www.techrepublic.com/article/explore-the-differences-between-isam-and-relational-databases/ Explore the differences between ISAM and relational databases] - from TechRepublic | ||
[[Category: | [[Category:Access Method]] | ||
Latest revision as of 03:34, 20 October 2018
Indexed Sequential Access Method (ISAM) is a method for indexing data for fast retrieval that was originally developed by IBM for mainframe computers. ISAM allows database records to be accessed either sequentially as they were created or randomly via an index which in turn represents the same data in a different order. This is in contrast to a relational database that uses query optimising software that automatically creates and chooses indices.
Most modern databases systems that offer ISAM use a B-Tree as the back end for their system, IBM's ISAM and later VSAM (Virtual Storage Access Method) implementations do not and programming languages that offer ISAM implementations usually offer a simpler but more flexible systems.
Links
Robert L. Bogue: Explore the differences between ISAM and relational databases - from TechRepublic