9. DBMS Components

A DBMS has different parts that work together to store, process, and protect data.
Let’s look at three important components:

1. πŸ—„οΈ Storage Manager

  • It handles how and where data is stored.
  • Manages files, memory, and backups.
  • Keeps data safe and organized on the hard disk.

🟒 Example:
When you save student marks, the storage manager decides where to keep them and how to retrieve them later.

2. πŸ”Query Processor

  • It understands and runs user commands like SELECT or INSERT.
  • Converts user queries into actions the DBMS can perform.
  • Makes sure the right data is fetched or updated.

🟒 Example:
You type SELECT * FROM Students β€” the query processor finds and shows the student data.

3. πŸ”Transaction Manager

  • It keeps track of multiple operations happening at the same time.
  • Makes sure data stays correct and safe, even if something fails.
  • Supports ROLLBACK and COMMIT to undo or save changes.

🟒 Example:
If power goes off while updating marks, the transaction manager can undo the incomplete changes to avoid errors.

of DBMS (Database Management System ...