Advantages and Workings of DBMS

  By Rizwan Saqib   Posted on March-22-2018   739

MS Sql Server

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.


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.

By  Rizwansaqib966    22-Mar-2018 Views  739

You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links