What is a file organization?which type are expression of file organization.
What is a file organization? Which is type of expression are file organization?
What is a file organization?
A database is a collection of interrelated records.The mechanism used to represent and store the record in a file is called the file organization.
File organization technique may be of following types:-
✍️Heap (Pile)file organization:-
The record are stored in available blank block as they arrive,i.e.records can be placed anywhere in the file where there is space for the records.
✍️ Sequencial file organization:-
The records are stored in sequencial order of key field.A sequencial file could be stored on a sequencial storage device such as magnetic tape.
✍️Indexed sequencial file organization:-
A retrieval of a record from a sequencial file requires on average access to half of the records in the file, making such queries very time consuming for large files.To improve the query response time of a sequencial file a type of indexing technique can be added.
Atul Raja Kujur
Comments
Post a Comment