Data integrity means that provide complete accuracy and consistency in whole lifecycle of data. the scope and meaning of data integrity is varies between various context. in DBMS for keeping the data present in the database always stable in relation to the operation done in data base is called data integrity. therefore it means that before or after any operation done on database to store data base.
Apply integrity constraints on data base to keep the data of data base pure & well organized. integrity constraints maintains uniformity and integrity of data. the data base integrity are opposite to data corruption. it means data loss is prevented by data integrity. the data base integrity is different from database security.
apply integrity constraints on data base to keep the data of data base pure and well organized. integrity constraints maintain uniformity and integrity of data. the data base integrity are opposite to data corruption. it means data loss is prevented by data integrity. the data base integrity is different from data base security. primary key, foreign key, data type, domain, data size, unique, check, like, exist, default etc. integrity constraints are used for data base integrity. integrity constraints determined that which operation will performed by which user on which part of data base and it also mentioned that there is no effect of change which perform in any object of data base to other object. integrity constraints are applied by DBA under benefits of an organization and it is saved in data dictionary in form of meta data.
Data integrity are mainly of two types -
1. physically integrity
2. logically integrity
following are the types of database integrity constraints -
1. type constraints (data type)
2. attribute constraints (NOT NULL, check, like, PRIMARY KEY, unique)
3. relational schema constraints (FOREIGN KEY)
4. data base constraints (assertion, trigger, view, procedure etc.)
No comments:
Post a Comment