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. |
Saturday, March 30, 2013
Advantages of DBMS
Labels:
Database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment