The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 12, 2011
Filed:
Jul. 30, 2008
Ravi Pattabhi, Stow, MA (US);
Harish Akali, Merrimack, NH (US);
Luming Han, Allston, MA (US);
Xiaolan Shen, Nashua, NH (US);
Andrew Bodge, Acton, MA (US);
Ravi Pattabhi, Stow, MA (US);
Harish Akali, Merrimack, NH (US);
Luming Han, Allston, MA (US);
Xiaolan Shen, Nashua, NH (US);
Andrew Bodge, Acton, MA (US);
Oracle International Corp., Redwood Shores, CA (US);
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.