ETL tool utilizing dimension trees
First Claim
Patent Images
1. A computer-implemented method comprising:
- identifying a plurality of dimensions associated with one or more databases;
creating a plurality of dimension trees based on the plurality of dimensions;
creating an ETL (Extract, Transform and Load) pyramid having a number of levels;
linking the plurality of dimension trees to corresponding levels of the ETL pyramid; and
creating a table for each level of the ETL pyramid to store a subset of the plurality of dimension trees that is linked to a corresponding level of the ETL pyramid.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and apparatus for an ETL tool utilizing dimension trees. The method may include identifying various dimensions associated with one or more databases, and creating dimension trees based on these dimensions. The method may further include creating an ETL pyramid having multiple levels, linking the dimension trees to corresponding levels of the ETL pyramid, and creating a table for each level of the ETL pyramid to store a subset of the dimension trees that is linked to a corresponding level of the ETL pyramid.
-
Citations
21 Claims
-
1. A computer-implemented method comprising:
-
identifying a plurality of dimensions associated with one or more databases; creating a plurality of dimension trees based on the plurality of dimensions; creating an ETL (Extract, Transform and Load) pyramid having a number of levels; linking the plurality of dimension trees to corresponding levels of the ETL pyramid; and creating a table for each level of the ETL pyramid to store a subset of the plurality of dimension trees that is linked to a corresponding level of the ETL pyramid. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system comprising:
-
a dimension and tree creator to identify a plurality of dimensions associated with one or more databases, and to create a plurality of dimension trees based on the plurality of dimensions; and a pyramid creator, coupled to the dimension and tree creator, to create an ETL (Extract, Transform and Load) pyramid having a number of levels, to link the plurality of dimension trees to corresponding levels of the ETL pyramid, and to create a table for each level of the ETL pyramid to store a subset of the plurality of dimension trees that is linked to a corresponding level of the ETL pyramid. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A computer readable storage medium including instructions that, when executed by a processing system, cause the processing system to perform a method comprising:
-
identifying a plurality of dimensions associated with one or more databases; creating a plurality of dimension trees based on the plurality of dimensions; creating an ETL (Extract, Transform and Load) pyramid having a number of levels; linking the plurality of dimension trees to corresponding levels of the ETL pyramid; and creating a table for each level of the ETL pyramid to store a subset of the plurality of dimension trees that is linked to a corresponding level of the ETL pyramid. - View Dependent Claims (18, 19, 20, 21)
-
Specification