Definition
Data in the database must be stored, retrieved, and updated by a program module called a storage manager.
The following components can communicate with each other using the database's storage manager module:
Information Kept in the Database
The queries that application programs send to the system.
Components of Storage Manager
1. Authorization and Integrity Manager :
It verifies user authorization to access data as well as integrity constraints.
2. Transaction Manager :
It guarantees that until a transaction has been fully completed, no changes will be made to the database.
3. File Manager :
It controls the data structures that are used to represent the information saved on disk as well as the distribution of disk storage space.
4. Buffer Manager :
It determines whether data should be cached in main memory and then retrieves it from there. This is important because it establishes the maximum speed at which the database can be accessed.
Role of Storage Manager in DBMS :
1. Inventory control :
keeping an eye on inventory levels, making sure counts are exact, and making sure supplies are refreshed as needed.
2. Storage Organization :
Organizing the storage layout to maximize available space and make it easier to reach items.
3. Stock Issuing :
supervising the timely delivery of materials to various departments or clients.
4. Record-Keeping :
Maintaining thorough records of stock movements makes it easier to monitor the movement of items and prevent inconsistencies.
5. Stock Auditing :
To make sure stock levels correspond with records and to spot any problems or possible losses early on, conduct routine audits.
