Integrity Manager

Integrity constraints are a set of rules that checks whether a particular condition has been satisfied or not. It also ensures that the quality of data is preserved. So these integrity constraints help to prevent accidental changes to the data. Integrity Manager is a component of Storage Manager. It first checks the integrity constraints and then accordingly the data is modified. If the constraints are satisfied, then only the CRUD operation is allowed else it is not allowed.

Let us elaborate with the help of an example. Suppose a user wants to insert a roll number in the Students Database. The integrity constraint for the Roll Number is Primary Key. So when the user enters the Roll number, Integrity Manager first checks whether the Roll Number is unique or not. If it is unique, the record is inserted else it throws an error that the roll number should be unique. Integrity Manager ensures that the operation made on a particular part of data does not affect the other stored data.

Integrity Manager

Authorization and Integrity Manager in DBMS

DBMS is software that allows users to store, modify, and delete the data present in a database. It helps to organize and structure our data. It allows users to perform CRUD operations. CRUD operation basically stands for CREATE, READ, UPDATE, and DELETE.

Similar Reads

Components that Make DBMS

There are three components that make up the Database Management System. They are:...

Authorization Manager

Authorization is basically identifying and giving users access to the resources. In DBMS, Authorization Manager provides access to the user depending upon the roles. The Administrator first authorizes the user and provides the desired access to the user. The Manager is also involved in decision-making and decides whether the particular user should be granted to perform the operations or not....

Integrity Manager

Integrity constraints are a set of rules that checks whether a particular condition has been satisfied or not. It also ensures that the quality of data is preserved. So these integrity constraints help to prevent accidental changes to the data. Integrity Manager is a component of Storage Manager. It first checks the integrity constraints and then accordingly the data is modified. If the constraints are satisfied, then only the CRUD operation is allowed else it is not allowed....

Difference Between Authorization Manager and Integrity Manager

Although both are part of Storage Manager, there are some differences between them....

Frequently Asked Questions

Q1: Define Authorization and Integrity Manager. Why do we require them?...

Contact Us