Advantages And Disadvantages Of Database Management System

A database management system is a collection of programs that allow users to create and maintain a database. Even though there are numerous advantages for using database management systems, there are a few disadvantages. Such disadvantages include complexity, size, performance, and the associated costs of a database management system. The advantages of a database management system outweigh the disadvantages, but one should understand the disadvantages to ensure they have a complete understanding of the system.

First, database management systems can be very complex and difficult to understand. The designers and the end users must have the necessary skills in order for them to use it properly. The database designers need to have the SQL coding knowledge to properly write the database software. Not only do they have to know SQL coding, they will have to learn the altered version of SQL the database management software might use. The end user will need the understanding of how to run queries, generate reports, and update the database if their security level allows.

In addition to the complexity of the software, the hardware required can be complex. Most modern day database management systems require a mainframe to house the database management

Depending on the size of the database, a large mainframe and terminal system could cost in the hundreds of thousands of dollars or millions of dollars. The mainframe required could have the extreme processing power and allotted memory compared to most personal computers. This makes the mainframe an expensive piece of equipment, and a large investment for most companies. The maintenance of the mainframe and database system could be costly in itself. The maintenance of the mainframe involves replacing defective or near defective parts, which will ensure the database’s uptime is for as long as