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
Assignee:
Oracle International Corp. - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707705
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.
Method And System For Comparing And Re-Comparing Data Item Definitions
A method, system, and computer program product provides the capability to compare data object definitions in a database in a less costly and less time-consuming manner than previous techniques. A method of comparing multiple versions of data item definitions in a database comprises generating a first version of comparison information relating to a plurality of data item definitions in the database by comparing information relating to data item definitions obtained from a first source and information relating to data item definitions obtained from a second source and generating a second version of comparison information relating to a plurality of data item definitions in the database by comparing information relating to data item definitions obtained from a first source and information relating to data item definitions obtained from a second source to the first version of comparison information.
Method And System For Capturing And Storing Multiple Versions Of Data Item Definitions
Andrew Bodge - Acton MA, US Harish Akali - Merrimack NH, US Luming Han - Bedford NH, US Xiaolan Shen - Nashua NH, US
International Classification:
G06F 17/30
US Classification:
707203000
Abstract:
A method, system and computer program product provides the capability to capture and store data object definitions in a database in a less costly and less time-consuming manner than previous techniques. A method of capturing and storing multiple versions of data item definitions in a database comprises generating a first version of information relating to a plurality of data item definitions in the database, and generating a second version of information relating to a plurality of data item definitions in the database by recapturing only information relating to those data item definitions that have changed since the first version was generated.
Non-Repeating Random Values In User Specified Formats And Character Sets
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
Assignee:
Oracle International Corp. - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707 2, 707E17001
Abstract:
Systems, methodologies, media, and other embodiments associated with producing non-repeating random values for use in data masking are described. One example method includes accessing data describing a mask for a value in a database table column to be masked. The example method may also include identifying a number of distinct values in the database table column to be masked and determining a field width for a mask to provide unique random numbers to mask the distinct values. The method may include identifying locations in a mask value to store the unique random value and locations in a mask value to store filler values. The mask value may include different character sets and may comply with user specified formats. The method may include generating a set of statements that when executed produce a mapping table that includes masks for distinct values in the database table column to be masked.