Question

List the components of storage manager.

Answer 1

A storage manager is a program module that is responsible for storing, retrieving and updating data in the database.

Following are the components of the storage manager;

1. Authorization and Integrity Manager: It tests integrity constraints and verifies user authorization to access data.
2. Transaction Manager: It ensures that no kind of change will be brought to the database until the transaction has been completed in total.
3. File Manager: It manages disk space allocation and the data structures used to represent information on disk.
4. Buffer Manager: It decides which data is in need to be cached in the main memory and then fetch it up in main memory. This is very important as it defines the speed at which the database can be used.