August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...