US 2021/0173846 A1 · SYSTEM AND METHOD FOR AUTOMATIC GENERATION OF BI MODELS USING DATA INTROSPECTION AND CURATION

Abstract

In accordance with an embodiment, described herein are systems and methods for automatic generation of business intelligence (BI) data models using data introspection and curation, as may be used, for example, with enterprise resource planning (ERP) or other enterprise computing or data analytics environments. The described approach uses a combination of manually-curated artifacts, and automatic generation of a model through data introspection, of a source data environment, to derive a target BI data model. For example, a pipeline generator framework can evaluate the dimensionality of a transaction type, degenerate attributes, and application measures; and use the output of this process to create an output target model and pipeline or load plan. The systems and methods described herein provide a technical improvement in the building of new subject areas or a BI data model within much shorter periods of time.

Claims15

Dependent claims

A system for automatic generation of data models using data introspection and curation, comprising:

a computer including one or more processors, that provides access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants;
wherein the system provides a generator framework operable to:
generate automatically one or more data maps associated with a source data environment, by reference to a source model associated with the source data environment, wherein an automatic generation process includes use of curated artifacts and automatically-determined or interpreted variables;
generate a data model for transaction types associated with the source data environment, including determining dimensions and facts associated with the source data to generate a semantic model;
overlay the generated semantic model with security artifacts that control data visibility;
and
generate readable format data, for use in creating reports.

4 more elements

A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform a method comprising:

providing access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants;
generating automatically one or more data maps associated with a source data environment, by reference to a source model associated with the source data environment, wherein an automatic generation process includes use of curated artifacts and automatically-determined or interpreted variables;
generating a data model for transaction types associated with the source data environment, including determining dimensions and facts associated with the source data to generate a semantic model;
overlaying the generated semantic model with security artifacts that control data visibility;
and
generating readable format data, for use in creating reports.

3 more elements

Dependencies are inferred from the claim text.

System and method for automatic generation of bi models using data introspection and curation

Life of this patent

System and method for automatic generation of bi models using data introspection and curation

Life of this patent

Abstract

Claims15