EP 3365810 B1 20210818 - SYSTEM AND METHOD FOR AUTOMATIC INFERENCE OF A CUBE SCHEMA FROM A TABULAR DATA FOR USE IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT
Title (en)
SYSTEM AND METHOD FOR AUTOMATIC INFERENCE OF A CUBE SCHEMA FROM A TABULAR DATA FOR USE IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT
Title (de)
SYSTEM UND VERFAHREN ZUR AUTOMATISCHEN ERSTELLUNG EINES CUBE SCHEMAS AUS TABULARDATEN IN EINER MEHRDIMENSIONALEN DATENBANK
Title (fr)
SYSTEME ET METHODE POUR LA GENERATION AUTOMATISEE D'UN SCHEMA CUBE A PARTIR DES DONNEES TABULAIRE DANS UN ENVIRONNEMENT MULTI-DIMENSIONALE
Publication
Application
Priority
- US 201562245885 P 20151023
- US 2016058209 W 20161021
Abstract (en)
[origin: WO2017070533A1] In accordance with an embodiment, described herein is a system and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment. A cube schema inference component can successively perform column-wise splits to calculate information gain ratios between each pair of a plurality of columns in the tabular data. A cross correlation matrix can be constructed from the information gain ratios between each pair of columns. The system can determine relationships among the plurality of columns based on the cross correlation matrix; create a hierarchy directed graph to represent the relationships; and further transform the hierarchy directed graph into a cube schema that can be used to create a cube for loading the tabular data, or to map the tabular data into an existing cube in the multidimensional database environment.
IPC 8 full level
G06F 16/21 (2019.01); G06F 16/28 (2019.01)
CPC (source: EP US)
G06F 16/211 (2018.12 - EP US); G06F 16/212 (2018.12 - EP US); G06F 16/258 (2018.12 - US); G06F 16/283 (2018.12 - EP US); G06F 16/83 (2018.12 - US); G06F 16/9024 (2018.12 - US); G06F 16/9024 (2018.12 - EP)
Designated contracting state (EPC)
AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR
DOCDB simple family (publication)
WO 2017070533 A1 20170427; CN 107533570 A 20180102; CN 107533570 B 20201103; EP 3365810 A1 20180829; EP 3365810 B1 20210818; JP 2018536909 A 20181213; JP 6846356 B2 20210324; US 10846273 B2 20201124; US 2017116228 A1 20170427; US 2021073188 A1 20210311
DOCDB simple family (application)
US 2016058209 W 20161021; CN 201680025687 A 20161021; EP 16788921 A 20161021; JP 2017558695 A 20161021; US 201615332769 A 20161024; US 202017100599 A 20201120