In this article, we are providing the Main Advantages and Disadvantages of Database Management systems. Before continuing this article, please have a look at the previous article which will help you to know what is Database Management systems.
Advantages of DBMS
The main Advantages of Database Management Systems (DBMS) are.
- Controlling of Redundancy.
- Improved Data Sharing
- Data Integrity.
- Data Consistency
- Efficient Data Access
- Enforcements of Standards
- Data Independence
- Reduced Application Development and Maintenance time.
1. Controlling of Redundancy:
Data redundancy refers to the duplication of data (i.e storing the same data multiple times). In a database system, by having a centralized database and centralized control of data by the DBA the unnecessary duplication of data is avoided. It also eliminates the extra time for processing the large volume of data. It results in saving the storage space.
2. Improved Data Sharing:
DBMS allows a user to share the data in any number of application programs.
3. Data Integrity:
Integrity means that the data in the database is accurate. Centralized control of the data helps in permitting the administrator to define integrity constraints to the data in the database. For example: in the customer database, we can enforce integrity that it must accept the customer only from Noida and Meerut city.
Having complete authority over the operational data enables the DBA in ensuring that the only mean of access to the database is through proper channels. The DBA can define authorization checks to be carried out whenever access to sensitive data is attempted.
5. Data Consistency:
By eliminating data redundancy, we greatly reduce the opportunities for inconsistency. For example: is a customer address is stored only once, we cannot have a disagreement on the stored values. Also updating data values is greatly simplified when each value is stored in one place only. Finally, we avoid the wasted storage that results from redundant data storage.
6. Efficient Data Access:
In a database system, the data is managed by the DBMS and all access to the data is through the DBMS providing a key to effective data processing
7. Enforcements of Standards:
With the centralized data, DBA can establish and enforce the data standards which may include the naming conventions, data quality standards, etc.
8. Data Independence:
In a database system, the database management system provides the interface between the application programs and the data. When changes are made to the data representation, the metadata obtained by the DBMS is changed but the DBMS is continued to provide the data to the application program in the previously used way. The DBMS handles the task of transformation of data wherever necessary.
9. Reduced Application Development and Maintenance Time:
DBMS supports many important functions that are common to many applications, accessing data stored in the DBMS, which facilitates the quick development of the application.
Disadvantages of DBMS
- It is a bit complex. Since it supports multiple functionalities to give the user the best, the underlying software has become complex. The designers and developers should have thorough knowledge about the software to get the most out of it.
- Because of its complexity and functionality, it uses a large amount of memory. It also needs a large memory to run efficiently.
- DBMS system works on the centralized system, i.e.; all the users from all over the world access this database. Hence any failure of the DBMS will impact all the users.
- DBMS is generalized software, i.e.; it is written work on the entire systems rather specific one. Hence some of the applications will run slow.