Oracle International Corporation

Gunaranjan Vasireddy

Justin Hyde

Jeff Titmas

Jagan Narayanareddy

Krishnan Ramanathan

Aman Madaan

Sai Rajendra Vadakattu

Phani Krishna Somayajula

In accordance with an embodiment, an intelligent load plan that can automatically ensure that a system is in a runnable state and no other conflicting activity can affect the results of the data loads, such as ETLs. Such an intelligent load plan can be used in on data warehousing solutions as well as on a cloud data warehouse solution. The intelligent load plan can, in some embodiments, automatically detect situations based on which it knows it is not supposed to run the load plan.

System and method for load plan intelligent run in a multidimensional database

In accordance with an embodiment, described herein are systems and methods for determining or allocating an amount, quantity, or number of compute instances or virtual machines for use with extract, transform, load (ETL) processes. In an example embodiment, a particular (e.g., optimal) number of virtual machines (VM's) can be determined by predicting ETL completion times for customers, using historical data. ETL processes can be simulated with an initial/particular number of virtual machines. If the predicted duration is greater than the desired duration, the number of virtual machines can be incremented, and the simulation repeated. Actual completion times from ETL processes can be fed back, to update a determined number of compute instances or virtual machines. In accordance with an embodiment, the system can be used, for example, to generate alerts associated with customer service level agreements (SLA's).

System and method for determining an amount of virtual machines for use with extract, transform, load (ETL) processes

Systems and methods for automatic error rejection are provided. Systems and methods described herein bypass the creation of a staging table at the outset and, instead, attempt a direct merge from a source data location to a target data location. In the event that the merge fails, then a temporary/staging table can be loaded where errors can be logged, validations can be performed, and erroneous data can be corrected.

System and method for running warehouse loads for multiple tenants of a data warehouse

System and method for automatic correction/rejection in an analysis applications environment

In various embodiments, a data integration system is disclosed which enables dynamically switching between sources for loading data into a data warehouse by utilizing a source-dependent data store at the data warehouse.

Growing community of inventors

Hyderabad Telangana, India

Gunaranjan Vasireddy