Multidimensional data cubes with high-cardinality attributes
    2.
    发明授权
    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
    10.
    发明申请
    Direct write back systems and methodologies 有权
    直接回写系统和方法

    公开(公告)号:US20060010143A1

    公开(公告)日:2006-01-12

    申请号:US11137232

    申请日:2005-05-25

    IPC分类号: G06F7/00

    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.

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