US 11,789,964 B2
Load plan generation
Terrel Co Seng, San Bruno, CA (US); Saurabh Verma, Cupertino, CA (US); and Peter Songwen Xu, Palo Alto, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jan. 2, 2019, as Appl. No. 16/238,290.
Application 16/238,290 is a continuation of application No. 14/194,472, filed on Feb. 28, 2014, granted, now 10,206,770.
Claims priority of provisional application 61/843,289, filed on Jul. 5, 2013.
Prior Publication US 2019/0138532 A1, May 9, 2019
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01); B29C 48/00 (2019.01); B29C 48/02 (2019.01); A61F 2/00 (2006.01); A61L 27/18 (2006.01); A61L 27/48 (2006.01); A61L 31/06 (2006.01); B29C 71/00 (2006.01); D01D 5/088 (2006.01); D01D 5/098 (2006.01); D01D 5/16 (2006.01); D01F 6/62 (2006.01); D01F 6/84 (2006.01); D02G 3/02 (2006.01); B29K 67/00 (2006.01); B29L 31/00 (2006.01)
CPC G06F 16/254 (2019.01) [A61F 2/0063 (2013.01); A61L 27/18 (2013.01); A61L 27/48 (2013.01); A61L 31/06 (2013.01); B29C 48/00 (2019.02); B29C 48/02 (2019.02); B29C 71/0072 (2013.01); D01D 5/088 (2013.01); D01D 5/098 (2013.01); D01D 5/16 (2013.01); D01F 6/62 (2013.01); D01F 6/625 (2013.01); D01F 6/84 (2013.01); D02G 3/02 (2013.01); A61F 2002/0068 (2013.01); B29K 2067/00 (2013.01); B29L 2031/753 (2013.01); Y10T 428/1362 (2015.01); Y10T 428/1369 (2015.01); Y10T 428/249922 (2015.04); Y10T 442/10 (2015.04); Y10T 442/183 (2015.04); Y10T 442/184 (2015.04); Y10T 442/2525 (2015.04)] 21 Claims
OG exemplary drawing
 
1. A method for generating a load plan used to load data from a data source into a data warehouse, the method comprising:
invoking, by a computer system of a data integration system, a load plan generator, wherein the load plan generator orchestrates loading data from one or more sources into one or more data warehouses to execute a package sequence in a runtime environment and is configured to use metadata stored in a repository of the data integration system, wherein the repository of the metadata is shared by the data integration system and the load plan generator;
receiving, at the computer system, one or more data source definitions each of the one or more data source definitions specifying the data source from which to load data into the data warehouse, a fact group associated with the data source, and a dimension group associated with the data source, wherein the fact group comprises factual information regarding dimensions in the dimension group, and wherein the dimension group comprises dependency information for the factual information in the fact group, and wherein the dimension group represents a hierarchical arrangement of the data; and
configuring, with a processor associated with the computer system, for each data source definition in the one or more data source definitions, a phase with a plurality of predefined load plan components based on the data source of the data source definition satisfying one or more design dependencies, wherein each of the plurality of predefined load plan components specifies a task indicative of how data is to be loaded between the data source and the data warehouse, wherein the plurality of predefined load plan components are configured dynamically based on load plan rules, and wherein the plurality of predefined load plan components resolve local dependencies within the fact group or dimension group, and
wherein the computer system determines how to load data to the data warehouse based on a type of a load plan component.