利索-全球专利检索

  1. 登录
  2. 注册
发明授权
CN103793422B 基于增强星型模型的立方体元数据及查询语句生成 有权

基于增强星型模型的立方体元数据及查询语句生成
摘要：
本发明公开了一种基于增强星型模型的立方体元数据生成及查询语句生成方法和装置。基于增强星型模型的立方体元数据生成方法包括：从包括事实表、事实表的多个维度表和非事实型事实表的增强星型模型中的非事实型事实表提取维度引用；根据维度引用构建层次结构引用；将层次结构引用与从事实表和维度表获得的度量及层次结构相结合而生成立方体元数据。本发明在元数据生成时与事实表和维度表一起直接使用非事实型事实表而不对其进行转换，由此省去现有技术中对非事实型事实表的转换中所需的人工工作、存储空间以及对IT/业务建模人员的知识的依赖性等。
摘要（英）：

A method for generating cube metadata based on an enhanced star schema may be provided. In some embodiments, the method may include extracting dimension references from a factless fact table in an enhanced star schema. The enhanced star schema may include a fact table, a plurality of dimension tables of the fact table and the factless fact table. In some embodiments, a hierarchy reference may be constructed based on the dimension references. In some embodiments, cube metadata may be generated by combining the hierarchy reference with measures obtained from the fact table and a hierarchy obtained from the dimension tables in the enhanced star schema.

公开/授权文献
0/0