Database table data obfuscation techniques
An obfuscation system includes a first database for storing raw data, a quality assurance testing database for storing modified data, one or more processors, and computer-readable memory. The computer-readable memory is encoded with instructions that, when executed by the one or more processors, cause the obfuscation system to: access raw data from the production database, copy the raw data from the production database to the quality assurance testing database, identify sensitive data within the raw data for obfuscation in the quality assurance testing database, obfuscate the sensitive data that has been identified by replacing the sensitive data in each field with a concatenation of a unique descriptor that describes the sensitive data in the field and a primary key, and store the modified data in the quality assurance testing database for access via a user interface.
1 . An obfuscation system comprising:
a first database for storing raw data;
a second database for storing modified data;
one or more processors; and
computer-readable memory encoded with instructions that, when executed by the one or more processors, cause the obfuscation system to:
access raw data from the first database;
copy the raw data from the first database to the second database;
identify sensitive data within the raw data for obfuscation;
obfuscate the sensitive data that has been identified by replacing the sensitive data in each field with a concatenation of a unique descriptor that describes the sensitive data in the field and a primary key, wherein the primary key identifies a table in the first database from which the obfuscated sensitive data originates; and
store the modified data in the second database for access via a user interface, the modified data comprising the sensitive data that has been obfuscated and non-sensitive data of the raw data that has not been obfuscated.
2 . The obfuscation system of claim 1 , wherein the first database is a production database, and the second database is a quality assurance testing database.
3 . The obfuscation system of claim 1 , wherein the remainder of the raw data from the first database that has not been identified as sensitive is the non-sensitive data.
4 . The obfuscation system of claim 1 , wherein the unique descriptor is a generic term.
5 . The obfuscation system of claim 4 , wherein the unique descriptor is configured to identify the type of the sensitive data in the field but does not identify the sensitive data.
6 . The obfuscation system of claim 1 , wherein the unique descriptor is unique to all other fields in the second database.
7 . The obfuscation system of claim 1 , wherein the first database comprises a plurality of tables, and wherein each table of the plurality of tables contains fields of data and has a different primary key, and each field of the fields of data within a same table has a same primary key.
8 . The obfuscation system of claim 1 , wherein the sensitive data comprises personally identifiable data, and the non-sensitive data comprises data that has not been identified as personally identifiable data.
9 . The obfuscation system of claim 1 , wherein the sensitive data is reversibly obfuscated.
10 . A method of obfuscating data for a quality assurance testing database, the method comprising:
accessing raw data from a production database;
copying the raw data from the production database to a quality assurance testing database;
identifying sensitive data within the raw data from the production database for obfuscation;
obfuscating the sensitive data that has been identified by replacing the sensitive data in each field with a concatenation of a unique descriptor that describes the sensitive data in the field and a primary key, wherein the primary key identifies a table in the production database from which the obfuscated sensitive data originates; and
storing modified data in the quality assurance testing database for access via a user interface, the modified data comprising the sensitive data that has been obfuscated.
11 . The method of claim 10 , wherein the modified data further comprises non-sensitive data of the raw data that has not been obfuscated.
12 . The method of claim 10 , wherein the raw data comprises sensitive data and non-sensitive data.
13 . The method of claim 12 , wherein the non-sensitive data comprises data that has not been identified as personally identifiable data.
14 . The method of claim 12 , wherein the sensitive data comprises personally identifiable data.
15 . The method of claim 10 , wherein the production database comprises a plurality of tables, and wherein each table of the plurality of tables contains fields of data and has a different primary key, and each field of the fields of data within a same table has a same primary key.
16 . The method of claim 10 , wherein the unique descriptor is a generic term configured to identify the type of the sensitive data in the field but does not identify the sensitive data.
17 . The method of claim 10 , wherein the unique descriptor is unique to all other fields in the quality assurance testing database.
18 . The method of claim 10 , wherein the sensitive data is reversibly obfuscated.