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 ...