US 12,032,532 B2
System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment
Dima Alberg, Be'er Sheva (IL); Victor Belyaev, San Jose, CA (US); Guy Shaked, Be'er Sheva (IL); and Gabby Rubin, Sunnyvale, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Nov. 20, 2020, as Appl. No. 17/100,599.
Application 17/100,599 is a continuation of application No. 15/332,769, filed on Oct. 24, 2016, granted, now 10,846,273, issued on Nov. 24, 2020.
Claims priority of provisional application 62/245,885, filed on Oct. 23, 2015.
Prior Publication US 2021/0073188 A1, Mar. 11, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01); G06F 16/83 (2019.01); G06F 16/901 (2019.01)
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
OG exemplary drawing
 
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.