Data Base Management System is a central repository where it is stored in structured formats. It includes tables, views, indexes, and other objects accordingly

DBMS Engine: The core component responsible for managing data storage, retrieval, modification, and security. It interprets and executes queries, handles concurrency control, and ensures data integrity consequently

Query Processor: Accepts user queries written in SQL (Structured Query Language) and translates them into an execution plan that the DBMS engine can understand and execute efficiently.

Data Definition Language (DDL) Compiler

Parses and executes DDL statements to define, modify, or remove database objects such as tables, views, indexes, and constraints consequently

Data Manipulation Language (DML) Compiler in Data Base Management System

Processes DML statements (e.g., SELECT, INSERT, UPDATE, DELETE) to retrieve, insert, modify, or delete data within the database.

Transaction Management

Ensures ACID properties (Atomicity, Consistency, Isolation, Durability) for database transactions. It manages concurrent access to data and ensures that transactions are processed reliably consequently

Concurrency Control

Prevents data corruption and ensures data consistency by managing concurrent access to shared data by multiple users or processes consequently

Database Utilities Data Base Management System

Tools for managing and maintaining the including backup and recovery utilities, data import/export tools, and database monitoring utilities consequently

Security and Authorization

Controls access to the database and its objects by enforcing user authentication, authorization, and auditing mechanisms to ensure data confidentiality and integrity accordingly

Data Dictionary

Stores metadata, including information about the database schema, data definitions, constraints, permissions, and relationships between database objects accordingly

Concurrency Control and Transaction Management:

• DBMS ensures data consistency and integrity by managing concurrent access to shared data by multiple users or processes accordingly
• It implements transaction management mechanisms to maintain ACID properties (Atomicity, Consistency, Isolation, Durability) and ensure reliable data processing consequently

Security and Access Control Data Base Management System

• DBMS enforces security measures to control access to the database and its objects, including authentication, authorization, and auditing mechanisms.
• It supports role-based access control (RBAC), encryption, and data masking to protect sensitive information from unauthorized access or tampering consequently