59 / 65 · 15 SQL & Database Testing · Data Masking and Anonymization← prev⊞ allnext →☰ Read as one page
8.3Masking Techniques
| Data Type | Original | Masked | Technique |
|---|---|---|---|
| john@company.com | user_8a3f@masked.test | Hash-based replacement | |
| Phone | +1-555-867-5309 | +1-555-000-0042 | Format-preserving randomization |
| SSN | 123-45-6789 | XXX-XX-6789 | Partial redaction |
| Credit card | 4111111111111111 | 4111XXXXXXXX1111 | First/last four preserved |
| Name | John Smith | David Wilson | Lookup-based substitution |
| Address | 123 Main St, NY | 456 Oak Ave, CA | Randomized replacement |
| Date of birth | 1985-03-15 | 1985-07-22 | Day/month shuffled, year preserved |
| Salary | $85,000 | $82,000 | Range-preserving perturbation |