3.5. File Organisation

A file organisation in a database system essentially is a technique of physical arrangement of records of a file on secondary storage device. It is a method of arranging data on secondary storage devices and addressing them such that it facilitates storage and read/write (input/output) operations of data or information requested by the user. The organisation of data in a file is influenced by number of factors that must be taken into consideration while choosing a particular technique. Some of these factors are as follows:

  • Fast response time required to access a record (data retrieval), transfer the data to the main memory, write record and or modify a record.

  • High throughput.

  • Intended use (type of application).

  • Efficient ...

Get Database Systems: Concepts, Design and Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.