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 generating dependent data
    3.
    发明授权
    System and method for generating dependent data 有权
    用于生成依赖数据的系统和方法

    公开(公告)号:US06442554B1

    公开(公告)日:2002-08-27

    申请号:US09241361

    申请日:1999-01-29

    IPC分类号: G06F1730

    摘要: A system (10) for generating dependent data (132) includes a database (16) having at least a first dimension (50, 70, 122). The database (16) contains a mapping (106) comprising a source member (54) in the first dimension (50, 70, 122) and a target member (54) in the first dimension (50, 70, 122). The database (16) also contains an attach rate (120) that relates independent data (112) associated with the source member (54) to dependent data (132) associated with the target member (54). A server (12) coupled to the database (16) accesses the mapping (106) and applies the attach rate (120) to the independent data (112) for the source member (54) to generate the dependent data (132) for the target member (54).

    摘要翻译: 用于产生依赖数据(132)的系统(10)包括具有至少第一维度(50,70,122)的数据库(16)。 数据库(16)包含映射(106),其包括在第一维度(50,70,122)中的源构件(54)和第一维度(50,70,122)中的目标构件(54)。 数据库(16)还包含将与源成员(54)相关联的独立数据(112)与与目标成员(54)相关联的依赖数据(132)相关联的附加速率(120)。 耦合到数据库(16)的服务器(12)访问映射(106)并将附着速率(120)应用于用于源成员(54)的独立数据(112),以生成依赖数据(132),用于 目标成员(54)。

    Local and remote client-server interface transparency in distributed software systems
    4.
    发明授权
    Local and remote client-server interface transparency in distributed software systems 有权
    分布式软件系统中的本地和远程客户机 - 服务器界面透明度

    公开(公告)号:US07062542B1

    公开(公告)日:2006-06-13

    申请号:US09834802

    申请日:2001-04-12

    IPC分类号: G06F15/16

    CPC分类号: G06F9/548

    摘要: A distributed software system (10) includes at least one server component (22) that supports one or more server objects having associated data and at least one client component (24) that is distributed from the server component (22). The client component (24) accesses data associated with one or more of the server objects according to a scheme making it substantially transparent to the client component (24) whether the server component (22) is local to or remote from the client component (24).

    摘要翻译: 分布式软件系统(10)包括支持具有相关联数据的一个或多个服务器对象和从服务器组件(22)分发的至少一个客户端组件(24)的至少一个服务器组件(22)。 客户端组件(24)根据一种方案来访问与一个或多个服务器对象相关联的数据,使得其对于客户端组件(24)是否基本上是透明的,无论服务器组件(22)是本地还是远离客户端组件(24 )。

    System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment
    5.
    发明授权
    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)环境中操作。