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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.