Load plan generation
AssigneeOracle International Corporation
InventorsTerrel Co Seng, Saurabh Verma, Peter Songwen Xu
Life of this patent
Estimating the term…
Abstract
Load Plan Generator (LPG) is a BIAPPS utility for generating ODI load plans based on desired subset of fact tables for loading BIAPPS Data Warehouse. The tool simplifies the configurations process by minimizing the manual steps and configurations and provides a guided list of configurations steps and checklists. The load plan components can include different sets of load plans that will be stitched together by the load plan generator to create one load plan for loading chosen fact groups in the warehouse sourcing from different transaction systems.
Claims20
A method for generating a load plan used to load data from a data source into a data warehouse, the method comprising:
- receiving, at a computer system, one or more data source definitions each specifying one or more data sources from which to load data into a data warehouse, one or more fact groups associated with the one or more data sources, and one or more dimension groups associated with the one or more data sources;
- and
- configuring, with a processor associated with the computer system, for each data source definition in the one or more data source definitions, one or more phases with one or more of a plurality of predefined load plan components based on the one or more data sources of the data source definition satisfying one or more design dependencies, wherein each of the plurality of predefined load plan components specifies one or more tasks indicative of how data is to be loaded between the data source and the data warehouse.
A non-transitory computer-readable medium comprising instructions which, when executed by one or more processors of a computer system, causes the one or more processors to generate a load plan used to load data from a data source into a data warehouse, the instructions comprising:
- receive one or more data source definitions each specifying one or more data sources from which to load data into a data warehouse, one or more fact groups associated with the one or more data sources, and one or more dimension groups associated with the one or more data sources;
- and
- configure one or more phases with one or more of a plurality of predefined load plan components based on the one or more data sources of the data source definition satisfying one or more design dependencies, wherein each of the plurality of predefined load plan components specifies one or more tasks indicative of how data is to be loaded between the one or more data sources and the data warehouse.
A system for generating a load plan used to load data from a data source into a data warehouse, the system comprising:
- one or more processors;
- and
- a memory storing a set of instructions which when executed by the one or more processors causes the one or more processors to:
- receive one or more data source definitions each specifying one or more data sources from which to load data into a data warehouse, one or more fact groups associated with the one or more data sources, and one or more dimension groups associated with the one or more data sources;
- and
- configure one or more phases with one or more of a plurality of predefined load plan components based on the one or more data sources of the data source definition satisfying one or more design dependencies, wherein each of the plurality of predefined load plan components specifies one or more tasks indicative of how data is to be loaded between a data source and a data warehouse.
Dependencies are inferred from the claim text.