Chapter 1 (English)

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.