This website completely moved to new platform. For latest content, visit www.programmingposts.com

Search this Site

4 Nov 2012

FEATURES OF DATABASE MANAGEMENT SYSTEMS

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.

Meta-data Repository:

Meta Data is the data describing data. In other words it is also called as data about data.