What is DBMS?
DBMS is a Data Base Management System. It is system software that is mainly used for managing and creating the database is basically known as “DBMS”. There is some software that is used in DBMS for managing or creating the database example: Oracle, MySQL, Amazon RDS, Postgre SQL, etc., and many other software.
Let me clear this with a simple example: suppose you want to go for a trip of Dubai (from India to Dubai), now what should you do for going to Dubai? It’s simple you’ll apply for the visa and book the plane ticket and you are done that’s it. So if we talk about the plane ticket booking process then there is a two-way 1) you booked the plane ticket by yourself or 2) if you don’t know how to book then you’ll get your plane ticket booked by someone else like from a cyber cafe or from your friends etc. is depending on your choice. Let’s suppose you want to book your plane ticket by yourself, so to book the plane ticket you go to the play store and download the best plane ticket booking application like MakeMyTrip, Goibibo, EaseMyTrip, etc whatever your preferences then you try login the app by entering your username and password then you select the plane, price and then you paid it. After that, you get the PDF of your plane ticket to print.
The process you did from logging into the app to the payment of your ticket booking process is done only via with the help of “DBMS”. Because DBMS did your data secure and manage it into the database of that application where you did your plane booked. When you go to sit on the plane, then the employees there will check your identity, check your ticket, etc. All the verification is done only with the help of DBMS because your data is already stored in the database which tells those employees whether your data is correct or not.
If it is correct then you’re welcome to sit on the plane, if not then you are not able to enter into the plane.
I hope you understand what DBMS is. Now, let’s see the advantages and disadvantages of DBMS.
Advantages of DBMS
- It hides the data which is not useful for the user: DBMS helps the user to provide those data which is useful only for the user and the rest of the useless data it hides from users.
- It controls the multiple data: Well In a database there are so many multiple copies of the same data, so the DBMS helps to control all the multiple data and maintain it in a single database file.
- It minimized the Data Inconsistency: In a DataBase there are some files that have different-different information of different-different users, so the DBMS helps to minimize the particular data for a particular person.
- DBMS gives faster data access: It provides a faster access experience when you tried to fetch your details from the database then it can complete providing your details within milliseconds.
- It provides data security and privacy: There is so much data available in a single database so the DBMS helps to provide us the security that no one can get access to our data easily and hiding the details of our data from other to provide privacy.
- It provides Data Backup & Recovery: If in case our data can be lost from the database so the DBMS helps to provide the backup of our all data and restore it to the database.
- Easy to Share Data: Well the DBMS provides security and privacy so that no one can get access to our data but it also provides the functionality to share data with others if the user wants to share their data with others.
Disadvantages of DBMS
- DBMS requires annual maintenance costs to manage the database: It is costly to manage the database because there is the cost of software and hardware for the DBMS to maintain that’s why it requires Annual Maintenance Costs for managing the database.
- Sometimes the DataBase gets failed: It means sometimes the database can get failure because of a high load of data access and for another reason, if it got failed then we are not able to get access to our data.
- Performance is not good in small databases: Small databases use only by small firms so if our data are stored in this database then the performance of getting access to our data is too late.
- Because of huge data, it creates some problems: If the user has a large amount of data in the database then it creates some issues to provide the actual data to the user.
- Not easy to manage DBMS: well there is a database that is managed by the DBMS so the DBMS is managed by the database administrator, but the problem is it is not easy to manage because it is complex, to manage the DBMS then it requires some technical skill to learn other non-technical managers can not able to manage it properly.