Database management system is the software and collection of the program which is used to create, manipulate, retrieve and delete databases.
DBMS is a system that has a collection of operations that helps users to perform operations like (Updation, Insertion, Deletion, etc.) in an easy way within the database. It provides easiness to the users. “DBMS serves as an interface or mediator between end-users and the database. So that the data is organized in a defined and well-designed way and can be easily accessed”. DBMS has basically four components. These components are as follows:
Components of DBMS
- Hardware
- Software
- Database
- Users
1). Hardware
The physical structure of our computer system comes from the hardware component of DBMS which is used to store programs and databases.
The hardware component of DBMS is also divided into two parts
a). Processors: These come under the primary memory section of the hardware that is used to store the programs that help to perform the operations of DBMS and other processes. The smoothness of operations depends upon these processors.
b). Secondary storage: It is a type of secondary memory that stores information (processed data). It is used as a storage device for storing records. Examples: HDD, SSD, etc.
2). Software
In this component our actual DBMS software is present. We need software that is capable to perform all types of operations like Insertion, deletion, and updation, in the database. These types of operations are performed by end-users of the database. We can also say that DBMS is the manager of the database in the form of software.
The DBMS software is located between the database and the end-users.
3). Database
A database is a place where all the information or related data are present in an organized way. So the information is accessible, manageable, and can be updated easily. In databases, we don’t know about the actual structure of data storage, but we assume that in related databases, data are stored in tabular form. So, In the related database, we can get the desired information quickly and easily.
4). Users
In DBMS, there are many users who access the data according to their needs. The capacity and needs of each user vary from each other.
It consists of the following users
a). Database administrator: Database administrators are those people or users who have the responsibility for all the operation that is executed within the database. It manages the data and procedures.
b). Database designers: These are the people who design a database’s best structure that makes a database more reliable and easy to execute any operations on it.
c). End-users: End users are those people which actually want to access the data present in the database. They can insert some data or delete some data or update some data. These users are unaware of the structure and programs within the database.
d). Application programmers: These are those types of users that can make changes in the programs of DBMS software. They are just working on the performance of the DBMS software.