首页>
外国专利>
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.
展开▼