DBMS: DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.
Advantage of DBMS:
There are several advantages of Database management
system over file system. Few of them are as follows:
(i) No redundant data – Redundancy removed by data
normalization
(ii) Data Consistency and Integrity – data
normalization takes care of it too
(iii) Secure – Each user has a different set of
access
(iv) Privacy – Limited access
(v) Easy access to data
(vi) Easy recovery
(vii) Flexible
(viii) Data isolation
(ix) Solved integrity problem
(x) Solved atomicity problems
(xi) Concurrent access anomalies
Disadvantages of DBMS:
(i) DBMS implementation cost is high compared to the
file system
(ii) Complexity: Database systems are complex to
understand
(iii) Performance: Database systems are generic,
making them suitable for various applications. However this feature affect
their performance for some applications
No comments:
Post a Comment