However, if we want to retrieve all employees whose marks are in a certain range, a file is ordered by employee name would not be a good file organization. Sorting the file by employee name is a good file organization. It is used to determine an efficient file organization for each base relation.įor example, if we want to retrieve employee records in alphabetical order of name. It helps to increase the efficiency of disk design than tape.įile organization ensures that records are available for processing. File volatility addresses the properties of record changes. There are two important features of file:įile activity specifies percent of actual records which proceed in a single run. The file size is limited by the size of memory and storage medium. 6.1 Files: C oncept, N eed, P rimitive O perationsįile is a collection of records related to each other.
