Advantages, Disadvantages of the database management system
In this tutorial, we will try to learn the “Advantages, Disadvantages of the database management system”.
Disadvantages of the database management system
The database management system is commonly called DBMS. DBMS has a big list of advantages. Similarly, there are multiple disadvantages to the database management system. some of the most common disadvantages are mentioned below;
Expensive technical staff
if you want to maintain a database management system for you are office our organization, then it’s not that simple task. you need to hire a well educated and Technical database administrator for maintaining the database management system.
Cost
We need to buy expensive hardware, software and highly paid technical database administrator.
Complexity
database systems are not very easy, database systems are complex. there are many Complex relationships among tables. Physical schema of the databases are not very easy to understandable
The extra cost of hardware
We need to buy expensive, Reliable, and efficient storage devices to store the data.
size
Initially, database size is not a big size but when we store a large amount of data, then the size of the database increases. A big database can create a lot of problems. for example when the date of the database increases too much then the delay time of the result of the database queries can be increased.
Database failure
chances of database failure can be very high.
Cost of data conversion
The cost of data conversion is very high. Train staff and train database administrators required for converting the data smoothly.
Performance
Database Performance is must required in big organizations to win the market, but in Small organization performance of databases is not ideal.
Advantages of the database management system
There are many advantages of database management system point some of these advantages are mentioned below;
Data sharing is improved with the DBMS
Data can be very efficiently stored in the DBMS. as we are discussing that data is efficiently stored in DBMS ok, so we can say that data sharing is improved with the help of a database management system. before database management system it was very tough to share the data. data sharing was a big problem in the past. now, the database management system solves this problem.
Data security is improved with DBMS
we can simply store the email addresses and passwords of the users in the database and then we can authenticate a user with the help of those email addresses and passwords point date a skirt is improved with the help of database management systems
Reliable data integration
suppose we have data in different tables are in different databases. still, we can integrate the data very efficiently and in reliable wa.y
Data redundancy reduction
Data redundancy is minimized with the help of database normalization.
Data inconsistency reduction
Data inconsistency is minimized with the help of of database normalization.
Improve decision making
We can mind the data and get useful results from the data. these results help us to improve our business.
Overall increase the productivity of the end user
With the help of database management systems, the overall productivity of the end user is increased abstraction level layers in the database system makes it really easy.