What Are The Disadvantages And Advantages Of Database Management System?

Advantages:
• Data is located near the greatest demand site.
• Access to data is faster; processing is faster due to several sites spreading out the work load.
• New sites can be added quickly and easily
• Communication is improved
• Operating costs are reduced
• It is user friendly
• There is less danger of a single-point failure
• It has process independence
• Data can physically reside nearest to where it is most often accessed, thus providing users with local control of data that they interact with. This results in local autonomy of the data allowing users to enforce locally the policies regarding access to their data.
• Reduced data redundancy
• Reduced updating errors and increased consistency
• Greater data integrity and independence from applications programs
• Improved data access to users through use of host and query languages
• Improved data security
• Reduced data entry, storage, and retrieval costs
• Facilitated development of new applications program

Disadvantages
• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users
• Unemployment will increase as less labor will be required
• Investment needed as computer system and software need to be purchased.
• Computer literate employees needed because only computer literate can use it.

Some disadvantages of d.b.m.s.
1)confidentiality,privacy and security-  
2)data inegrity
3)data quality.
4)the cost of a dbms
5)enterprise vulnerbility

DBMS can have several advantages - I name just a few

Sharing of information
Real time transactional processing
Historical track record for auditing and control
A good disaster recovery plan may save a business from bankruptcy

Here are some disadvantages

DBMS subjects a business to a risk in the loss of critical data in its electronic format it can be more readily stolen without proper security

The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making the investment in the infrastructure

Improper use of the DBMS can lead to incorrect decision making as people take for granted the data is accurate as presented.

He advantages of DBMS are as follows:
-Controlling redundancy

-Providing storage structure for efficient query processing.

-Restricting unauthorized users.
-Providing concurrency.

-Providing backup and recovery.
-Enforcing integrity constraints.

The disadvantages are as follows:
-Centralization:That is use of
the same program at a time by many user sometimes lead to loss of some
data.
-High cost of software.

Technical expertise are required

power dependency

security issues