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.
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.
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
0 of 5 questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 5 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
Question 1 of 5
1. Question1 points
_____plays important role between user and database.Correct
Question 2 of 5
2. Question1 points
This is a ____tool display to user for communication to userCorrect
Question 3 of 5
3. Question1 points
DBMS structure mainly divide into ___part.Correct
Question 4 of 5
4. Question1 points
______also accept the request from user for processing.Correct
Question 5 of 5
5. Question1 points
Where all_____queries converted queries converted into machine understandable format.Correct