Follow
Data integrity is that the overall accuracy, completeness, and consistency of information. information integrity additionally refers to the protection of information in relevancy regulative compliance — like GDPR compliance — and security. it’s maintained by a set of processes, rules, and standards enforced throughout the look section. once the integrity of information is secure, the data keep in an exceedingly information can stay complete, accurate, and reliable in spite of however long it’s keep or however typically it’s accessed.
The importance of information integrity in protective yourself from information loss or a knowledge leak can not be overstated: so as to stay your data safe from outside forces with malicious intent, you want to initial make sure that internal users area unit handling information properly. By implementing the suitable information validation and error checking, you’ll make sure that sensitive information is rarely miscategorized or keep incorrectly, so exposing you to potential risk.
Types of information integrity
Maintaining information integrity needs AN understanding of the 2 varieties of information integrity: physical integrity and logical integrity. each area unit collections of processes and strategies that enforce information integrity in each hierarchic and relative databases.
Physical integrity
Physical integrity is that the protection of the wholeness and accuracy of that information as it’s keep and retrieved. once natural disasters strike, power goes out, or hackers disrupt information functions, physical integrity is compromised. Human error, storage erosion, and a bunch of different problems may build it not possible for processing managers, system programmers, applications programmers, and internal auditors to get correct information.
Logical integrity
Logical integrity keeps information unchanged as it’s employed in other ways in an exceedingly electronic database. Logical integrity protects information from human error and hackers also, however in an exceedingly abundant completely different approach than physical integrity will. There area unit four varieties of logical integrity:
=>> Entity integrity: Entity integrity depends on the creation of primary keys — the distinctive values that determine items of information — to confirm that data isn’t listed over once which no field in an exceedingly table is null. It’s a feature of relative systems that store information in tables which will be joined and employed in a spread of how.
=>> denotative integrity: Referential integrity refers to the series of processes that confirm information is keep and used uniformly. Rules embedded into the database’s structure regarding however foreign keys area unit used make sure that solely acceptable changes, additions, or deletions of information occur. Rules might embrace constraints that eliminate the entry of duplicate information, guarantee that information entry is correct, and/or command the entry of information that doesn’t apply.
=>> Domain integrity: Domain integrity is that the assortment of processes that make sure the accuracy of every piece of information in an exceedingly domain. during this context, a site may be a set of acceptable values that a column is allowed to contain. It will embrace constraints and different measures that limit the format, type, and quantity of information entered.
=>> User-defined integrity: User-defined integrity involves the foundations and constraints created by the user to suit their specific desires. generally entity, denotative , and domain integrity aren’t enough to safeguard information. Often, specific business rules should be taken under consideration and incorporated into information integrity measures.
