Complete Computer Knowledge Portal

Saturday, March 30, 2013

Advantages of DBMS

Sr. No.
Advantage
Description
1
Reduced Data Redundancy
With the use of DBMS data redundancy is reduced. Since all data is stored at one centralized place and chances of data duplicity are very rare.
2
Data Inconsistency
Data inconsistency exists when different and conflicting versions of
the same data appear in different places. Since in DBMS data is stored at centralized place and data duplicity is avoided which also reduces the Data Inconsistency.
3
Centralized Access
Since data is stored at central place and can be used by any connected client as per rights given to him.
4
Data Integrity
With the help of Centralized control adequate checks are incorporated
in the DBMS to provide data integrity. This assures that the data contained
in the database is both correct and consistent. Data values being entered for the storage could be checked to ensure that they fall within a specified limit and follow the correct format.
5
Data Security
Since it user has limited rights as per his/her requirements. Only those part is made visible to user which is desired by the user and rest of data is hidden.
6
Concurrent access
Same data can be used by different users at the same type.
7
Efficient data access
DBMS uses no. of sophisticated techniques to store and retrieve data efficiently. This feature is very important if the data is stored on external storage devices.
8
Data Independence
The DBMS can provide an abstract view of the data to insulate application code from details of data representation and storage.
9
Data Administration
Centralized data can be used for improvements or to identify loop
falls.

No comments:

Post a Comment