Functions and service of DBMS

 Functions and service of DBMS :- 

A DBMS performs several important functions that guarantee integrity and consistency of data in the database. Most of these functions are transparent to end users. There are the following important functions and services provided by a DBMS.

1. Data storage management :- It provides a mechanism for management of permanent storage of the data. The internal schema defines how the data should be stored by the storage management mechanism and the storage manager interfaces with the operating system to access the physical storage. 
2. Data Manipulation management :- A DBMS furnishes users with the ability to retrieve, update and delete existing data in the database. 
3. Data Definition services :- The DBMS accepts the data definitions such as external schema, the conceptual schema, the internal schema and all the associated mapping in source form. 
4. Data dictionary/system catalog management :- The DBMS provides a data dictionary or system catalog function in which description of data items are stored and which is accessible to users. 
5. Database communication interfaces :- The end- user's request for database access are transmitted to DBMS in the form of communication messages. 
6. Authorization/security management :- The DBMS protects the database against unauthorized access, either international or accidental. It furnishes mechanism to ensure that only authorized users an access the database. 
7. Backup and recovery management :-  The DBMS provides mechanism for backing up data periodically and recovering from different types of failures. This prevents the loss of data. 
8. Concurrency control service :- Since DBMS supports sharing of data among multiple users, they must provide a mechanism for managing concurrent access to the database. DBMS ensure that the database kept in consistent state and that integrity of the data is preserved. 
9. Transaction management :- A transaction is a series of database operations, carried out by a single user or application program, which accesses or change the contents of the database.