首页>
外国专利>
SYSTEM AND METHOD FOR AUTOMATIC INFERENCE OF A CUBE SCHEMA FROM A TABULAR DATA FOR USE IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT
SYSTEM AND METHOD FOR AUTOMATIC INFERENCE OF A CUBE SCHEMA FROM A TABULAR DATA FOR USE IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT
展开▼
机译:从多维数据集数据自动推断多维数据集模式的系统和方法,用于多维数据库环境
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼