DATA INTEGRITY IN SQL DATABASES

  Miras Nussupov (Taldykorgan, Kazakhstan) |    Завантажити статтю

Information integrity is the upkeep of, and the confirmation of the precision and consistency of, information over its whole life-cycle, and is a basic perspective to the outline, execution and use of any framework which stores, forms, or recovers information. The term is wide in scope and may have broadly unique implications relying upon the particular setting – even under a similar general umbrella of processing. It is on occasion utilized as an intermediary term for information quality, while information approval is a pre-essential for information integrity. Data integrity is the inverse of information corruption. The general expectation of any information integrity system is the same: guarantee information is recorded precisely as proposed, (for example, a database effectively dismissing fundamentally unrelated conceivable outcomes,) and upon later recovery, guarantee the information is the same as it was the point at which it was initially recorded. So, information integrity intends to counteract unexpected changes to data. Information integrity isn't to be mistaken for information security, the train of shielding information from unapproved parties.