Prelim-Handout1 [Part2: Advantage of DBMS]

Improved data sharing

The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS.

Improved data security

The more users access the data, the greater the risks of data security breaches. Corporations invest considerable amounts of time, effort, and money to ensure that corporate data is used properly. A DBMS provides a framework for better enforcement of data privacy and security policies.

Better data integration

Wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture. It becomes much easier to see how actions in one segment of the company affect other segments

Minimized data inconsistency

lessen different versions of the same data appear in different places.

Improved data access

The DBMS makes it possible to produce quick answers to ad hoc queries. From a database perspective, a query is a specific request issued to the DBMS for data manipulation—for example, to read or update the data.

Improved decision making

Better-managed data and improved data access make it possible to generate better- quality information, on which better decisions are based. The quality of the information generated depends on the quality of the underlying data.

Increased end-user productivity

The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.

improved data sharing, improved data security, better data integration, minimized data inconsistency, improved data access, improved decision making, increased end-user productivity.

List down the 7 advantages of DBMS: