Monday, April 6, 2009

Introducing a DBMS to an organization

Introducing a DBMS to an organization introduces many advantages. First of all, it centralizes the data, and links it together, it might, for example link an organization’s inventory, with its sales and it’s accounting department. This not only enables all data to be linked, and more complete information to be available, it also reduces redundancies from all departments, and minimizes errors in the data, in changes and in new data entry. This, depending on the size of the organization, and the data type, it could save a lot of storage space.

A centralized DBMS also enforces data consistency. Since all columns have a declared data type (int, varchar, text, date) it force the data entry to be valid. It removes unexpected errors from unexpected data returned, such as text instead of a date.

Furthermore, it allows for a standardized way to retrieve data, and to query data.
One last note, which is not a advantage per say, however, the expensive price of a DBMS, which used to be a barrier to get one for small/medium organizations has disappeared with free DBMS.

No comments:

Post a Comment