Data cube script development and debugging systems and methodologies
    1.
    发明申请
    Data cube script development and debugging systems and methodologies 有权
    数据立方体脚本开发和调试系统和方法

    公开(公告)号:US20060020921A1

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

    申请号:US11133557

    申请日:2005-05-20

    IPC分类号: G06F9/44

    CPC分类号: G06F11/3636

    摘要: The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.

    摘要翻译: 本发明涉及促进在多维数据环境或模型中计算的开发和调试的系统和方法。 包括MDX(多维表达式)中提供的数据立方体计算脚本可以逐步执行或应用。 可以针对计算脚本设置断点,并且可以通过用户界面查看和查询多维数据集状态。 用户通过主题系统和方法来启用逐步计算脚本,识别对多维数据集的影响,如果所需的结果未能发生,则更改脚本。 除了调试之外,系统和方法可以用于脚本的初始开发。

    Data cube script development and debugging systems and methodologies
    2.
    发明授权
    Data cube script development and debugging systems and methodologies 有权
    数据立方体脚本开发和调试系统和方法

    公开(公告)号:US07694278B2

    公开(公告)日:2010-04-06

    申请号:US11133557

    申请日:2005-05-20

    IPC分类号: G06F9/44

    CPC分类号: G06F11/3636

    摘要: The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.

    摘要翻译: 本发明涉及促进在多维数据环境或模型中计算的开发和调试的系统和方法。 包括MDX(多维表达式)中提供的数据立方体计算脚本可以逐步执行或应用。 可以针对计算脚本设置断点,并且可以通过用户界面查看和查询多维数据集状态。 用户通过主题系统和方法来启用逐步计算脚本,识别对多维数据集的影响,如果所需的结果未能发生,则更改脚本。 除了调试之外,系统和方法可以用于脚本的初始开发。

    Multidimensional database subcubes
    8.
    发明授权
    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.

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

    Multidimensional data cubes with high-cardinality attributes
    9.
    发明授权
    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 data space queries with expression evaluation
    10.
    发明授权
    Multidimensional data space queries with expression evaluation 有权
    具有表达式求值的多维数据空间查询

    公开(公告)号:US08229923B2

    公开(公告)日:2012-07-24

    申请号:US12239695

    申请日:2008-09-26

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30592 Y10S707/957

    摘要: A system and techniques for executing queries of a sparse multidimensional data space in the presence of expressions. A dimension is associated with a set of data references, which reference stored data items. A query expression has dimension or a data reference as an operand. A result space with one or more result dimensions is defined based on the query. A plan is built and executed for retrieving the stored data items associated with the result dimensions, and forming “calculated data items” by evaluating the expression. Executing the plan produces a stream of data tuples, each having a set of data components storing the retrieved data items and/or the calculated data items. Data components are either empty or have data values. An iterative algorithm is employed on the stream to locate the data tuples that are empty at the intersection of each result dimension.

    摘要翻译: 用于在存在表达式的情况下执行稀疏多维数据空间的查询的系统和技术。 维度与一组数据引用相关联,引用存储的数据项。 查询表达式具有维或数据引用作为操作数。 基于查询定义具有一个或多个结果维度的结果空间。 构建并执行用于检索与结果维度相关联的存储数据项的计划,并通过评估表达式形成“计算的数据项”。 执行该计划产生一组数据元组,每个数据流都具有存储检索到的数据项和/或计算的数据项的一组数据组件。 数据组件为空或具有数据值。 在流上采用迭代算法来定位在每个结果维度的交集处为空的数据元组。