公开(公告)号：US20240257019A1

公开(公告)日：2024-08-01

申请号：US18632114

申请日：2024-04-10

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagdish Chand ,  Aman Madaan

IPC: G06Q10/0637 ,  G06F16/21 ,  G06F16/25 ,  G06F16/27 ,  G06F16/28 ,  G06F17/18 ,  G06N5/04 ,  G06Q30/0201

CPC classification number: G06Q10/06375 ,  G06F16/211 ,  G06F16/254 ,  G06F16/27 ,  G06F16/283 ,  G06F17/18 ,  G06N5/04 ,  G06Q30/0201 ,  G06Q30/0206

Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for determination of recommendations and alerts in such environments. A data pipeline or process can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. When provided as part of a software-as-a-service (SaaS) or cloud environment, the data sourced from a plurality of organizations can be aggregated, to leverage information gleaned from the collective or shared data. The system can be used to generate semantic alerts, including obtaining permission from; and analyzing the collective data of; the plurality of organizations, to determine operational advantages indicated by the data, and providing alerts associated with those operational advantages.

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

公开(公告)号：US11966870B2

公开(公告)日：2024-04-23

申请号：US16851872

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagdish Chand ,  Aman Madaan

IPC: G06Q10/0637 ,  G06F16/21 ,  G06F16/25 ,  G06F16/27 ,  G06F16/28 ,  G06F17/18 ,  G06N5/04 ,  G06Q30/0201

CPC classification number: G06Q10/06375 ,  G06F16/211 ,  G06F16/254 ,  G06F16/27 ,  G06F16/283 ,  G06F17/18 ,  G06N5/04 ,  G06Q30/0201 ,  G06Q30/0206

Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for determination of recommendations and alerts in such environments. A data pipeline or process can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. When provided as part of a software-as-a-service (SaaS) or cloud environment, the data sourced from a plurality of organizations can be aggregated, to leverage information gleaned from the collective or shared data. The system can be used to generate semantic alerts, including obtaining permission from; and analyzing the collective data of; the plurality of organizations, to determine operational advantages indicated by the data, and providing alerts associated with those operational advantages.

公开(公告)号：US20200334267A1

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

申请号：US16851869

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Gangadhar Ronanki ,  Aman Madaan

IPC: G06F16/25 ,  G06F16/28 ,  G06F16/21 ,  G06F17/18

Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.

公开(公告)号：US20210049183A1

公开(公告)日：2021-02-18

申请号：US17076164

申请日：2020-10-21

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Aman Madaan ,  Somashekhar Pammar

IPC: G06F16/25 ,  G06F16/28 ,  G06F16/22 ,  G06F16/2457

Abstract: In accordance with various embodiments, described herein are systems and methods for use with an analytic applications environment, for ranking of database tables for use in controlling extract, transform, load (ETL) processes. In accordance with an embodiment, the system uses a ranking algorithm or process to rank database tables and/or table columns associated with a set of data. The table/column rankings can then be used to prioritize ETL processing of a customer's data for use with a data warehouse or other data analytics environment. In accordance with an embodiment, the method includes determining a global rank; a business rank; and a tenant or customer-specific rank, for a plurality of tables and columns in a customer's database; and aggregating or otherwise using the determined rankings to control the ETL process for a particular customer (tenant), to load their data into the data warehouse.

公开(公告)号：US12248490B2

公开(公告)日：2025-03-11

申请号：US17076164

申请日：2020-10-21

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Aman Madaan ,  Somashekhar Pammar

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/2457 ,  G06F16/28

Abstract: In accordance with various embodiments, described herein are systems and methods for use with an analytic applications environment, for ranking of database tables for use in controlling extract, transform, load (ETL) processes. In accordance with an embodiment, the system uses a ranking algorithm or process to rank database tables and/or table columns associated with a set of data. The table/column rankings can then be used to prioritize ETL processing of a customer's data for use with a data warehouse or other data analytics environment. In accordance with an embodiment, the method includes determining a global rank; a business rank; and a tenant or customer-specific rank, for a plurality of tables and columns in a customer's database; and aggregating or otherwise using the determined rankings to control the ETL process for a particular customer (tenant), to load their data into the data warehouse.

公开(公告)号：US11803798B2

公开(公告)日：2023-10-31

申请号：US16851869

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Gangadhar Ronanki ,  Aman Madaan

IPC: G06F16/27 ,  G06Q10/0637 ,  G06F16/28 ,  G06Q30/0201 ,  G06N5/04 ,  G06F16/21 ,  G06F16/25 ,  G06F17/18

CPC classification number: G06Q10/06375 ,  G06F16/211 ,  G06F16/254 ,  G06F16/27 ,  G06F16/283 ,  G06F17/18 ,  G06N5/04 ,  G06Q30/0201 ,  G06Q30/0206

Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.

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

公开(公告)号：US20200334608A1

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

申请号：US16851872

申请日：2020-04-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Krishnan Ramanathan ,  Jagdish Chand ,  Aman Madaan

IPC: G06Q10/06 ,  G06F16/27 ,  G06F16/28 ,  G06N5/04 ,  G06Q30/02 ,  G06Q30/00

Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for determination of recommendations and alerts in such environments. A data pipeline or process can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. When provided as part of a software-as-a-service (SaaS) or cloud environment, the data sourced from a plurality of organizations can be aggregated, to leverage information gleaned from the collective or shared data. The system can be used to generate semantic alerts, including obtaining permission from; and analyzing the collective data of; the plurality of organizations, to determine operational advantages indicated by the data, and providing alerts associated with those operational advantages.

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