公开(公告)号：US20200334089A1

公开(公告)日：2020-10-22

申请号：US16852509

申请日：2020-04-19

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagan Narayanareddy ,  Gunaranjan Vasireddy ,  Aman Madaan

IPC: G06F9/50 ,  G06F9/455 ,  G06F16/25

Abstract: 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).

公开(公告)号：US11614976B2

公开(公告)日：2023-03-28

申请号：US16853428

申请日：2020-04-20

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagan Narayanareddy ,  Gunaranjan Vasireddy ,  Aman Madaan

IPC: G06F9/50 ,  G06F9/455 ,  G06F16/25 ,  G06F16/28 ,  G06F9/54

Abstract: 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).

公开(公告)号：US11573974B2

公开(公告)日：2023-02-07

申请号：US16852065

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy ,  Jagan Narayanareddy ,  Sai Rajendra Vadakattu

IPC: G06F16/25 ,  G06N5/02 ,  G06F16/215 ,  G06F16/21

Abstract: 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.

公开(公告)号：US20200334271A1

公开(公告)日：2020-10-22

申请号：US16853428

申请日：2020-04-20

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagan Narayanareddy ,  Gunaranjan Vasireddy ,  Aman Madaan

IPC: G06F16/25 ,  G06F16/28 ,  G06F9/455 ,  G06F9/54 ,  G06F9/50

Abstract: 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).

公开(公告)号：US20200334268A1

公开(公告)日：2020-10-22

申请号：US16852065

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy ,  Jagan Narayanareddy ,  Sai Rajendra Vadakattu

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/215 ,  G06N5/02

Abstract: 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.