What are the advantages of DBMS over conventional file processing system?
==>> Advantage of DBMS over file system:
1. No redundant data: Redundancy removed by data normalization.
No data duplication saves storage and improves access time.
2. Data Consistency and Integrity: The root cause of data inconsistency is
data redundancy, since data normalization takes care of the data redundancy,
data inconsistency also been taken care of as part of it.
3. Data Security: It is easier to apply access constraints in database systems
so that only authorized user is able to access the data. Each user has a
different set of access thus data is secured from the issues such as identity
theft, data leaks, and misuse of data.
4. Privacy: Limited access means the privacy of data.
5. Easy access to data: Database systems manage data in such a way so that the
data is easily accessible with fast response times.
6. Easy recovery: Since database systems keep the backup of data, it is easier
to do a full recovery of data in case of a failure.
7. Flexible: Database systems are more flexible than file processing systems.
==>> Disadvantages of DBMS:
1. DBMS implementation cost is high compared to the file system.
2. Complexity: Database systems are complex to understand.
3. Performance: Database systems are generic, making them suitable for various
applications. However this feature affects their performance for some
applications.
==> Edit: Sourove Roy.