3.2. Physical Storage Media

As discussed above, the data in database management system (DBMS) is stored on physical storage devices such as main memory and secondary (external) storage. Thus, it is important that the physical database (or storage) is properly designed to increase data processing efficiency and minimise the time required by users to interact with the information system.

Fig. 3.1. System of physically accessing the database

When required, a record is fetched from the disk to main memory for further processing. File manager is the software that manages the allocation of storage locations and data structure. It determines the ...

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

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