Maintaining referential integrity while masking

Details Maintaining referential integrity while masking Maintaining referential integrity while masking

2011-07-12

2011-07-12

LeRoux, Etienne P (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Reexamination Certificate

active

07979410

ABSTRACT:
Systems, methods, and other embodiments associated with maintaining referential integrity while masking database columns are described. One example method includes determining a transitive closure for dependency relationships involving a column to be masked and other columns related to the column to be masked through a dependency relationship. The example method may also include identifying a root column for a column in the transitive closure and creating a mapping table that stores original values and masking values for the root column. The method includes masking the root column and related child columns based on the mapping table in a manner that maintains referential integrity between the root column and the child column. Integrity may be maintained by masking corresponding values in the root column and a child column(s) with identical mask values from the mapping table.

REFERENCES:
patent: 2006/0015514 (2006-01-01), Suga
patent: 2007/0208692 (2007-09-01), Martinez et al.
patent: 2008/0065665 (2008-03-01), Pomroy et al.
patent: 2008/0082834 (2008-04-01), Mattsson
patent: 2009/0024565 (2009-01-01), Wong

Affiliated with

Also associated with

Rating

Maintaining referential integrity while masking does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Maintaining referential integrity while masking, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Maintaining referential integrity while masking will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2680550