February 02, 2020
Amitraj
File -
A file is a sequence of records stored in binary format. 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.
OR
A file is named collection of related information that is recorded on secondary storage such as magnetic disks, magnetic tables and optical disks.
File Organization -
-> 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.
-> Files of fixed length records are easier to implement than the files of variable length records.
Advantages of File Organization -
1. Easy record adding/update/removal, without disrupting.
2. Storage efficiency.
3. Fast access to single record or collection of related records.
4. Redundancy as a warranty against data corruption.
Objective of file organization
1. It contains an optimal selection of records, means records can be selected as fast as possible.
2. For the minimal cost of storage, records should be stored
efficiently.
3. To perform insert, delete or update transaction on the records should be quick and easy.
4. The duplicate records cannot be induced as a result of insert, update or delete.
Types Of File Organization -
There are various methods have been introduced to Organize files. These particular methods have advantages and disadvantages on the basis of access or selection. In the file organization, the programmer decides the best-suited file organization method according to his requirement.
We have six types of file organization to organize file records -
Click on the links of various file organization:-
1. Sequential file organization
A file is a sequence of records stored in binary format. 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.
OR
A file is named collection of related information that is recorded on secondary storage such as magnetic disks, magnetic tables and optical disks.
File Organization -
-> 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.
-> Files of fixed length records are easier to implement than the files of variable length records.
Advantages of File Organization -
1. Easy record adding/update/removal, without disrupting.
2. Storage efficiency.
3. Fast access to single record or collection of related records.
4. Redundancy as a warranty against data corruption.
Objective of file organization
1. It contains an optimal selection of records, means records can be selected as fast as possible.
2. For the minimal cost of storage, records should be stored
efficiently.
3. To perform insert, delete or update transaction on the records should be quick and easy.
4. The duplicate records cannot be induced as a result of insert, update or delete.
Types Of File Organization -
There are various methods have been introduced to Organize files. These particular methods have advantages and disadvantages on the basis of access or selection. In the file organization, the programmer decides the best-suited file organization method according to his requirement.
We have six types of file organization to organize file records -
Click on the links of various file organization:-
1. Sequential file organization
2. Heap (unordered) file organization
3. Hash (Direct) file organization
4. B+ tree file organization
5. Indexed sequential access method (ISAM)
6. Clustered file organization
