Based on the relational data model, the structure of a typical DBMS Architecture is depicted in the following figure.
Explanation of DBMS Architecture
The query evaluation plans are created by the DBMS, which receives SQL commands from various user interfaces, executes them against the database, and delivers the results.
When a user submits a query, it is processed and routed to a query optimizer, which creates an effective execution plan for the query’s evaluation.
An execution plan serves as a guide for assessing a query.
The file and access methods layer facilitates the idea of a file, a group of pages, or entries in a database management system.
The buffer manager retrieves pages from the disk and loads them into main memory in response to read requests.
The lowest tier of the database management system software handles the management of disk space, which is where the data is kept.
Concurrency control and recovery-related DBMS components include:
The transaction manager schedules the execution of transactions.
The lock manager tracks requests for locks and grants.
The recovery manager monitors events after a crash to ensure that the system can be restored to its pre-crash state.
