Disadvantages and Advantages of DBMS

Disadvantages of DBMS 

Though DBMS has many advantages, it has some disadvantages too. 

  • One of the most apparent disadvantage is its cost. A DBMS does pay in the long run but its initial investment is quite high. The hardware has to be upgraded so that the programs and extensive data can be executed and stored. 
  • Redundancy is reduced to a great extent in a DBMS, but lack of duplication requires that the database is adequately backed up so that in case of any failure this backup data can be used by the system. Also, in a DBMS recovery and backup procedures are fairly complex. 
  • Despite these disadvantages, there are a number of advantages of a DBMS because of which they are extremely popular.

Disadvantages of DBMS 

  • It's Complexity 
  • Except MySQL, which is open source, licensed DBMSs are generally costly
  • They are large in size

Advantages of Database: 

Using a DBMS to manage data has many advantages: 

Data independence: 

Application programs should be as independent as possible from details of data representation and storage. The DBMS can provide an abstract view of the data to insulate application code from such details. 

Efficient data access: 

A DBMS utilizes a variety of sophisticated techniques to store and retrieve data efficiently.

Data integrity and security: 

If data is always accessed through the DBMS, the DBMS can enforce integrity constraints on the data. The DBMS can enforce access controls that govern what data is visible to different classes of users. 

Data administration: 

When several users share the data, centralizing the administration of data can offer significant improvements. Experienced professionals, who understand the nature of the data being managed, and how different groups of users use it, can be responsible for organizing the data representation to minimize redundancy and for fine-tuning the storage of the data to make retrieval efficient. 

Concurrent access and crash recovery: 

A DBMS schedules concurrent accesses to the data in such a manner that users can think of the data as being accessed by only one user at a time. Further, the DBMS protects users from the effects of system failures. 

Reduced application development time: 

Clearly, the DBMS supports many important functions that are common to many applications accessing data stored in the DBMS. This, in conjunction with the high-level interface to the data, facilitates quick development of applications. Such applications are also likely to be more robust than applications developed from scratch because many important tasks are handled by the DBMS instead of being implemented by the application.

"Disadvantages And Advantages Of DBMS"

"Explain Advantages And Disadvantages Of DBMS"

"What Is The Role Of A DBMS And What Are Its Advantages What Are Its Disadvantages"

"Advantages And Disadvantages Of DBMS"

"What Are The Advantages And Disadvantages Of Hierarchical DBMS"

"Advantages And Disadvantages Of DBMS In Tabular Form"

"Advantages And Disadvantages Of DBMS"

"Disadvantages Of File System And Advantages Of DBMS"