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

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

    Utilizing spreadsheet references with grouped aggregate views
    6.
    发明授权
    Utilizing spreadsheet references with grouped aggregate views 有权
    利用分组的聚合视图的电子表格引用

    公开(公告)号:US08185817B2

    公开(公告)日:2012-05-22

    申请号:US12141114

    申请日:2008-06-18

    CPC分类号: G06F17/246

    摘要: Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.

    摘要翻译: 公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。 分组的聚合视图功能使用户能够创建数据的分组聚合视图。 计算功能使用户能够对分组的聚合视图数据进行计算,该视图基于分组聚合视图中对数据的相对或绝对引用。 从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。 从用户接收到输入,以便在写入计算时选择第二个单元格进行参考。 向用户呈现与第二小区中包含的数据相关的可用参考。 从用户接收输入以选择与第二小区相关的可用参考之一。 所选择的一个可用参考被放入第一个单元格中。

    UTILIZING SPREADSHEET REFERENCES WITH GROUPED AGGREGATE VIEWS
    7.
    发明申请
    UTILIZING SPREADSHEET REFERENCES WITH GROUPED AGGREGATE VIEWS 有权
    使用分组聚合视图来利用传播参考

    公开(公告)号:US20090319880A1

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

    申请号:US12141114

    申请日:2008-06-18

    IPC分类号: G06F17/00

    CPC分类号: G06F17/246

    摘要: Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.

    摘要翻译: 公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。 分组的聚合视图功能使用户能够创建数据的分组聚合视图。 计算功能使用户能够对分组的聚合视图数据进行计算,该视图基于分组聚合视图中对数据的相对或绝对引用。 从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。 从用户接收到输入,以便在写入计算时选择第二个单元格进行参考。 向用户呈现与第二小区中包含的数据相关的可用参考。 从用户接收输入以选择与第二小区相关的可用参考之一。 所选择的一个可用参考被放入第一个单元格中。

    Systems and methods to facilitate utilization of database modeling
    8.
    发明授权
    Systems and methods to facilitate utilization of database modeling 有权
    促进数据库建模利用的系统和方法

    公开(公告)号:US07885978B2

    公开(公告)日:2011-02-08

    申请号:US11069480

    申请日:2005-03-01

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30893 G06F8/31

    摘要: The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data modeling system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components. An extension component operates with the protocol component to support the data transactions, where the extension component supplies various commands above standard network and database protocols. An object model is provided as a wrapper to the extensions in order to support various online and offline database development applications.

    摘要翻译: 本发明涉及扩展标记语言协议的网络数据访问能力的系统和方法。 在一个方面,提供了一种网络数据建模系统。 该系统包括协议组件,其采用计算机化的标记语言来促进网络组件之间的数据交互。 扩展组件与协议组件一起运行以支持数据事务,其中扩展组件提供高于标准网络和数据库协议的各种命令。 提供对象模型作为扩展的包装器,以支持各种在线和脱机数据库开发应用程序。

    DATA ANALYSIS EXPRESSIONS
    10.
    发明申请
    DATA ANALYSIS EXPRESSIONS 有权
    数据分析表达

    公开(公告)号:US20110087954A1

    公开(公告)日:2011-04-14

    申请号:US12576254

    申请日:2009-10-09

    IPC分类号: G06F17/00 G06F12/02

    CPC分类号: G06F17/246

    摘要: Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.

    摘要翻译: 公开了接收和处理数据分析表达式的方法和系统。 特定的方法包括在电子表格的枢轴表处接收数据分析表达式。 通过确定与特定小区关联的上下文,基于上下文计算数据分析表达式的值,并且在特定小区处输出计算的值,对于枢纽表的特定小区执行数据分析表达式。