Multidimensional data cubes with high-cardinality attributes
    4.
    发明授权
    Multidimensional data cubes with high-cardinality attributes 有权
    具有高基数属性的多维数据立方体

    公开(公告)号:US08380748B2

    公开(公告)日:2013-02-19

    申请号:US12042674

    申请日:2008-03-05

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30592

    摘要: Computer-readable media, systems, and methods for building a multidimensional data cube having one or more high-cardinality attributes are described. In embodiments, data is extracted from one or more databases. It is determined that one or more instances of the data are fact data and one or more instances of the data are dimension data. Each member of the fact data is one instance of a dimension and each instance of the dimension data includes an attribute for grouping the fact data. Moreover, in embodiments it is determined that one or more instances of the dimension data are high-cardinality attributes. The one or more high-cardinality attributes are processed with fact data and stored in fact tables on a computer storage medium.

    摘要翻译: 描述了用于构建具有一个或多个高基数属性的多维数据立方体的计算机可读介质,系统和方法。 在实施例中,从一个或多个数据库提取数据。 确定数据的一个或多个实例是事实数据,并且数据的一个或多个实例是尺寸数据。 事实数据的每个成员是维度的一个实例,维数据的每个实例包括用于对事实数据进行分组的属性。 此外,在实施例中,确定尺寸数据的一个或多个实例是高基数属性。 一个或多个高基数属性用事实数据处理并存储在计算机存储介质上的事实表中。

    Direct write back systems and methodologies
    8.
    发明授权
    Direct write back systems and methodologies 有权
    直接回写系统和方法

    公开(公告)号:US07873669B2

    公开(公告)日:2011-01-18

    申请号:US11137232

    申请日:2005-05-25

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30592

    摘要: Provided are systems and methods that facilitate direct write back in a multi-dimensional database. The system includes a delta cache component that receives a user request to change an original cell value and determines a delta value based at least in part upon the changed cell value. Also included is a write back partition component that selectively updates a data cell based at least in part upon the delta value without updating corresponding data cell values. The system and methods allow attributes to be added to any dimension of a cube without affecting the write back data. Adding, modifying or removing a hierarchy has no affect on write back data nor does deleting a dimension that is not referenced by a write back.

    摘要翻译: 提供了便于在多维数据库中直接回写的系统和方法。 该系统包括增量缓存组件,其接收用户请求以改变原始小区值,并且至少部分地基于所改变的小区值来确定增量值。 还包括写回分区组件,其至少部分地基于增量值来选择性地更新数据单元,而不更新对应的数据单元值。 系统和方法允许将属性添加到多维数据集的任何维度,而不会影响回写数据。 添加,修改或删除层次结构对回写数据没有影响,也不会删除未被回写引用的维。

    System and method for analytically modeling data organized according to non-referred attributes
    9.
    发明授权
    System and method for analytically modeling data organized according to non-referred attributes 有权
    根据非参考属性组织的分析建模数据的系统和方法

    公开(公告)号:US07275022B2

    公开(公告)日:2007-09-25

    申请号:US10199612

    申请日:2002-07-19

    IPC分类号: G06F17/10 G06F7/60

    摘要: A system and method for analytically modeling data organized according to non-referred attributes is disclosed. Data stored in a first and a second relational data table is analytically modeled in a data cube. The first table organizes a first type according to a first attribute. The second table organizes a second type according to the first attribute and a second attribute. A first measure is modeled according to the first type of the first table. A first dimension is modeled according to the first attribute of the first and second tables. A second dimension is modeled according to the second attribute of the second table. The first measure is tied to the first dimension according to the first attribute of the first table to allow the first measure to be analyzed by the first dimension according to the first attribute. The first measure is tied to the second dimension by, for each entry of the first dimension, allocating the entry to each entry of the second dimension in a predetermined manner.

    摘要翻译: 公开了一种用于根据非参考属性组织的分析建模数据的系统和方法。 存储在第一和第二关系数据表中的数据在数据立方体中被分析地建模。 第一个表根据第一个属性组织第一个类型。 第二表根据第一属性和第二属性组织第二类。 第一个度量根据第一个表的第一个类型进行建模。 根据第一和第二表的第一属性对第一维进行建模。 根据第二表的第二属性对第二维进行建模。 根据第一表的第一个属性,第一个度量与第一个维度相关联,以便根据第一个属性对第一个维度进行第一个维度的分析。 对于第一维度的每个条目,第一尺度与第二维度相关联,以预定方式将条目分配给第二维度的每个条目。