CPC G06F 16/212 (2019.01) [G06F 16/211 (2019.01); G06F 16/258 (2019.01); G06F 16/283 (2019.01); G06F 16/83 (2019.01); G06F 16/9024 (2019.01)] | 20 Claims |
1. A system for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment, comprising:
a computer that includes one or more microprocessors;
a multidimensional database server executing on the computer;
a cube schema inference component operating as a client to the multidimensional database server, wherein the cube schema inference component is configured to:
determine a relationship between each pair of a plurality of columns in tabular data received at the cube schema inference component;
construct a hierarchy directed graph using the determined relationships, wherein the construction of the hierarchy directed graph includes mapping columns of the plurality of columns to nodes of the hierarchy directed graph and mapping relationships determined between columns to edges connecting nodes of the hierarchy directed graph; and
autonomously transform the hierarchy directed graph into a cube schema for use in creating a cube in the multidimensional database server, wherein the transformation includes mapping, based on the hierarchy directed graph, each column of the plurality of columns in the tabular data is mapped to a cube element of the cube schema, the cube element including one of a measure, a flat hierarchy dimension, or a dimension hierarchy for a dimension of the cube, wherein the transformation further includes mapping one or more of the plurality of columns to measures and flat dimensions, and mapping others of the plurality of columns to dimension hierarchies.
|