FUNCTIONS OF DBMS

A dbms provides several important functions to users they are listed below

1.data security management

2.data dictionary management

3.data storage management

4.data intigrity management

5.backup and recovery management

6.multiuser access control

7.database communication interfaces

8.database access languages

The each of the above function is explained in below in detail

1.Data security management:

• The dbms providesasecurity system gives gives security and data privacy

• The security rules specifies the accesability of the user

• Which user can access and alter the data in the database

• which data operations can perform by them like read write ,modify,update, delete the data from the database

2.Data dictionary management:

• The dbms stores the meta data /data elements definitions inadata dictionary
• The dbms uses data dictionary to lookup the required data components structures and relation ships
• Additionally any modifications done by database structure are automatically recorded in the data dictionary

3.Data storage management:

• The DBMS allows the user to store the data in the database
• The dbms actually stores the database in multiple physical data files
• It provides storage for not only the code but also several related dataentry forms or reports ,code data validation code structures to handle video&picture formats

4.Data integrity management:

• The dbms strictly promotes the integrity rules

• That gives the minimizing data redundancy& maximizing data consistancy

• The data relationships stored in the data dictionary are used to enforce data integrity

5.Backup and recovery management:

• The dbms provides the data backup and recovery to ensure data safety&integrity
• The modern dbms provides special utilities that allowsthe database administrator to perform special backup & restore procedures

6.Multiuser access control:

• The dbms allows multiple users atatime to access the data in the database
• The dbms uses complex algorithams to ensure that the multiple users can access the database concurrently with out compramising the integrity of the database

7.Database communication interfaces:

• The modern dbms accepts the end user requests through multiple different network environments
• The dbms might provide database access through browsers by using internet
• In this environment communications can be accomplished in many different ways

8.Database access languages:

• The dbms provides data access througha query language

• It is a non procedural language which allows the user to specify what must be done with out having to specify how it is to be done

• dbms programming interfaces to c and java also provides application languages