WHAT IS THE FUNCTION OF DBMS?

 FUNCTIONS OF DBMS: 

The major functions of DBMS are as follows:

 i) Data Definition: The DBMS defines the structure of the data in the application. These include defining and modifying the record structure. The type and size of fields and the various constraints/ conditions to be satisfied by the data in each field.

 ii) Data Manipulation: After defining the data structure data needs to be inserted, modified or deleted. 

iii)Data Security and Integrity: The DBMS contains functions which handle the security and integrity of data in the application. These can be easily invoked by the application and hence, the application programmer need not code these functions in his/her program. 

iv)Data Recovery and Concurrency: Recovery of data after a system failure and concurrent access of records by multiple users are also handled by the DBMS.

 v) Data Dictionary Maintenance: Maintaining data dictionary which contains the data definition of the application is also considered as one of the functions of DBMS. 

vi)Performance: Optimising the performance of the queries is one of the important functions of DBMS. Hence, it has a set of programs forming the query optimiser which evaluates the different implementation of the query and choose the best about them. Thus, the DBMS provides an environment that is both convenient and efficient to use when there is a large volume of data and many transactions to be processed.