There are many advantages and disadvantages of DBMS (Database Management System). Disadvantages of DBMS are explained as following below.
1. Increased Cost:
These are different types of costs:
- Cost of Hardware and Software –
This is the first disadvantage of database management system. This is because for DBMS, it is mandatory to have a high speed processor and also a large memory size because now a days there is a large amount of data in every field which needs to be store safely and with a security.
The requirement of these large amount of space and a high speed processor needs an expensive hardware and also an expensive software too. That is there is a requirement of sophisticated hardware and software which means that we need to upgrade the hardware which is used for file-based system. Hardware and Software, both requires maintenance which costs very high. All the operating, Training (all levels including programming, application development, and database administration), licensing, and regulation compliance costs very high.
- Cost of Staff Training –
Educated staff (database administrator, application programmers, data entry operations) who maintains the database management system also requires good amount. We need the database system designers to be hired along with application programmers. Alternatively the services of some software house need to be taken. So there is a lot of money which needs to be spent for developing software.
- Cost of Data Conversion –
We need to convert our data into database management system, there is a requirement of lot of money as it adds on to the cost of the database management system. This is because, for this conversion we need to hire database system designers whom we have to pay a lot of money and also services of some software house will be required. All this shows that a high initial investment for hardware, software and trained staff is required by DBMS. So, altogether Database Management System results in a costlier system.
As we all know that now a days all companies are using the database management system as it fulfils lots of requirement and also solves the problem. But a problem arises, that is all these functionality has made database management system an extremely complex software. For the proper requirement of DBMS it is very important to have a good knowledge of it by the developers, DBA, designers and also the end users. This is because if any one of them do not acquire a proper and complete skills than this may lead to data loss or database failure.
These failure may lead to bad design decisions due to which there may be a serious and bad consequences for the organization. So this complex system needs to be understood by everyone using it. As it cannot be managed very easily. All this shows that database management system is not a child’s game as it cannot be managed very easily. It requires a lot of management. A good staff is needed to manage this database at the times when it becomes very complicated to decide where to pick data from and where to save it.
3. Currency Maintenance:
This is very necessary to keep your system current because efficiency which is one of the biggest factor and need to be overlook must be maximised. That is we need to maximise the efficiency of the database system to keep our system current. For this, frequent updation must be performed on all the components as new threats comes daily. DBMS should be updated according to the current scenario. Also security measures must be needed. Due to advancement in database technology, training cost tends to be significant.
Traditional file system is written for small organizations and for some specific applications due to which performance is generally very good. But for the small scale firms, DBMS does not give a good performance as its speed is very slow. As a result some applications will not run as fast as they could. Hence it is not good to use DBMS for the small firms. Because performance is a factor which is overlooked by everyone. If performance is good than everyone (developers, designers, end users) will use it easily and it will be user friendly too as speed of the system totally depends on the performance and performance needs to be good.
5. Frequency Upgrade/Replacement Cycles:
Now a days in this world we need to stay up-to-date about the latest technologies, developments arriving in the market. Frequent upgrade of the products is done by the DBMS vendors in order to add new functionality to the systems. New upgrade versions of the software often come bundled. Sometimes these updates also need hardware upgrades. Sometimes these changes and updating are so fast that the users don’t feel it difficult to work with that system because it is not easy to learn new commands and understanding them again and again when the new upgrades are done. All these upgrades also costs money in order to train users, designers etc to use the new features.
- DBMS | Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- Need for DBMS
- Commonly asked DBMS interview questions | Set 1
- DBMS | How to test if two schedules are View Equal or not ?
- Commonly asked DBMS interview questions | Set 2
- DBMS | How to find the highest normal form of a relation
- DBMS | How to solve Relational Algebra problems for GATE
- DBMS | Concurrency Control -Introduction
- DBMS | Conflict Serializability
- DBMS | Nested Queries in SQL
- DBMS | Recoverability of Schedules
- Last Minute Notes - DBMS
- ACID Properties in DBMS
- DBMS Architecture 2-Level, 3-Level
- DBMS | Relational Model Introduction and Codd Rules
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.