Advantages and Importance of Database Management System:
- Database minimized data redundancy which makes updating easier and less error prove.
- Database saves processing effort and storage space.
- A database pool the data for a series of applications. So, data is easily available from one central source.
- DBMS helps data management much more efficient and effective.
- DBMS helps in having better access to more and better managed data.
- DBMS helps in quickly answering the queries.
- DBMS helps in preparing reports.
- Fewer programs may be needed since each can access an entire database.
- DBMS helps in ensuring data security and integrity.
Objectives of DBMS:
DBMS has been involved to overcome the problems and limitations of traditional management.
The following are the main objectives of DBMS:
- Complexity of an organisation information system is reduced through centralization of data management.
- Data redundancy and inconsistency are reduced by eliminating all isolated files in which the data elements are repeated.
- Program data dependence is reduced by providing central control of data creation and definition.
- Flexibility in information system is greatly increased by permitting ad hoc queries of large pool of information.
- Data once stored are accessed by multi-users. Thus, data collected for one purpose can be used to serve various purpose as the needs arise.