SSCA1030 Lecture Notes - Unique Key, Knowledge Base, Data Redundancy
Document Summary
The file is a collection of records. Using the primary key, we can access the records. The type and frequency of access can be determined by the type of file organization which was used for a given set of records. File organization is a logical relationship among various records. This method defines how file records are mapped onto disk blocks. File organization is used to describe the way in which the records are stored in terms of blocks, and the blocks are placed on the storage medium. The first approach to map the database to the file is to use the several files and store only one fixed length record in any given file. An alternative approach is to structure our files so that we can contain multiple lengths for records. Files of fixed length records are easier to implement than the files of variable length records.
