Structure of Database Management System

Database Management System (DBMS) is a software that allows access to data stored in a database and provides an easy and effective method of – 

 

  • Defining the information.
  • Storing the information.
  • Manipulating the information.
  • Protecting the information from system crashes or data theft.
  • Differentiating access permissions for different users.

The database system is divided into three components: Query Processor, Storage Manager, and Disk Storage. These are explained as following below. 

Figure – Structure of DBMS

1. Query Processor : 
It interprets the requests (queries) received from end user via an application program into instructions. It also executes the user request which is received from the DML compiler. 
Query Processor contains the following components – 
 

  • DML Compiler – 
    It processes the DML statements into low level instruction (machine language), so that they can be executed. 
     
  • DDL Interpreter – 
    It processes the DDL statements into a set of table containing meta data (data about data). 
     
  • Embedded DML Pre-compiler – 
    It processes DML statements embedded in an application program into procedural calls. 
     
  • Query Optimizer – 
    It executes the instruction generated by DML Compiler. 
     

2. Storage Manager : 
Storage Manager is a program that provides an interface between the data stored in the database and the queries received. It is also known as Database Control System. It maintains the consistency and integrity of the database by applying the constraints and executes the DCL statements. It is responsible for updating, storing, deleting, and retrieving data in the database. 
It contains the following components – 
 



  • Authorization Manager – 
    It ensures role-based access control, i.e,. checks whether the particular person is privileged to perform the requested operation or not. 
     
  • Integrity Manager – 
    It checks the integrity constraints when the database is modified. 
     
  • Transaction Manager – 
    It controls concurrent access by performing the operations in a scheduled way that it receives the transaction. Thus, it ensures that the database remains in the consistent state before and after the execution of a transaction. 
     
  • File Manager – 
    It manages the file space and the data structure used to represent information in the database. 
     
  • Buffer Manager – 
    It is responsible for cache memory and the transfer of data between the secondary storage and main memory. 
     

3. Disk Storage : 
It contains the following components – 
 

  • Data Files – 
    It stores the data. 
     
  • Data Dictionary – 
    It contains the information about the structure of any database object. It is the repository of information that governs the metadata. 
     
  • Indices – 
    It provides faster retrieval of data item. 
     

 

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Recommended Posts:


    Check out this Author's contributed articles.

    If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

    Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.



    Improved By : itskawal2000

    Article Tags :
    Practice Tags :


    2


    Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.