Benefits of Database Approach
- A DBMS is a collection of programs that manages the database structure and controls access to the data stored in the database.
- It is an intermediary between the user and the database.
- The database structure itself is stored as a collection of files.
- Advantages of Database Management System (DBMS)
- 1. Improved data sharing
- DBMS helps to create an environment in which end users have better access.
- It is also provides user control to access data.
- It is easy to share data between users and applications.
- 2. Improved data security
- DBMS also provides a security levels between users to access data.
- It has several rights to provides security on data as well as users.
- 3. Better data integration
- DBMS stores all the data at central level.
- It is will integrate different location and users' data at the center. So, it can easily integrate all other data.
- 4. Minimized data inconsistency
- Data inconsistency exists when different versions of the same data appear in different places.
- For example, data inconsistency exists when a school department stores a student name as “Sarthak Patel” and the Bank stores that same person’s name as “Patel Sarthak C."
- 5. Improved data access
- The DBMS makes it possible to produce quick response based on request (using query).
- Simply a query is a question.
- The DBMS sends back a response from the application.
- For example select * from tab;
- 6. Improved decision making
- Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based.
- Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data.
- 7. Increased end-user productivity
- The availability of data, combined with the tools that transform data into usable information.
Tags:
DBMS
