Disadvantages of Database management system (DBMS)
Database Management System
A Database
Management System (DBMS) is a computerized system that enables users to create
and maintain a database. The DBMS is a general purpose software system that
facilities the process of defining, constructing, manipulating, and sharing
database among various users and applications.
We will
call the database and DBMS software together a database system.
{tocify} $title=
{Table of Contents}
Disadvantages of Database Management System (DBMS)
- Complexity of Backup and Recovery
For a centralized shared database to be accurate and available all times, a comprehensive procedure is required to be developed and used for providing backup copies of data and for restoring a database when damage occurs. A modern DBMS normally automates many more of the backup and recovery tasks than a file oriented system.
- Increased installation and management cost
The large and complex DBMS software has a high initial cost. It requires trained manpower ti install and operate and also has substantial annual maintenance and support cost. Additional database software may be needed to provide security and to ensure proper concurrent updating of the share data.
- Additional hardware cast
The cost of DBMS installation various significantly, depending on the environment and functionality, size of the hardware and the recurring annual maintenance cost of hardware and software.
- Requirement of new and specialized manpower
Because of rapid changes in database technology and organization’s business needs, the organization’s need to hire, retain its manpower an provide database administration services and manage staff of new people. Therefore, an organization needs to maintain specialized skilled manpower.
- Increased complexity
A multi-user DBMS becomes an extremely complex piece of software due to expected functionality from it. It becomes necessary for database designers, developers, database and administrators, and end-users to understand this functionality to full advantage of it.
- Problem associated with centralization
Centralization means that the data is accessible from a single source called database.
- Large size of DBMS
The large complexity and wide functionality makes the DBMS an extremely large piece of software. It occupied many gigabytes of storage disk space and requires ex-substantial amounts of main memory to run efficiently.