Dynamically building and populating data marts with data stored in repositories
First Claim
Patent Images
1. A computer-implemented method for dynamically building and populating a data mart with data from a data repository, comprising:
- receiving a user configuration that specifies a data repository and an asset type in the data repository;
generating a schema for an intermediate data warehouse for storing data relevant to the asset type, wherein the data relevant to the asset type comprises at least one measures for at least one asset of the asset type and wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse;
populating the intermediate data warehouse by querying the data repository for the data relevant to the asset type;
generating a schema for a data mart corresponding to the asset type; and
populating the data mart by querying the intermediate data warehouse for the data relevant to the asset type.
1 Assignment
0 Petitions
Accused Products
Abstract
Methods, systems, and articles of manufacture for constructing and populating data marts with dimensional data models from a set of data repositories that contain factual and association information about a set of related assets are disclosed. An intermediate data warehouse is generated to process the facts and associations for each asset. Using the intermediate warehouse, one or more data marts are generated with fact tables, dimensions, and hierarchies to fully model the information available for each asset.
-
Citations
25 Claims
-
1. A computer-implemented method for dynamically building and populating a data mart with data from a data repository, comprising:
-
receiving a user configuration that specifies a data repository and an asset type in the data repository; generating a schema for an intermediate data warehouse for storing data relevant to the asset type, wherein the data relevant to the asset type comprises at least one measures for at least one asset of the asset type and wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse; populating the intermediate data warehouse by querying the data repository for the data relevant to the asset type; generating a schema for a data mart corresponding to the asset type; and populating the data mart by querying the intermediate data warehouse for the data relevant to the asset type. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer readable storage medium containing a program which, when executed, performs an operation for dynamically building and populating a data mart with data from a data repository, comprising:
-
receiving a user configuration that specifies a data repository and an asset type in the data repository; generating a schema for an intermediate data warehouse for storing data relevant to the asset type, wherein the data relevant to the asset type comprises at least one measure for at least one assets of the asset type and wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse; populating the intermediate data warehouse by querying the data repository for the data relevant to the asset type; generating a schema for a data mart corresponding to the asset type; and populating the data mart by querying the intermediate data warehouse for the data relevant to the asset type. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A system, comprising:
-
a processor; and a memory containing a program, which when executed by the processor is configured to perform an operation for dynamically building and populating a data mart with data from a data repository, comprising; receiving a user configuration that specifies a data repository and an asset type in the data repository; generating a schema for an intermediate data warehouse for storing data relevant to the asset type, wherein the data relevant to the asset type comprises at least one measure for at least one assets of the asset type; populating the intermediate data warehouse by querying the data repository for the data relevant to the asset type and wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse; generating a schema for a data mart corresponding to the asset type; and populating the data mart by querying the intermediate data warehouse for the data relevant to the asset type. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. A computer-implemented method for dynamically building and populating a plurality of data marts with data from a plurality of data repositories, comprising:
-
receiving user configuration input that specifies the plurality of data repositories and a plurality of asset types in the plurality of data repositories, wherein the specified plurality of data repositories contain;
(i) a plurality of assets of the specified plurality of asset types;
(ii) at least one association between assets of two asset types;
(iii) at least one asset group that groups assets based on the at least one association between two asset types; and
(iv) a plurality of measures of at least one measure type, wherein the plurality of measures contain values that describe the plurality of assets;generating a schema for an intermediate data warehouse for storing data relevant to the specified plurality of asset types, wherein the data relevant to the specified plurality of asset types comprises;
(i) at least one measure for at least one measure types for assets of the specified plurality of asset types;
(ii) at least one association between an asset of one asset type of the specified plurality of asset types and an asset of another asset type of the specified plurality of asset types; and
(iii) at least one asset group that groups assets of the specified plurality of asset types; and
wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse;populating the intermediate data warehouse by querying the specified plurality of data repositories for the data relevant to the specified plurality of asset types; generating, for each asset type of the specified plurality of asset types, a schema for a data mart corresponding to the respective asset type;
wherein the schema for the data mart comprises (i) a static dimension representing measure types and (ii) a static dimension representing time to allow versioning of records in the data mart;
wherein a static dimension is a dimension that exists in each of the plurality of data marts; andpopulating, for each asset type of the specified plurality of asset types, the data mart corresponding to the respective asset type by querying the intermediate data warehouse for the data relevant to the respective asset type. - View Dependent Claims (20, 21, 22)
-
-
23. A computer readable storage medium containing a program which, when executed, performs an operation for dynamically building and populating a data mart with data from a data repository, comprising:
-
receiving user configuration input that specifies the plurality of data repositories and a plurality of asset types in the plurality of data repositories, wherein the specified plurality of data repositories contain;
(i) a plurality of assets of the specified plurality of asset types;
(ii) at least one association between assets of two asset types;
(iii) at least one asset group that groups assets based on the at least one association between two asset types; and
(iv) a plurality of measures of at least one measure type, wherein the plurality of measures contain values that describe the plurality of assets;generating a schema for an intermediate data warehouse for storing data relevant to the specified plurality of asset types, wherein the data relevant to the specified plurality of asset types comprises;
(i) at least one measure for at least one measure type for assets of the specified plurality of asset types;
(ii) at least one association between an asset of one asset type of the specified plurality of asset types and an asset of another asset type of the specified plurality of asset types; and
(iii) at least one asset group that groups assets of the specified plurality of asset types; and
wherein the schema for the intermediate data warehouse comprises a timestamp to allow versioning of records in the intermediate data warehouse;populating the intermediate data warehouse by querying the specified plurality of data repositories for the data relevant to the specified plurality of asset types; generating, for each asset type of the specified plurality of asset types, a schema for a data mart corresponding to the respective asset type;
wherein the schema for the data mart comprises (i) a static dimension representing measure types and (ii) a static dimension representing time to allow versioning of records in the data mart;
wherein a static dimension is a dimension that exists in each of the plurality of data marts; andpopulating, for each asset type of the specified plurality of asset types, the data mart corresponding to the respective asset type by querying the intermediate data warehouse for the data relevant to the respective asset type. - View Dependent Claims (24, 25)
-
Specification