Middle
What components of a relational DBMS do you know?
sobes.tech AI
Answer from AI
The main components of a relational DBMS include:
- Storage Engine — responsible for physical storage and management of data on disk.
- Transaction Manager — ensures atomicity, consistency, isolation, and durability (ACID) of operations.
- Query Optimizer — analyzes SQL queries and constructs the optimal execution plan.
- SQL Query Processor — parses, checks, and executes SQL queries.
- Lock Management System — provides correct concurrent access to data.
- Data Catalog (Metadata) — stores information about the database structure, tables, indexes, and access rights.
- Indexes — data structures to speed up search and retrieval.
These components together ensure efficient storage, processing, and protection of data.