Components that Make DBMS
There are three components that make up the Database Management System. They are:
- Query Processor: As the name suggests basically works on the user’s query. It executes and interprets the query. The sub-components of a Query Processor include a DDL interpreter, DML Compiler, Embedded DML Compiler, and Query Optimizer.
- Storage Manager: also known by the name of Database Control System, is a program that connects the data present in the database and the queries provided by the user. The different components of a Storage Manager are the Authorization Manager, Integrity Manager, Transaction Manager, Buffer Manager, and File Manager.
- Disk Storage: focuses on the physical level. It ensures that the data is saved even when the system shuts down. The further sub-divisions of Disk Storage include Data Files, Data Dictionaries and Indices
From the above three components, it is seen that Authorization and Integrity Manager are part of Storage Manager.