公开(公告)号：US20170011087A1

公开(公告)日：2017-01-12

申请号：US15157127

申请日：2016-05-17

Applicant: Oracle International Corporation

Inventor： Justin Hyde ,  Jeff Titmas ,  Gunaranjan Vasireddy

IPC: G06F17/30

CPC classification number: G06F16/254 ,  G06F16/211 ,  G06F16/2365

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

Abstract translation: 在各种实施例中，公开了一种数据集成系统，其能够通过利用在数据仓库处的依赖于源的数据存储来将数据加载到数据仓库中的动态切换。

公开(公告)号：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).

公开(公告)号：US20170161344A1

公开(公告)日：2017-06-08

申请号：US15182320

申请日：2016-06-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy

IPC: G06F17/30

CPC classification number: G06F16/254 ,  G06F16/283

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

公开(公告)号：US11615108B2

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

申请号：US16852070

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy ,  Phani Krishna Somayajula

IPC: G06F16/25 ,  G06F16/28 ,  G06F9/50 ,  G06F16/182 ,  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.

公开(公告)号：US20190303380A1

公开(公告)日：2019-10-03

申请号：US16446076

申请日：2019-06-19

Applicant: Oracle International Corporation

Inventor： Justin Hyde ,  Jeff Titmas ,  Gunaranjan Vasireddy

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/23

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

公开(公告)号：US11853313B2

公开(公告)日：2023-12-26

申请号：US15182320

申请日：2016-06-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy

IPC: G06F16/25 ,  G06F16/28

CPC classification number: G06F16/254 ,  G06F16/283

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

公开(公告)号：US20200334270A1

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

申请号：US16852070

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Gunaranjan Vasireddy ,  Phani Krishna Somayajula

IPC: G06F16/25 ,  G06F16/28 ,  G06F16/21 ,  G06F16/182 ,  G06F9/50

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.

公开(公告)号：US10360231B2

公开(公告)日：2019-07-23

申请号：US15157127

申请日：2016-05-17

Applicant: Oracle International Corporation

Inventor： Justin Hyde ,  Jeff Titmas ,  Gunaranjan Vasireddy

IPC: G06F17/30 ,  G06F16/25 ,  G06F16/21 ,  G06F16/23

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

公开(公告)号：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.