Describe how data validation and data verification help protect the integrity of data

6.2 Data Integrity

What is Data Integrity?

Data integrity means that the data stored in a system is accurate, consistent, and reliable throughout its lifecycle. Think of it as a promise that the information you see is the same as the information that was originally entered. 📚

Why is it important?

When data is wrong, decisions can be wrong. For example, a hospital using incorrect patient data could give the wrong medication. Data integrity protects against such mistakes. 🔒

Data Validation vs. Data Verification

Both are techniques to keep data clean, but they work at different stages.

1. Data Validation – checks data before it is stored. It ensures that the input meets certain rules.
2. Data Verification – checks data after it is stored or transmitted. It confirms that the data remains unchanged.

Common Validation Techniques

• Format checks (e.g., email, phone number)
• Range checks (e.g., age between 0 and 120)
• Uniqueness checks (e.g., no duplicate usernames)
• Cross‑field checks (e.g., password and confirm password match)

Verification Methods

• Checksums (e.g., CRC, MD5)
• Digital signatures
• Redundancy checks (e.g., RAID, parity bits)

Analogy: The Library System

Imagine a library where every book has a barcode. Validation is like checking the barcode when a book is first added to the catalog – if the barcode is wrong, the book is rejected. Verification is like scanning the barcode again when a book is checked out to ensure it matches the record. If it doesn’t, the system flags an error. 📚🔍

Real‑World Example: Banking Transactions

When you transfer money, the system first validates that your account number is in the correct format. After the transfer, it verifies that the amount debited from your account equals the amount credited to the recipient’s account. If the numbers don’t match, an audit trail is created. 💸

Table: Validation Rules vs. Verification Techniques

Key Takeaways

• Validation stops bad data at the source.
• Verification confirms data remains intact.
• Both techniques work together to maintain data integrity.
• Good practice: combine validation rules with checksum verification for critical data.

Quick Quiz

1. What is the main difference between validation and verification?
2. Give an example of a checksum algorithm.
3. Why might a system use both techniques?

Checksum example: $checksum = \sum_{i=1}^{n} value_i \bmod 256$.