Index Concept
Main idea: A separate data structure used to locate records
Many, many, many, many flavors of index organization have been proposed and tried
- including structures which combine hashing and indexing
- Various buffering schemes are somewhat orthogonal
We’ll focus on
- General concepts [chapter 4.3-4.4]
- ISAM (indexed sequential) [ch. 5.1]
- B-trees and B+ trees [ch.5.2-5.8]