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.
a blog by Sameer. Its all about programming and technology. Articles on C programs, C#.Net, VB.Net, ASP.Net, Sql Sever, Technology and many more.
This website completely moved to new platform. For latest content, visit www.programmingposts.com
Search this Site
4 Nov 2012
RELATED POSTS
HOW TO SET IDENTITY KEY/AUTO INCREMENT ON VARCHAR COLUMN IN SQL SERVER
Create the table as follows CREATE TABLE Student_Register( SNo INT NOT ...
Sql query to get common Columns in multiple tables in Sql Server
Lets suppose Database Name is MYDB and TABLE1, TABLE2, TABLE3 are tables ...
GET ALL DATABASE NAMES EXCEPT SYSTEM DATABASES IN SQL SERVER
There is a simple query to get all database names except system databases ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Thanks for your comments.
-Sameer