Structure of DBMS

Structure of DBMS

Structure of DBMS-

DBMS plays important role between user and database.DBMS system giving data from user and store that data in to database and retrieve data to user as per user requirement. The DBMS structure indicating hows DBMS work for data storage.


Fig-Database Structure

In fig. describe the all parts and process about DBMS structure.DBMS structure mainly divide into 3 parts and they step by step.Each component described in detail below.

1. Application and End-user-

This is a front end tool display to user for communicating to user. user can interact with DBMS software from application.

2. DDL-

DDL also accept the request from user for processing.

3. DML compiler-

User select options from application for insert data, update data, search data and delete data. Each and every operation passes to DBMS with query. In DML compiler compile the queries requested from user.Here all DML queries converted into machine understandable format.

4. Query Optimizer-

Query Optimizer is totally responsible for executes query coming from DML compiler.

5. DDL Compiler-

DDL compiler work for DDL statements coming from user. DDL Compiler work for executing queries coming from user as a part of DDL.

6. Stored Data Manager-

Stored Data Manager is main part of DBMS . That observe the execution of  queries and also manages authentication,transaction of data,buffering transaction history. Stored Data Manager also maintain integrity and consistency of transactions. It is totally responsible to insert ,update,search and delete data from database.

7. Data Files-

It stores the actual data coming from user.

8. Data dictionary-

It stores a metadata about each data and transactions for future use.

9. Compiled DML-

Here stored a all query processes and DML statements execution data after query execute successfully.

MCQ on That Point     tcs


Best Luck

Amol Shinde

Amol Shinde

Work as Assistant Professor and Web Developer.

Leave a Reply

Your email address will not be published. Required fields are marked *