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

    公开(公告)号:US20060010164A1

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

    申请号:US11050130

    申请日:2005-02-03

    IPC分类号: G01B5/255

    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数据进行交互并显示。

    Centralized KPI framework systems and methods
    2.
    发明授权
    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数据进行交互并显示。

    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.

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

    Multidimensional database subcubes
    5.
    发明授权
    Multidimensional database subcubes 失效
    多维数据库子单元

    公开(公告)号:US07490106B2

    公开(公告)日:2009-02-10

    申请号:US11137233

    申请日:2005-05-25

    IPC分类号: G06F7/00

    摘要: The subject invention pertains to interaction with multidimensional data. More specifically, interactions can be constrained to a limited subset of a multidimensional data cube, namely a subcube. Subsequent to or concurrently with subcube creation, query execution or other interactions such as calculations can be consolidated or restricted to the smaller subcube query space rather than the typically enormous main cube. Multiple subcubes can also be created and nested to gradually reduce the query space. Deletion of one subcube can cause a reversion back to a previously defined or hierarchical parent subcube.

    摘要翻译: 本发明涉及与多维数据的交互。 更具体地,可以将交互约束到多维数据立方体的有限子集,即子多维数据集。 在子多维数据集创建之后或之后,查询执行或其他交互(如计算)可以合并或限制于较小的子多维数据集查询空间,而不是典型的巨大的主多维数据集。 也可以创建和嵌套多个子多维数据集,以逐渐减少查询空间。 删除一个子多维数据集可能导致返回到先前定义的或分层的父子单元。

    Direct write back systems and methodologies
    7.
    发明申请
    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.

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

    Adaptive query execution in a distributed database system
    8.
    发明授权
    Adaptive query execution in a distributed database system 有权
    分布式数据库系统中的自适应查询执行

    公开(公告)号:US06473750B1

    公开(公告)日:2002-10-29

    申请号:US09419452

    申请日:1999-10-15

    IPC分类号: G06F1730

    摘要: Systems, clients, servers, methods, and computer-readable media of varying scope are described in which, a database client applies an adaptive method to dynamically determines whether a particular request should execute on the client-side or the server-side of a client-server database system. In determining where a particular request should be executed, the database client analyzes the size of the data sets involved and the data flow generated by the data sets.

    摘要翻译: 描述了不同范围的系统,客户端,服务器,方法和计算机可读介质,其中数据库客户端应用自适应方法来动态地确定特定请求是否应在客户端或服务器端执行 服务器数据库系统。 在确定应该执行特定请求的位置时,数据库客户机分析所涉及的数据集的大小以及由数据集生成的数据流。