Abstract: A method and system for data masking a series of interrelated data records is disclosed. A lockable translation matrix repository resource is provided to contain both masked data as well as appropriate key information that provides links between respective copies of respective interlinked databases and maintains the data integrity of masking data inserted therein. Records are masked on a column by column or table by table basis. Records for which masking data is already in the repository are masked by making use of such data, while remaining records are segregated, masked and the masking data updated to the repository. Preferably a backup copy of the masked data records is stored in the repository to permit de-masking of the data records at a later stage. Pivot tables are applied where keys do not match exactly but still exhibit a one-to-one relationship.

Abstract: A system and method for data masking target data fields of a data record uses an original database with data records having at least one target data field and a copied database including a copy of at least a portion of the original database. Data masking consists of adding a row-identifier column with an index to a primary data record to form a primary row-identifier data record, creating empty delta data records, performing data transformations on the target data fields to form masked delta data records, merging the masked delta data records with the primary row-identifier data record to form a masked primary data record, copying a related data record and joining with said primary row-identifier data record to form a related row-identifier data record and then merging the related row-identifier data record with the masked primary data record to form a masked related data record.

Abstract: A method and system for data masking a series of interrelated data records is disclosed. A lockable translation matrix repository resource is provided to contain both masked data as well as appropriate key information that provides links between respective copies of respective interlinked databases and maintains the data integrity of masking data inserted therein. Records are masked on a column by column or table by table basis. Records for which masking data is already in the repository are masked by making use of such data, while remaining records are segregated, masked and the masking data updated to the repository. Preferably a backup copy of the masked data records is stored in the repository to permit de-masking of the data records at a later stage. Pivot tables are applied where keys do not match exactly but still exhibit a one-to-one relationship.

Abstract: A system and method for data masking target data fields of a data record uses an original database with data records having at least one target data field and a copied database including a copy of at least a portion of the original database. Data masking consists of adding a row-identifier column with an index to a primary data record to form a primary row-identifier data record, creating empty delta data records, performing data transformations on the target data fields to form masked delta data records, merging the masked delta data records with the primary row-identifier data record to form a masked primary data record, copying a related data record and joining with said primary row-identifier data record to form a related row-identifier data record and then merging the related row-identifier data record with the masked primary data record to form a masked related data record.