What are the advantages and disadvantages of DBMS?

dbms

Advantages of DBMS

Reduction in Data redundancy:

Data redundancy refers to the duplication of data. In non database system, each application has its own separate files. This can often leads to redundancy in storage data, Which results in wastage of space

Reduction in Inconsistancy:

This is a corollary of the previous point discussed above. It is obvious that if the given fact is represent by a single entry than such inconsistence may not occur. Alternatively even if the redundancy is not remove but is controlled than to the DBMS ensures that the database is always consistent by ensuring that any change made to either of the two entries is automatically applied to the other one also. This process is known as propgating update.

Sharing of data:

Sharing of data allows the existing application to use the data (same data) in the database.

Enforcement of standards:

Since access to the database must be through the DBMS, standards are easier to enforce. Standardization of data particularly helps in regretting and interchanging data between different system.

Improvement in Data security:

Settings up of a DBMS makes it easier to enforce security restriction since the data is store centrally.

Maintenance of Data Integrity:

Data integrity refers to ensuring that the data in the database is accurate. Since in DBMS, the data is centralize is used by a number of users at a time, it is essential to enforce integrity control.

Better Interaction with user:

As compare to traditional database system a DBMS often provide better service to the users. In conventional system, usually information is poorly arranged an as the result. However in case of DBMS the availability up to date information.

Disadvantages of DBMS

Problem associated with centralization

Centralization increase the security problem and disruption due to the downtimes and failures.

Cost of Software

Today’s there are several software which are very costly. Hence from economic point of view it is the drawback.

Cost of Hardware

The application of the DBMS is its major disadvantages. Cost of hardware is also one of the major drawback.

Complex city of backup and recovery

DBMS provides the centralization of the data, which requires the adequate backup of the data show that in case of failure, the data can recovered. Hence backup problem is also the drawback.

Recent Posts