Data modification in hypothetical planning

    公开(公告)号:US10929395B2

    公开(公告)日:2021-02-23

    申请号:US14568946

    申请日:2014-12-12

    IPC分类号: G06F16/2453 G06F16/2455

    摘要: A system, medium, and method including modifying a graphical view representation of a first table of a set of data, the first table having at least a first column subject to changes in value; modifying a graphical view representation of a second table of a second set of data; determining a query operation of the view representations of the first table and second table; aggregating values of the view representation of the result of the query operation having a same key; determining, based on the aggregated values, values for the first column of the view representation of the first table; and providing an output of the values for the first column of the view representation of the first table, the output values including changed values.

    DATA MODIFICATION IN HYPOTHETICAL PLANNING
    4.
    发明申请
    DATA MODIFICATION IN HYPOTHETICAL PLANNING 审中-公开
    数字修改在水印计划中的应用

    公开(公告)号:US20160048559A1

    公开(公告)日:2016-02-18

    申请号:US14568946

    申请日:2014-12-12

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24537 G06F16/24556

    摘要: A system, medium, and method including modifying a graphical view representation of a first table of a set of data, the first table having at least a first column subject to changes in value; modifying a graphical view representation of a second table of a second set of data; determining a query operation of the view representations of the first table and second table; aggregating values of the view representation of the result of the query operation having a same key; determining, based on the aggregated values, values for the first column of the view representation of the first table; and providing an output of the values for the first column of the view representation of the first table, the output values including changed values.

    摘要翻译: 一种包括修改一组数据的第一表的图形视图表示的系统,介质和方法,所述第一表至少具有受到价值变化的第一列; 修改第二组数据的第二表的图形视图表示; 确定第一表和第二表的视图表示的查询操作; 聚合具有相同密钥的查询操作的结果的视图表示的值; 基于所述聚合值来确定所述第一表的视图表示的第一列的值; 并且提供第一表的视图表示的第一列的值的输出,输出值包括改变的值。

    Hybrid Query Execution Plan
    5.
    发明申请
    Hybrid Query Execution Plan 有权
    混合查询执行计划

    公开(公告)号:US20130132370A1

    公开(公告)日:2013-05-23

    申请号:US13740143

    申请日:2013-01-11

    IPC分类号: G06F17/30

    摘要: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.

    摘要翻译: 接收到的查询执行计划中的过程模式可以与已经预先定义了等效声明运算符的存储模式进行匹配。 查询执行计划可以描述访问数据的查询。 可以通过用等效的声明运算符替换过程模式来生成混合执行计划。 可以将混合执行计划处理成本分配给混合执行计划的执行,并且可以将查询执行计划处理成本分配给查询执行计划的执行。 分配可以包括评估混合执行计划和查询执行计划的成本模型。 如果混合执行计划处理成本低于查询执行计划处理成本,或者如果混合执行计划处理成本大于查询执行计划处理成本,则可以使用混合执行计划执行查询。 公开了相关系统,方法和制品。

    Hybrid query execution plan generation and cost model evaluation
    6.
    发明授权
    Hybrid query execution plan generation and cost model evaluation 有权
    混合查询执行计划生成和成本模型评估

    公开(公告)号:US08356027B2

    公开(公告)日:2013-01-15

    申请号:US12972360

    申请日:2010-12-17

    IPC分类号: G06F17/30

    摘要: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.

    摘要翻译: 接收到的查询执行计划中的过程模式可以与已经预先定义了等效声明运算符的存储模式进行匹配。 查询执行计划可以描述访问数据的查询。 可以通过用等效的声明运算符替换过程模式来生成混合执行计划。 可以将混合执行计划处理成本分配给混合执行计划的执行,并且可以将查询执行计划处理成本分配给查询执行计划的执行。 分配可以包括评估混合执行计划和查询执行计划的成本模型。 如果混合执行计划处理成本低于查询执行计划处理成本,或者如果混合执行计划处理成本大于查询执行计划处理成本,则可以使用混合执行计划执行查询。 公开了相关系统,方法和制品。

    Hybrid Query Execution Plan
    7.
    发明申请
    Hybrid Query Execution Plan 有权
    混合查询执行计划

    公开(公告)号:US20120089595A1

    公开(公告)日:2012-04-12

    申请号:US12972360

    申请日:2010-12-17

    申请人: Bernhard Jaecksch

    发明人: Bernhard Jaecksch

    IPC分类号: G06F17/30

    摘要: A procedural pattern in a received query execution plan can be matched to a stored pattern for which an equivalent declarative operator has been pre-defined. The query execution plan can describe a query for accessing data. A hybrid execution plan can be generated by replacing the procedural pattern with the equivalent declarative operator. A hybrid execution plan processing cost can be assigned to execution of the hybrid execution plan and a query execution plan processing cost can be assigned to execution of the query execution plan. The assigning can include evaluating a cost model for the hybrid execution plan and the query execution plan. The query can be executed using the hybrid execution plan if the hybrid execution plan processing cost is less than the query execution plan processing cost or the query execution plan if the hybrid execution plan processing cost is greater than the query execution plan processing cost. Related systems, methods, and articles of manufacture are disclosed.

    摘要翻译: 接收到的查询执行计划中的过程模式可以与已经预先定义了等效声明运算符的存储模式进行匹配。 查询执行计划可以描述访问数据的查询。 可以通过用等效的声明运算符替换过程模式来生成混合执行计划。 可以将混合执行计划处理成本分配给混合执行计划的执行,并且可以将查询执行计划处理成本分配给查询执行计划的执行。 分配可以包括评估混合执行计划和查询执行计划的成本模型。 如果混合执行计划处理成本低于查询执行计划处理成本,或者如果混合执行计划处理成本大于查询执行计划处理成本,则可以使用混合执行计划执行查询。 公开了相关系统,方法和制品。