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

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