DBMS Functions

DBMS's perform several functions that guarantee the consistency and integrity of data in the database.

• Data Dictionary Management:
• The DBMS requires all the data elements and their relationships (metadata) to be stored in the data dictionary.(e.g. database structure)
• Data Storage Management:
•  The DBMS creates complex data structures that it uses to store data, data entry form, report definitions and data validation rules.
• Data Transformation and Presentation:
• Transforms entered data into a form that can be stored and retrieved from the physical complex data structures.
• Security Management:
• Security system to enforce user security and data privacy in a database.
• Multi-User Access Control:
•  Creates complex structures that allow multi-user access to the data.
• Backup and Recovery Management:
• Provides backup and recovery procedures to ensure safety and integrity.
• Data integrity Management:
• Enforces integrity rules to eliminate data integrity problems.
• Data Access Language and Application Programming Interfaces:
• Provides data access via a query language(e.g. SQL)
• DDL (Data Definition Language):Defines the structures where the data is to be stored.
• DML (Data Manipulation Language): Allows users to get data from the database.
• Database Communication Interfaces:
• Communication routines that allow access to the database over a network environment.(e.g. internet banking)