Oracle International Corporation

Andrew Bodge

Steven A Huberman

Jonathan A Bauer

Harish Akali

Ravi Pattabhi

Xiaolan Shen

Luming Han

Mahesh Subramanian

Techniques are described for generating automated advice with respect to consolidating a plurality of sources. A set of one or more parameters relating to a proposed consolidation for a plurality of consolidation sources is received. In response to receiving the set of one or more parameters, a set of one or more recommendations for consolidating the plurality of consolidation sources is generated and stored on at least one of a volatile or non-volatile computer-readable storage medium. The set of one or more recommendations may indicate how to improve a performance associated with consolidating the plurality of sources to a set of one or more destinations based on a particular consolidation scenario. The set of one or more recommendations may be displayed during consolidation planning for the plurality of consolidation sources.

Database consolidation advisor

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 comparing and re-comparing data item definitions

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.

Maintaining referential integrity while masking

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.

Non-repeating random values in user specified formats and character sets

A database synchronizer facilitates computing systems which have client-side and server-side applications that share data in similar database structures, but which do not maintain a continuous connection to a single shared data source. In general, a database synchronizer is used to share data among many nodes on the computing system. The database synchronizer is used to synchronize the data in a central database for a particular client with the data on that client's intermittently-connected computer. Updates performed by either client or server are propagated to the other side when a connection is established and eventually from the server to other clients in the system.

Growing community of inventors

Acton, MA, United States of America

Andrew Bodge