Advantages & Disadvantages of DBMS

Advantages & Disadvantages of DBMS

 Advantages

1) DBMS offers a variety of techniques to store & retrieve data.

2) DBMS serves as an efficient handler to balance the needs of multiple applications using the same data.

3) Uniform administration procedures for data.

4) Application programmers never exposed to details of data representation and storage.

5) A DBMS uses various powerful functions to store and retrieve data efficiently.

6) Offers Data Integrity and Security.

7) The DBMS Implies integrity constraints to get a high level of protection against prohibited access to data.

8) A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time.

9) Reduced Application Development Time.

Disadvantages

DBMS may offer plenty of advantages but, it has certain flaws.

1) Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.

2) Most DBMS are often complex systems, so training for users to use the DBMS is required.

3) In some organizations, all data is integrated into a single database which can be damaged because of electric failure or the Database is corrupted on the storage media.

4) Use of the same program at a time by many users sometimes lead to the loss of some data.

5) DBMS can't perform sophisticated calculations.