Various Components of Database Management System (DBMS): The software of DBMS seems very complex and confusing. But if we look DBMS internally then it is just a combination of different modules having specific tasks. Each module of DBMS performs particular task and operation. DBMS fetches query from the user, works on it using different plans and produces results as the data fed in it. There are many user interfaces which are used by end users to make queries.
Also See: Examples of Database Management Systems
Let us discuss what are the main components and modules of Database Management System (DBMS) and what are their functions?
Various Components of Database Management System (DBMS)
Machine only understand low level language, so it is the task of query processor to convert user’s queries in the series of low level instruction. Then after, it sends these instructions to database manager for execution. There are various component of of query processor.
Also See: What is File Processing System?
DDL Complier: it records the ddl statements into set of tables containing data dictionary. It coverts ddl statement into object form from source form.
DML Complier: It converts DML statements into low level instructions that are more easy to understand by query evaluation engine.
Query Evaluation Engine: Queries generated by DML compiler are executed in Quesry evaluation Engine.
Database manager components issue the interface between low level data, application program and queries. It is responsible for the backup and recovery operations of database. Also it controls the consistency and integrity of data. Security is also performed by the database manager.
Authority and integrity manager: Authority manager is responsible for checking the authority of users to access and use information in database. Integrity manager check the integrity constrains like various keys (Primary, unique etc.)
Transaction manager: It ensures that transaction occurring currently completes without any problem.
File manager: The task of file manager is to ensure that file space is managed correctly. Also the allocation of disk space is managed by file manager.
Buffer Manager: It manages the data fetched from disk storage into main memory. Its task is to send blocks from disk to main memory.
There are following data structures are required by DBMS.
Data Files: These are the files that stored data base.
Data Dictionary: Data dictionary carries the data about data means it stores the meta data of data structure.
Access Acids: Acid properties are used to improve the performance of database management system. They make the search operations very fast.
Statistical Data: It stores some information that are used by query processor to choose the best way to execute queries.
So all these were the Various Components of Database Management System (DBMS). If you have any problem regarding this topic then please comment below.