De-Identifying Data for Confidentiality |
Post Reply |
Author | ||||||||||||||||||||||||||||||||||||||||||||||||
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 03 Apr 2018 at 7:19am |
|||||||||||||||||||||||||||||||||||||||||||||||
Download Sample: De-identifyData.zip
There
are a number of circumstances when you as a developer might need to randomize
data within a database. You may need to
create sample data to test or demonstrate a database application. Or you may need to mask or
"de-identify" confidential data to comply with regulatory agency
rules. This article demonstrates two
methods that can be used, either separately or in conjunction, to scramble your
database.
Table 1: Original Customer table
Table 2: The
Customer table after randomization In certain instances, simply randomizing records is not sufficient. Certain field values have inherent information regardless of the record that holds them. Phone numbers, social security number, patient numbers, and the like all contain information all by themselves that may breach confidentiality. HIPAA regulations in particular are very strict about displaying any data that could identify a patient. So to further mask your data, it may be necessary to scramble character data with in the field itself. Now, it doesn't make sense to randomize some types of fields. Name and address fields in particular will look strange if randomized in this way.
Download the sample for more. Download Sample: De-identifyData.zip |
||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
|||||||||||||||||||||||||||||||||||||||||||||||
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |