- MS Sql Server
- 946
- March-22-2018
- by Rizwan Saqib
Advantages and Workings of DBMS
1)Redundancy Control:
A data which is stored multiple times at different locations is a redundant data.
Redundancy leads to usage of more disk space, inconsistency and duplication of effort.
When data has to be updated at multiple locations it causes duplication of effort, where ideally only
one update should be sufficient.
2)Efficient Retrieval of data:
The sole purpose of storing data is that it should be retrieved as desired.
So a DBMS allows users to execute queries efficiently.
3)Security:
Users should be granted access to only those data and reports which they specifically need.
It restricts users from viewing or updating data which is not in their scope. Typically,
users are given an account protected with password by a DBA and account restrictions are enforced by the DBMS Software.
Like for a DBA account, there are no restrictions, they can create, alter, shutdown and startup DB
4)Multiple User Interface:
Since the number of end users might be more with varying degree of roles to match their designation,
DBMS should provide different User Interfaces to each.
5)Backup and Recovery: In case of system crash a DBMS has a capability to restore.
If system crashed between a complex query, then it must bring the system back at its consistent state.
This is specifically done by taking backup at the right time.
6)Fast response time:
A DBMS must be able to update the records or modify data and these updates and modifications
should be available to user almost instantly.
This is will prevent users to work on old and inconsistent data.
