Back to results
US 10,885,051 B1Granted
Automatic data warehouse generation using automatically generated schema
AssigneeInfor (US), Inc.
InventorsBradley S. Peters, Paul H. Staelin, Stefan M. Schmitz
Life of this patent
Estimating the term…
Abstract
Techniques for automatic data warehouse generation are disclosed herein. A first data set is received. The first data set includes a plurality of tables and includes a plurality of keys. A dimensional model is mapped onto the first data set. A schema is automatically generated based on the dimensional model.
Claims17
A system, comprising:
- a processor configured to:
- receive source data;
- derive metadata from the received source data, where to derive the metadata the processor is configured to:
- determine for a table in the source data, a grain of the table, where the grain of the table defines what data records of the table represent and a set of levels associated with the data records of the table;
- determine for a column in the source data, a target dimension and level;
- determine whether the column is a measure;
- and
- determine one or more dimensional hierarchies, based on the determined grain of the table, where one or more levels of the one or more dimensional hierarchies are designated to be transformed into dimension tables;
- generate a database schema using the derived metadata, including generation of:
- a measure table for each grain, based upon the determination of which columns in the source data are measures, the measure table including metrics to be aggregated;
- and
- a dimension table based at least in part on the determination of the one or more dimensional hierarchies, and on an overview of all columns of the source data, wherein, each column having a grain in the target dimension and at or above a pre-determined level is a target, the dimension table being generated based on the target columns, where the dimension table includes a grouping of the metrics;
- and
- a memory coupled to the processor and configured to provide the processor with instructions.
11 more elements
A method, comprising:
- receiving source data;
- and
- deriving metadata from the received source data, where deriving the metadata includes the steps of:
- determining, for a table in the source data, a grain of the table, where the grain of the table defines what data records of the table represent and a set of levels associated with the data records of the table;
- determining, for a column in the source data, a target dimension and level;
- determining whether the column is a measure;
- determining one or more dimensional hierarchies, based on the determined grain of the table, where one or more levels of the one or more dimensional hierarchies are designated to be transformed into dimension tables;
- and
- generating a database schema using the derived metadata, including generation of:
- a measure table for each grain, based upon the determination of which columns in the source data are measures, the measure table including metrics to be aggregated;
- and
- a dimension table based at least in part on the determination of the one or more dimensional hierarchies, and on an overview of all columns of the source data, wherein, each column having a grain in the target dimension and at or above a pre-determined level is a target, the dimension table being generated based on the target columns, where the dimension table includes a grouping of the metrics.
9 more elements
A computer program product embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
- receiving source data;
- and
- deriving metadata from the received source data, where deriving the metadata includes the steps of:
- determining, for a table in the source data, a grain of the table, where the grain of the table defines what data records of the table represent and a set of levels associated with the data records of the table;
- determining, for a column in the source data, a target dimension and level;
- determining whether the column is a measure;
- determining one or more dimensional hierarchies, based on the determined grain of the table, where one or more levels of the one or more dimensional hierarchies are designated to be transformed into dimension tables;
- and
- generating a database schema using the derived metadata, including generation of:
- a measure table for each grain, based upon the determination of which columns in the source data are measures, the measure table including metrics to be aggregated;
- and
- a dimension table based at least in part on the determination of the one or more dimensional hierarchies, and on an overview of all columns of the source data, wherein, each column having a grain in the target dimension and at or above a pre-determined level is a target, the dimension table being generated based on the target columns, where the dimension table includes a grouping of the metrics.
9 more elements
Dependencies are inferred from the claim text.