12 Disadvantages Of Database Management System (DBMS)
12 Disadvantages Of Database Management System (DBMS) + PDF: DBMS is one of the best system to maintain records for Big firms and there are lots of advantages of Database Management System. But still it has some disadvantages that are listed and discussed below. At the end of this article, you will be given a free pdf copy of all these disadvantages of DBMS.
Also See: What is Database?
Disadvantages Of Database Management System + PDF
1. Increased Cost
a.) Cost of Hardware and Software
To store huge amount of data, one needs huge amount of space. Additionally, it will require more memory and fast processing power to run the DBMS. So, an expensive hardware and software will be needed that can provide all these facilities. As a result, old file-based system needs to be upgraded. These sophisticated hardware and software require maintenance which is very costly.
DBMS requires high initial investment for hardware and software. A significant investment based upon size and functionality of organization is required. Also, organization has to pay concurrent annual maintenance cost.
Also See: Features Of Database Management System
Sometimes you need a dedicated machine for better performance of database. These machines and storage space increase extra cost of hardware. Its Licensing, operations, and regulation compliance cost is also very high.
So overall, we can say that it is a very big disadvantage of DBMS
b.) Increased Cost of Staff
DBMS staff includes database administrator, application programmers, Database designers, System analyst and maintenance personals. All of these are highly educated and experienced in the field of DBMS. To get this level of experienced people, one needs to spend a lot of money. Also training of DBMS is very costly.
Also See: Types of Database Users in DBMS
c.) Cost of Data Conversion
Data conversion may require at any time and organization has to take this step. It is unbelievable that data conversion cost is more than the costs of DBMS hardware and machine combined. Trained staff is needed to convert data to the new system. It is a key reason that most of the organizations are still working on their old DBMS due to high cost of data conversion.
A DBMS fulfil lots of requirement and it solves many problems related to database. But all these functionalities make DBMS an extremely complex software. Developers, designers, DBA and End users of database must have complete skills of DBMS if they want to use it properly.
If they don’t understand this complex system then it may cause loss of data or database failure. As it requires lots of management, so its complexity becomes an issue and very big disadvantage of DBMS.
3. Technical staff requirement
Organizations have many employees working for them and these employees can perform many other tasks too that are not in their domain but it is almost impossible for them to work on DBMS.
A dedicated team of technical staff is required who can handle DBMS and as a result, company have to pay handsome salary to them too.
4. Database Failure
Data is the key for any organization, if data is lost then whole organization will collapse. And as we know that in DBMS, all the files are stored in single database so chances of database failure become more.
Any accidental failure of component may cause loss of valuable data. This is really a big question mark for big firms and they are continuously working to solve this issue.
5. Huge Size
DBMS is made to handle extremely huge data and queries, but due its complexity, DBMS has become huge in size. Also, it becomes bigger in size as data is fed in it. As a result, it requires lots of space and memory to run its application efficiently.
6. Currency Maintenance
Efficiency is the core need for any software, so it becomes must for DBMS to be current. Because efficiency can only be achieved if your system is current. Frequent updates, security measures and latest patches must be performed.
As new threats come daily, so DBMS requires to be updated on the daily basis. DBMS should be updated according to the current scenario.
7. Difficult backup And Recovery
Database is processed and handled by several users concurrently, so it becomes very difficult to get the exact state of database at the time of failure. It creates many problems and users get confused what to do next.
So, it is very difficult to take backup and recover the database as just one application program may pose serious problems.
8. Confidentiality, Privacy and Security
In DBMS, information is made available to users from remote locations and because it is centralized so chances of abuse are more often than in file-based system.
If information from the data centre gets corrupted then every user of the organization will be in a big trouble.
9. Data Integrity
As database is getting updated in the real time, so it is required that data remains accurate during operations. For that some technical safeguards are necessary. Several users attempting to update the data creates main threat to data integrity.
Also See: Examples Of Database Management System
10. Lower Efficiency
There are many software and application programs that are made only for one particular problem. But DBMS is a multi-use software that is used for many purposes and as a result it becomes less efficient.
Specialized software is more efficient because they are produced and optimized for one problem.
11. Increased Vulnerability
As DBMS is capable of many things because it is centralized, but at the same time centralization increases vulnerability. The whole system shuts down due to the failure of a single component.
This is very critical disadvantage of dbms for those organizations that are totally dependent of database.
Traditional files system was very good for small organizations as it gave splendid performance. But DBMS gives poor performance for small scale firms as its speed is slow and due that it is well suited for big firms.
Also Read: Explained Types and Classifications of DBMS
As we said that we will provide you a free pdf file of Disadvantages of DBMS, so link to download this pdf file is given below.
So these were the disadvantages of database management system (DBMS). If you liked them then please share them with your friends on facebook, twitter, google plus and pinterest.