ETL tool utilizing dimension trees

摘要

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.

主权项

1. A computer-implemented method comprising:
identifying, by a computer system, 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; providing a user interface facilitating user input specifying dimensions and dimension trees for individual levels within the number of levels of the ETL pyramid; linking the plurality of dimensions and the plurality of dimension trees to the number of levels of the ETL pyramid based on the user input, wherein the levels of the ETL pyramid include components comprising one or more of the plurality of dimension trees, one or more dimensions from the plurality of dimension trees and one or more dimensions that are not part of any of the plurality of dimension trees; 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.