Patent attributes
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.
