The database management system serves as the knowledge base for an application. Without this database, many applications will have absolutely no value. Also, the data that is generated in a week is equivalent to the data that has been generated in the last decade. So the database management system plays a significant role in managing the data. Some various advantages and disadvantages are related to the database management system.
Advantages of Database Management System
The meaning of data abstraction is to hide the complexity of data from basic users. The DBMS provides the data to the user in an abstracted form or it removes the data that is not useful to the user and only serves the data that is required by the user.
For example, there is a hospital database where the records of the patients, doctor, staff, routine expense, etc. are stored. The doctor will only require the record of the patient – his name, his background, etc. and he will not want to see what the routine expense of the hospital is. And the same will follow with the finance department that they will require the routine expense but not the patient’s information. So to provide only useful data to its users is the responsibility that is fulfilled by the database by locking the not used data from one user and granting access rights to the useful data.
Controlling Data Redundancy
The meaning of the data redundancy is that there may exist many copies of the same information. The work of the DBMS is that it can control the existence of these multiple data and integrate each of them in a single file. Also, data redundancy leads to wastage of the database resources such as space and even processing power, as it will have to perform the same function over the same data again increasing the processing time.
For example, In an excel sheet, one can have the same person’s name stored with similar information in more than one row because he might have visited the store again and his purchase is stored now with his name in a new row and the previous purchase has been in the other row. This is creating the data redundancy and the same information can be stored in the same row with the update without increasing the number of the row.
Controlling the data inconsistency
Data inconsistency occurs when the database file contains different information for a particular person or object. When the update occurs in one file and by mistake, the update was not made in the second file with similar information, then data inconsistency occurs.
For example, you may have to calculate the total marks and position of all students in a class and you make two separate excel files for that. There may be a student whose marks were increased in one subject and you made the update in one file but forgot to do the same in the second file and calculated the position as well as the marks. In this case, the data is not only inconsistent in both the file but also your result will become wrong, to avoid this DBMS offers features to control the data inconsistency.
Concurrent Access of the Data
The database management system allows multiple users to access and update the data simultaneously. The database due to this reason can result in inconsistency due to concurrent updates by multiple users. To improve the performance of such database involvement and to guard the database against such anomaly, the database management system performs supervision through the use of some protocols such as Lock Base protocol, time-stamp based protocols, etc.
The database management system maintains different levels of access authorization in every database. The authorization access determines which user can update the data or which user can only read or other functions. All these are achieved with the help of Database Management Tools such as using the login ID of the user for granting permissions.
Disadvantage of Database Management System
DBMS software is not like the excel file processing system that will only require the application program to run on a windows machine. DBMS software can perform complicated tasks of running a program and depending on the program design and the information in the database, we will require the right hardware to store and process that data and that comes at great expense. For example, maintaining a data center.
When the data from the file processing system such as an excel sheet has to be transferred into the database system like MySQL the cost of this replacement is time-consuming.
Training the Staff
The Database Management system is not simple like operating a file processing system and this requires some level of expertise on the software, and so the training is required for the users of the database. This need for training of the users has to be taken care of by the organization and the organization may have to pay a lot of amounts to train its staff to run software of DBMS.