Friday, December 16, 2011

Advantages of DBMS over Simply storing data

Advantages of DBMS over Simply storing data:-
A.)Data independence and efficient access.:-Database application programs are independent
of the details of data representation and storage.DBMS provides efficient storage and
retrieval mechanisms, including support for very large files, index structures and
query optimization.
B.)Reduced application development time.:-DBMS provides several important
functions required by applications, such as concurrency control and crash
recovery, high level query facilities, etc., only application-specific code needs to
be written.
C.)Data integrity and security. The view mechanism and the authorization facilities
of a DBMS provide a powerful access control mechanism. Further, updates to the
data that violate the semantics of the data can be detected and rejected by the
DBMS if users specify the appropriate integrity constraints.
D.)Data administration. By providing a common umbrella for a large collection of
data that is shared by several users, a DBMS facilitates maintenance and data
administration tasks. A good DBA can effectively shield end-users from the chores
of fine-tuning the data representation, periodic back-ups etc.
E.)Concurrent access and crash recovery.

No comments:

Post a Comment