Write-back to cells
    41.
    发明申请

    公开(公告)号:US20060010294A1

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

    申请号:US11220075

    申请日:2005-09-06

    IPC分类号: G06F12/00

    摘要: Maintaining data used for performing “what-if” analysis is disclosed. The systems and methods of the invention define an efficient mechanism allowing a user to specify how base values from a database are to be changed. The changes can be held in a local delta cache which is only exposed to a single user, leaving the base data unchanged. The changes can also be maintained in a write-back partition, which results in the changes being exposed to all clients of the database. Values in the write-back partition can be selectively rolled back if required.

    System and method for semi-additive aggregation
    42.
    发明申请
    System and method for semi-additive aggregation 失效
    半加成聚集的系统和方法

    公开(公告)号:US20050182703A1

    公开(公告)日:2005-08-18

    申请号:US10777918

    申请日:2004-02-12

    IPC分类号: G06F17/30 G06F17/60

    摘要: A simple interface may be provided that enables the user to define parameters for aggregation of a semi-additive measure. The interface may enable the user to designate a measure as a semi-additive measure and to pair the measure with an additive aggregation function. The interface may also enable the user to select non-additive dimensions and to pair each non-additive dimension with a corresponding aggregation function. One such aggregation function is a by account aggregation function, which enables each account in an account dimension to be aggregated across a corresponding non-additive dimension according to an associated account type.

    摘要翻译: 可以提供简单的界面,使得用户能够定义用于聚合半附加测量的参数。 该接口可以使用户能够将度量指定为半附加度量度,并将该度量与加性聚合函数进行配对。 接口还可以使用户能够选择非附加维度并且将每个非附加维度与相应的聚合函数进行配对。 一个这样的聚合功能是通过帐户聚合功能,其使帐户维度中的每个帐户能够根据相关联的帐户类型跨相应的非附加维度进行聚合。

    Record for a multidimensional database with flexible paths
    43.
    发明授权
    Record for a multidimensional database with flexible paths 有权
    使用灵活路径记录多维数据库

    公开(公告)号:US06446059B1

    公开(公告)日:2002-09-03

    申请号:US09338207

    申请日:1999-06-22

    IPC分类号: G06F1730

    摘要: Creating and maintaining cell data records in a multidimensional database is disclosed using flexible dimension paths is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the multidimensional database where there are hierarchies of levels within a dimension. The flexible dimension path does not change when a member is moved from a first point to a second point on a dimension thereby avoiding the need to rebuild the OLAP database. The format used lends itself well to indexing, and also to creating aggregations of the cell data.

    摘要翻译: 公开了使用柔性尺寸路径来创建和维护多维数据库中的单元数据记录。 本发明的系统和方法定义了在多维数据库中指定单元格位置的有效机制,其中在维度内存在层级。 当成员从维度上的第一个点移动到第二个点时,灵活的维度路径不会改变,从而避免重建OLAP数据库的需要。 所使用的格式很好地用于索引,也用于创建单元数据的聚合。

    Processing data across a distributed network
    44.
    发明授权
    Processing data across a distributed network 失效
    在分布式网络中处理数据

    公开(公告)号:US07844976B2

    公开(公告)日:2010-11-30

    申请号:US11530383

    申请日:2006-09-08

    IPC分类号: G06F3/00 G06K9/40

    CPC分类号: G06F9/5038

    摘要: A system, method, and related techniques are disclosed for processing data across a distributed network to a plurality of machines. The method may include receiving a first user-supplied transform and generating a first package based on the first user-supplied transform. The method may further include receiving a designated key and generating a second package based on the key. Furthermore, the method may include receiving a second user-supplied transform and generating a third package based on the second user-supplied transform. Moreover, the method may include distributing the first, second, and third packages to a plurality of machines using a cluster API.

    摘要翻译: 公开了一种用于将分布式网络上的数据处理到多个机器的系统,方法和相关技术。 该方法可以包括接收第一用户提供的变换并且基于第一用户提供的变换来生成第一包。 该方法还可以包括接收指定的密钥并且基于密钥生成第二包。 此外,该方法可以包括接收第二用户提供的变换并且基于第二用户提供的变换来生成第三包。 此外,该方法可以包括使用集群API将第一,第二和第三包分发到多个机器。

    Centralized KPI framework systems and methods
    45.
    发明授权
    Centralized KPI framework systems and methods 有权
    集中的KPI框架系统和方法

    公开(公告)号:US07716253B2

    公开(公告)日:2010-05-11

    申请号:US11050130

    申请日:2005-02-03

    IPC分类号: G06F7/00

    CPC分类号: G06Q10/06

    摘要: The subject invention pertains to a centralized key performance indicator (KPI) framework and systems and methods of utilization. In particular, KPIs can be defined and centrally stored as data or metadata in a data store. Systems and methods are provided to enable, among other things, KPI definition, storage, identification of defined or available KPIs, and interaction with the KPIs. For instance, an interface is provided to allow KPI data to be requested and retrieved from a source such as a database. A generic application program or users thereof can then interact with and display KPI data without knowing anything a priori about the stored data or the structure thereof.

    摘要翻译: 本发明涉及集中式关键性能指标(KPI)框架和系统和利用方法。 特别地,可以将KPI定义并集中存储为数据存储中的数据或元数据。 提供了系统和方法,以实现KPI定义,存储,定义或可用KPI的识别以及与KPI的交互。 例如,提供了一个接口来允许从诸如数据库的源请求和检索KPI数据。 然后,通用应用程序或其用户可以在不知道有关所存储的数据或其结构的任何事物的情况下与KPI数据进行交互并显示。

    PARTITION TEMPLATES FOR MULTIDIMENSIONAL DATABASES
    46.
    发明申请
    PARTITION TEMPLATES FOR MULTIDIMENSIONAL DATABASES 审中-公开
    多维数据库的分区模板

    公开(公告)号:US20090327339A1

    公开(公告)日:2009-12-31

    申请号:US12163387

    申请日:2008-06-27

    IPC分类号: G06F17/30

    CPC分类号: G06F16/283

    摘要: Systems and methods for storing and retrieving data items in multidimensional databases are provided. Data partition templates are generated for grouping data partitions that are similar to one another, that is, that contain information specified according to particular common characteristics (for instance, time, product, geography, etc.). The data partition template includes one or more rules concerning how the data stored in partitions associated with the data partition template should be processed. A template object having the rule(s) associated therewith is generated for the data partition template. Once a data partition template is generated, a plurality of partitions are generated in accordance therewith. Each of the plurality of partitions utilizes the template object associated with the data partition template. In this way, the overhead associated with managing the partitions is significantly decreased.

    摘要翻译: 提供了用于在多维数据库中存储和检索数据项的系统和方法。 生成数据分区模板,用于对彼此相似的数据分区进行分组,即包含根据特定共同特征(例如时间,产品,地理位置等)指定的信息。 数据分区模板包括关于如何处理与数据分区模板相关联的分区中存储的数据的一个或多个规则。 为数据分区模板生成具有与之相关联的规则的模板对象。 一旦产生了数据分区模板,则根据其生成多个分区。 多个分区中的每一个利用与数据分区模板相关联的模板对象。 以这种方式,与管理分区相关联的开销显着降低。

    System and method for analytically modeling data organized according to non-referred attributes
    48.
    发明授权
    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.

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

    Virtual cubes
    49.
    发明授权
    Virtual cubes 有权
    虚拟立方体

    公开(公告)号:US06477536B1

    公开(公告)日:2002-11-05

    申请号:US09337828

    申请日:1999-06-22

    IPC分类号: G06F1730

    摘要: Systems and methods for creating and maintaining virtual cubes are disclosed. A virtual cube is a logical representation of a subset of the dimensions and measures of at least one physical cube maintained by an OLAP server. Metadata defines the mappings from the dimensions and measures of the virtual cube to the dimensions and measures of the physical cube. Client applications can manipulate the virtual cube as if it were a physical cube.

    摘要翻译: 公开了用于创建和维护虚拟立方体的系统和方法。 虚拟多维数据集是由OLAP服务器维护的至少一个物理多维数据集的维度和度量的子集的逻辑表示。 元数据定义了从虚拟多维数据集的维度和度量到物理多维数据集的维度和度量的映射。 客户端应用程序可以像虚拟立方体那样操纵虚拟立方体。

    Record for multidimensional databases
    50.
    发明授权
    Record for multidimensional databases 有权
    多维数据库记录

    公开(公告)号:US06442560B1

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

    申请号:US09338666

    申请日:1999-06-22

    IPC分类号: G06F1713

    摘要: Creating and maintaining cell data records in a multidimensional database is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the multidimensional database where there are hierarchies of levels within a dimension. The format used lends itself well to indexing, and also to creating aggregations of the cell data.

    摘要翻译: 公开了在多维数据库中创建和维护单元数据记录。 本发明的系统和方法定义了在多维数据库中指定单元格位置的有效机制,其中在维度内存在层级。 所使用的格式很好地用于索引,也用于创建单元数据的聚合。