Multidimensional database system with intermediate lockable intersections
    1.
    发明授权
    Multidimensional database system with intermediate lockable intersections 有权
    具有中间可锁定交叉点的多维数据库系统

    公开(公告)号:US06658413B1

    公开(公告)日:2003-12-02

    申请号:US09653107

    申请日:2000-08-31

    IPC分类号: G06F1730

    摘要: A multi-dimensional database includes hierarchical levels. The data is hierarchical, with aggregatable data measures, so that changes in a first intersection will cause changes in other intersections for the aggregated measure. Selected intersections can be locked, so that changes in aggregatable data are restricted. Constrained sets corresponding to the locked intersections limit the scope of changes which may be made, and ensure a high level of efficiency.

    摘要翻译: 多维数据库包括分层级别。 数据是分层的,具有可聚合数据测量,因此第一个交叉点的更改将导致聚合度量的其他交点的更改。 可以锁定所选的交点,以便可聚合数据的更改受到限制。 对应于锁定交叉口的约束集限制了可能发生的变化的范围,并确保高效率。

    Configurable space-time performance trade-off in multidimensional data base systems
    2.
    发明授权
    Configurable space-time performance trade-off in multidimensional data base systems 有权
    多维数据库系统中可配置的时空性能折衷

    公开(公告)号:US06839711B1

    公开(公告)日:2005-01-04

    申请号:US09652520

    申请日:2000-08-31

    IPC分类号: G06F17/30 G06F17/00

    摘要: A multi-dimensional database includes data organized into hierarchical levels. For each level within a dimension, predefined thresholds are set to determine which intersections are precomputed and which are not. The general result is to precompute intersections which take relatively longer to compute at run time, and to not precompute intersections which can be calculated relatively quickly at run time. When multiple dimensions of data are provided, a step-by-step process uses the level threshold for each dimension to determine whether data is to be prestored at an intersection. An odd-even calculation insures that computations performed at run time are relatively efficient. The technique results in good run time response, while not requiring maximum storage or recalculation time for data updates. By adjusting the thresholds at the individual dimension level, response of the multi-dimensional database can be changed as desired.

    System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment
    3.
    发明授权
    System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment 有权
    用于在在线分析处理(OLAP)环境中提供横向计算和数据访问的系统和方法

    公开(公告)号:US06574619B1

    公开(公告)日:2003-06-03

    申请号:US09535905

    申请日:2000-03-24

    IPC分类号: G06R1730

    摘要: A system for generating a value for a first attribute includes a database having one or more dimensions that each include one or more members. The database includes one or more storage locations that are each associated with one member from each dimension in a set of one or more of the dimensions. A server evaluates an expression including at least one second attribute that depends on a set of one or more of the dimensions, the expression mapping at least one member of a first dimension on which the first attribute depends to at least one member of a second dimension on which the second attribute depends. The value for the first attribute is generated according to the expression. The server and database may operate in an on-line analytical processing (OLAP) environment.

    摘要翻译: 用于生成第一属性的值的系统包括具有一个或多个维度的数据库,每个维度各自包括一个或多个成员。 数据库包括一个或多个存储位置,每个存储位置与一个或多个维度的集合中的每个维度的一个成员相关联。 服务器评估包括依赖于一组或多个维度的至少一个第二属性的表达式,所述表达式映射第一维度的至少一个成员,其中第一属性依赖于第二维度的至少一个成员 第二个属性所依赖的。 第一个属性的值根据表达式生成。 服务器和数据库可以在在线分析处理(OLAP)环境中操作。