Slideshow:
The case for storing data from different
relation in the same block
Reason:
|
Terminology: clustered file
Terminology: unclustered file
(Only when records from different files are often access consecutively)
- A block of a file can store:
- Records of the
same relation
(clustered file)
- Records of the different relations (unclustered file)
- Records of the
same relation
(clustered file)
- Clustered file:
- A file that stores
records of
one relation
- A file that stores
records of
one relation
- Unclustered file:
(less common)
- A file that stores
records of
multiple relation
- A file that stores
records of
multiple relation