Friday, December 30, 2011

WEEK 09 - INTRODUCTION OF DBMS

A DBMS is a software system that enables users to define, create and maintain a database. The DBMS also enforces necessary access restrictions and security measures in order to protect the database.

The DBMS also has the job of controlling access to database. Various types of control systems within the DBMS make sure that the database continues to function properly:

- Integrity system
- Security system
- Concurrency control system
- Recovery control system

Many DBMSs enable "views" of the database to be defined. A view is how the database appears to a certain user. Views offer the benefit of only having to show relevant information to different types of users and it increases security as certain users will not be able to see data which they are not meant to see. Views can also decrease the perceived complexity of the database from the user's point of view.

No comments:

Post a Comment