Explain Components of DBMS
Components of DBMS:
The basic components of DBMS are:
1. Database Engine: It is the heart of DBMS. It is responsible for storing, retrieving and updating the data. This component is also responsible for the speed (performance) and scalability of a database.
2. Data Dictionary: A data dictionary is a database about database. It holds all information about each data element in the databases such as its name, data type, range of values, source, and access authorization. It indicates the application programs which use the data item.
The data dictionary may be a stand-alone information system used for management and documentation purposes. It may be an integral part of the database management system. The data dictionary is also known as metadata.
3. Query Processor: It is a functional component of a database management system whose function is to break down query (SQL) statements into instructions understood by the DBMS and which helps the database system access and update the data.
4. Security and Other Utilities: DBMS must be responsible for establishing and maintaining security access controls. The security component of DBMS must identify the user and then provide or limit access to various parts of the database.
Various administrative utilities such as backup and recovery, user management, data storage evaluation and performance monitoring tools are provided with most of the DBMS.