Patent ID: 8856157
Filing Date: 2014-10-07
Classification: G06F

Abstract:
1. A computer implemented method for automatic obfuscation of sensitive data in a database schema comprising: receiving a selection of the database schema defining at least one table including at least one column comprising anti-values, wherein anti-values are values of data in a format or content different from expected format or content for a respective type of data; determining column obfuscation patterns that define column content with sensitive data by analyzing column names in metadata of the database schema; obfuscating a first set of sensitive data from a table of the at least one table of the database schema when the column obfuscation patterns are determined; determining data obfuscation patterns, within a predefined set of rows of data from rows of the table of the database schema based on a set of predefined recognition rules, to detect a column from the at least one column of the at least one table to be obfuscated, wherein the determining within the predefined set of rows of data for the column from the table is ceased when a data obfuscation pattern for the column is determined; obfuscating a second set of sensitive data from the table of the at least one table of the database schema when the data obfuscation patterns are determined; and determining an obfuscation score, defining accuracy for the obfuscation of the first set of sensitive data and the second set of sensitive data.