Database management system is a computer program that controls the creation, maintenance, and the use of a database. The following are the advantages of implementing DBMS in an organization:
Flexibility:
As the data and the programs are interdependent and when there is addition or deletion of the database the programs do not have to be modified.
Fast Response:
All the data of the organization is integrated in to a single database. Complex requests can be handled much more rapidly and faster response improves customer satisfaction.
Multiple Access:
Database software allows data to be accessed in a variety of ways and often, by using several programming languages. Data stored on the databases can be accessed by many employees at the same point of time.
Lower Costs:
These systems are easy to understand and the money, time required for training the users is reduced. Time taken to process requests may be shorter, which would increase user productivity.
Redundant Data:
Data normalization is the process used by the organizations to minimize the data redundancy as all the items are stored only once in the database which stores space.
Backup and Recovery:
Centralizing a database provides the schemes such as recovery and backups from the failures including disk crash and power failures.
Restricting Unauthorized Access:
A DBMS provides a security and authorization subsystem, which is used by DBA to create user accounts and to specify restrictions on user accounts.
Changes to Schema:
In some databases tables in the system can be edited to add new columns and rows without hampering the applications.
Data Consistency:
DBMS provides consistent data to the users which includes accuracy, validity and integrity of related data.
DBMS has many advantages for an organizations, it simplifies the process of data entry, transaction and retrieval in an organization.
As the data and the programs are interdependent and when there is addition or deletion of the database the programs do not have to be modified.
Fast Response:
All the data of the organization is integrated in to a single database. Complex requests can be handled much more rapidly and faster response improves customer satisfaction.
Multiple Access:
Database software allows data to be accessed in a variety of ways and often, by using several programming languages. Data stored on the databases can be accessed by many employees at the same point of time.
Lower Costs:
These systems are easy to understand and the money, time required for training the users is reduced. Time taken to process requests may be shorter, which would increase user productivity.
Redundant Data:
Data normalization is the process used by the organizations to minimize the data redundancy as all the items are stored only once in the database which stores space.
Backup and Recovery:
Centralizing a database provides the schemes such as recovery and backups from the failures including disk crash and power failures.
Restricting Unauthorized Access:
A DBMS provides a security and authorization subsystem, which is used by DBA to create user accounts and to specify restrictions on user accounts.
Changes to Schema:
In some databases tables in the system can be edited to add new columns and rows without hampering the applications.
Data Consistency:
DBMS provides consistent data to the users which includes accuracy, validity and integrity of related data.
DBMS has many advantages for an organizations, it simplifies the process of data entry, transaction and retrieval in an organization.
No comments:
Post a Comment