FUNCTIONS OF
DATABASE
MANAGEMENT SYSTEM
Nicole Carlet
LEARNING OBJECTIVES
At the end of the session, you will be able to:
1. Enumerate the different functions of Database Management System; and
2. Discuss each function of Database Management System.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Dictionary Management
• Data Dictionary Management is the one of the most important
function of database management system. DBMS stores
definitions of the data elements and their relationships
(metadata) in a data dictionary. So, all programs that access the
data in the database work through the DBMS.
• Any changes made in a database structure are automatically
recorded in the data dictionary, thereby freeing you from having
to modify all of the programs that access the changed structure.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Data Storage Management
• One of the DBMS functionality is creating and managing the
complex structures required for data storage, thus relieving you
from the difficult task of defining and programming the physical
data characteristics.
• Data storage management is also important for database
performance tuning. Performance tuning relates to the activities
that make the database perform more efficiently in terms of
storage and access speed.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Data transformation and presentation
The DBMS transforms entered data in to required data structures.
The DBMS relieves you of the chore of making a distinction
between the logical data format and the physical data format. That
is, the DBMS formats the physically retrieved data to make it
conform to the user’s logical expectations.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Security Management
Security Management is another important function of Database
Management System (DBMS). The DBMS creates a security system
that enforces user security and data privacy. Security rules
determine which users can access the database, which data items
each user can access, and which data operations (read, add, delete,
or modify) the user can perform. This is especially important in
multiuser database systems.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Multi User Access Control
Multiuser access control is another important DBMS Function. To
provide data integrity and data consistency, the DBMS uses
sophisticated algorithms to ensure that multiple users can access
the database concurrently without compromising the integrity of
the database.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Backup and Recovery Management
• The DBMS provides backup and data recovery to ensure data
safety and integrity.
• Current DBMS systems provide special utilities that allow the
DBA to perform routine and special backup and restore
procedures. Recovery management deals with the recovery of
the database after a failure, such as a bad sector in the disk or a
power failure. Such capability is critical to preserving the
database’s integrity.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Data Integrity Management
• Data integrity management is another important DBMS function.
• The DBMS promotes and enforces integrity rules, thus
minimizing data redundancy and maximizing data consistency.
The data relationships stored in the data dictionary are used to
enforce data integrity. Ensuring data integrity is important
DBMS functionality in transaction-oriented database systems.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Database Access Languages and Application Programming
Interfaces
The DBMS provides data access through a query language. A query
language is a non -procedural language—one that lets the user
specify what must be done without having to specify how it is to be
done.
Structured Query Language (SQL) is the de facto query language
and data access standard supported by the majority of DBMS
vendors.
FUNCTIONS OF DATABASE MANAGEMENT
SYSTEM
Database Communication Interfaces
Current-generation DBMS's accept end-user requests via multiple,
different network environments. For example, the DBMS might
provide access to the database via the Internet through the use of
Web browsers.
THANK YOU FOR
LISTENING!