Joseph P Klein

US Patent:

20140344310, Nov 20, 2014

Filed:

Nov 11, 2013

Appl. No.:

14/077140

Inventors:

- Redwood Shores CA, US
David Allan - Mountain View CA, US
John Leigh - San Mateo CA, US
Thomas Lau - Mountain View CA, US
Joseph F. Klein - Eagan MN, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707803

Abstract:

In various embodiments, a data integration system is disclosed which enables users to create a logical design which is platform and technology independent. The user can create a logical design that defines, at a high level, how a user wants data to flow between sources and targets. The tool can analyze the logical design, in view of the user's infrastructure, and create a physical design. The logical design can include a plurality of components corresponding to each source and target in the design, as well as operations such as joins or filters, and access points. Each component when transferred to the physical design generates code to perform operations on the data. Depending on the underlying technology (e.g., SQL Server, Oracle, Hadoop, etc.) and the language used (SQL, pig, etc.) the code generated by each component may be different.