|
Book · October 021 citations reads 35,829 authorsBog'liq 4 PROFESSIONAL ENGLISHAdvantages of a DBMS
Using a DBMS to store and manage data comes with advantages, but also overhead. One of the
biggest advantages of using a DBMS is that it lets end users and application programmers access
and use the same data while managing data integrity. Data is better protected and maintained when
it can be shared using a DBMS instead of creating new iterations of the same data stored in new
files for every new application. The DBMS provides a central store of data that can be accessed by
multiple users in a controlled manner.
Central storage and management of data within the DBMS provides:
Data abstraction and independence;
Data security;
A locking mechanism for concurrent access;
An efficient handler to balance the needs of multiple applications using the same data;
The ability to swiftly recover from crashes and errors, including restartability and
recoverability;
Robust data integrity capabilities;
Logging and auditing of activity;
Simple access using a standard application programming interface (API);
Uniform administration procedures for data.
Another advantage of a DBMS is that it can be used to impose a logical, structured organization on
the data. A DBMS delivers economy of scale for processing large amounts of data because it is
optimized for such operations.
A DBMS can also provide many views of a single database schema. A view defines what data the
user sees and how that user sees the data. The DBMS provides a level of abstraction between the
conceptual schema that defines the logical structure of the database and the physical schema that
describes the files, indexes and other physical mechanisms used by the database. When a DBMS is
used, systems can be modified much more easily when business requirements change. New
categories of data can be added to the database without disrupting the existing system and
applications can be insulated from how data is structured and stored.
Of course, a DBMS must perform additional work to provide these advantages, thereby bringing
with it the overhead. A DBMS will use more memory and CPU than a simple file storage system.
And, of course, different types of DBMSes will require different types and levels of system
resources.
(See more at:
https://searchsqlserver.techtarget.com/definition/database-management-system
,
https://www.encyclopedia.com/science-and-technology/computers-and-electrical-
engineering/computers-and-computing/databases)
|
| |
