Oracle International Corporation

Sap Se

Satish Sallakonda

Mary E G Bear

Arun Radhakrishnan

Stacy Chapman

Ravi Shankar Banda

Louise Diana Barnfield

Mark Preston Bennett

Vinay Babu Vegunta

Ravikumar Venkata Moolaveesla

Rambabu Dola

Chaya Bijani

Selvaganapathy Ayyamperumal

Jayavel Bharathi

A disparate data source aggregation system and methods are provided which may pull or retrieve talent data or features from disparate data sources, automatically correlate the data across the different data sources, build a self-adjusting system database that captures the talent data from the disparate data sources, and lets users search, query and build model insights on the aggregated data of the system database without human intervention. A method for disparate data source aggregation may include: extracting a first feature set having a first extracted feature and a second feature set having a second extracted feature; determining, if the first extracted feature of the first feature set matches the second extracted feature of the second feature set; and aggregating the first feature set with the second feature set if the first extracted feature of the first feature set matches the second extracted feature of the second feature set.

Systems and methods for disparate data source aggregation, self-adjusting data model and API

Confirming enforcement of business rules specified in a data access tier of a multi-tier enterprise application. In an embodiment, a testing tool programmatically identifies the attributes in the data access tier that are accessible from a set of higher/interface tiers and provides the identified attributes to a user using a suitable interface. The user then specifies a set of test cases based on the provided attributes, with each test case including data elements associated with respective attributes and an expected result if the data elements are sought to be stored in the respective attributes of a data storage. The testing tool determines a validation result of operation of business rules against the combination of data elements and respective attributes. The testing tool then indicates that the business rules are enforced as desired, if the validation result is the same as the expected result.

Confirming enforcement of business rules specified in a data access tier of a multi-tier application

Presented herein are systems and methods that facilitate the portability and management of user data maintained at two or more services. In embodiments, a configurable profile management interface or interfaces are provided to a user, which enable the user to identify data elements that may be maintained across one or more services. In embodiments, a user has the ability to set precedence values by identifying which elements from which service or services should be considered as sources of truth. In embodiments, those sources of truth may be used to propagate changes to one or more services. In embodiments, the profile synchronization functionality may be incorporated within a human resources (HR) system. In embodiments, the user can also configure a schedule for transferring data, can import some or all of the data, and/or can export all or some of the data.

Data management between multiple data sources

An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.

Offline validation of data in a database system for foreign key constraints

Growing community of inventors

Dublin, CA, United States of America

Satish Sallakonda