公开(公告)号：US20240232216A1

公开(公告)日：2024-07-11

申请号：US18614571

申请日：2024-03-22

Applicant: Oracle International Corporation

Inventor： Dylan Wan ,  Francoise J. Lawrence ,  Justin Hyde ,  Amit Goyal ,  Saurabh Verma ,  John D. Poole

IPC: G06F16/25

CPC classification number: G06F16/254

Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

公开(公告)号：US20170116295A1

公开(公告)日：2017-04-27

申请号：US15299273

申请日：2016-10-20

Applicant: Oracle International Corporation

Inventor： Dylan Wan ,  Francoise J. Lawrence ,  Justin Hyde ,  Amit Goyal ,  Saurabh Verma ,  John D. Poole

IPC: G06F17/30

CPC classification number: G06F16/254

Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

公开(公告)号：US20200272635A1

公开(公告)日：2020-08-27

申请号：US16848632

申请日：2020-04-14

Applicant: Oracle International Corporation

Inventor： Dylan Wan ,  Francoise J. Lawrence ,  Justin Hyde ,  Amit Goyal ,  Saurabh Verma ,  John D. Poole

IPC: G06F16/25

Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

公开(公告)号：US20170069020A1

公开(公告)日：2017-03-09

申请号：US15251992

申请日：2016-08-30

Applicant: Oracle International Corporation

Inventor： Amit Goyal ,  Saurabh Verma ,  Ramy Yanetz ,  Mahendra Kumar ,  Vijay Aggarwal

IPC: G06Q40/02

CPC classification number: G06Q40/02

Abstract: A comparative reporting system provides financial benchmarking and analytics. Integrating public reporting and enterprise software systems, raw financial information from external sources derived from a plurality of reporting sources can be ingested and processed to extract attributes and metrics. The extracted attributes and metrics can be data warehoused together with financial information from the enterprise software system. Analytics can be performed to generate a comparison between the enterprise and the plurality of reporting sources.

Abstract translation: 比较报告系统提供财务基准和分析。 集成公共报告和企业软件系统，可以摄取并处理来自多个报告源的外部源的原始财务信息，以提取属性和度量。 提取的属性和度量可以与企业软件系统的财务信息一起存储在数据库中。 可以执行分析以生成企业与多个报告来源之间的比较。

公开(公告)号：US11966409B2

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

申请号：US16848632

申请日：2020-04-14

Applicant: Oracle International Corporation

Inventor： Dylan Wan ,  Francoise J. Lawrence ,  Justin Hyde ,  Amit Goyal ,  Saurabh Verma ,  John D. Poole

IPC: G06F16/25

CPC classification number: G06F16/254

Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.