Advantage of DBMS and Disadvantage of DBMS

  Advantage of DBMS

1. Recovery and backup : Data is secure in DBMS , DBMS provides backup for the system which can be stored later. 
2. Access privilege : DBMS can store data in single or multiple table and provide access controlling ti the users. 
3. Integrity : In practical Life, there are ma y situations where multiple user update the same data at the same time. DBMS can supports concurrent transactions so that integrity of data is improved. 
4. Common standards : DBMS follow common standards for all types of data.
5. Easy to reserve : We can easily retrieve any data from the database.
6. Easy to insert : We can insert new record or data.
7. Easy to delete : If we want to delete unwanted data then DBMS provide facility of deletion. 
8. Security : DBMS provides high level security mechanisms like decryption, password, face and finger detection, voice recognizance.
9. Cost of development : The initial cost of setting up a database can be large.

 Disadvantage of DBMS

1. Professionals : For development of maintenance of database we require highly qualified professionals. 
2. Cost : Cost of hardware and software is very high at initial level. 
3. Confidentiality, privacy and security : DBMS can be centralized so there is probability of technical, administrate lack of security.
4. Depend on power : DBMS completely depend in power. When the power is down complete work effected.
5. Integrity : Multiple users use Database concurrently, technically integrity of data is reduced.