Thursday, June 23, 2011

Features Offered by Database Management System

Database management system is a computer program which helps to control the creation, maintenance, and the use of a database. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. The features of DBMS are as follows:

Query Ability:
A database query language and report writer allows the users to interactively interrogate the database, analyze its data and update the data according to the users data needs.

Security:
It is the feature offered by the database management system in which specific individuals or the groups are allowed to access the information in the database with in the organization.

Replication:
Replicates of the original data are created for a distant organization that cannot readily access the original. When the replicates are created between database servers the information remains consistent throughout the database system and users cannot tell or even know which server in the DBMS they are using.

Rule Enforcement:
Certain rules must be applied to the attributes so that the attributes are clean and reliable and these rules should be able to be added and removed as needed without significant data layout redesign.

Computation:
Common computations such as, counting, summing, averaging, sorting, grouping, cross referencing etc are needed by the organizations and the organizations can do such computations with the use of DBMS.

Automated Optimization:
For repeated queries DBMS can adjust themselves to improve the speed of those interactions. DBMS also provides tools for monitoring the performance which allows the experts to make the necessary adjustments after reviewing the statistics collected.

All the above said features make the database management system, very advantageous for an organization.

No comments: