The database management system (DBMS) software is divided into several components. Each component will perform a specific operation. Some of the functions of the DBMS are supported by operating systems. • DBA − The Data Base Administrator (DBA) responsibility is to create the DBMS structure and have the ability to control the structure. • Application Programs − It is used to create the records, change and update the records. It is mainly useful in designing the interface. • DML processor − Data Manipulation language, it is helpful to update data, manipulate data based on user request, checks according to syntax of SQL. • DDL Processor − Data Definition language checks the structure of the database. • Data Dictionary − Store all the queries. • Integrity Checker − Here data is stored which is designed by Database administrator. • Buffer manager − Buffer manager performs storage management operation. • Recovery manager − Recovery manager recovers the data from main memory and manages the log files or recovery files. • Query processor − Query processor processes the query coming from the user side

Dency Varghese

219 resources

0

2

0

Like