The Database Management System (DBMS) is defined as a software system that allows the user to define, create and maintain the database and provide control access to the data.
It is a collection of programs used for managing data and simultaneously it supports different types of users to create, manage, retrieve, update and store information.
A small startup company and industries managing a huge amount of data becomes a mess. So, software like DBMS brought a revolution in many fields regarding efficient information management.
It is basically a set of programs which allow users to store, modify or update, and retrieve information from the database as per the user requirements.
DBMS also provides security and protection to databases. It acts as a middle layer between the database and user.
The different types of DBMS are My SQL, Oracle, MYSQL Server, Microsoft Access, SQL, DB2 etc.
Functions of DBMS
The functions of DBMS are explained below −
The motive behind the development of the DBMS is to manage the information as a whole.
Its main objective is to make the data easily accessible, rapid, less costly and flexible for its users.
It removes the duplication of data and minimizes data redundancy.
The extra space covered by duplicate data is used for other purposes and there is no wastage of space.
The DBMS is easy to use and learn.
DBMS packages are user-friendly and flexible.
There is data independence because the user can do changes at any level of the database without impact on other levels like hardware and software processes.
DBMS is economically good for everyone.
Anyone can use, store and manipulate data at an affordable price.
It can be accessible by multiple users and helps to recover data in case it is not saved by the user. The system can easily recover the data in no time and it maintains accuracy and integrity.
It prevents unauthorized access to the data and the data remains private. Through centralized control, DBMS makes it sure that proper security is provided to the data.
It is useful for retrieving, analyzing and storing the data.
The diagram given below depicts the working of a DBMS −