首页> 外国专利> 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.
机译:根据一个实施例,本文描述了一种用于从表格数据自动推断多维数据集模式以供在多维数据库环境中使用的系统和方法。多维数据集架构推断组件可以依次执行按列拆分,以计算表格数据中多个列的每对之间的信息增益比。可以从每对列之间的信息增益比率构造互相关矩阵。该系统可以基于互相关矩阵确定多个列之间的关系。创建一个层次结构有向图来表示关系;并进一步将层次结构有向图转换为多维数据集架构,可用于创建用于加载表格数据的多维数据集,或将表格数据映射到多维数据库环境中的现有多维数据集。

著录项

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号