DATA DRIVEN MULTI-PROVIDER PRUNING FOR QUERY EXECUTION PLAN
    1.
    发明申请
    DATA DRIVEN MULTI-PROVIDER PRUNING FOR QUERY EXECUTION PLAN 审中-公开
    数据驱动多执行程序查询执行计划

    公开(公告)号:US20160140174A1

    公开(公告)日:2016-05-19

    申请号:US14540789

    申请日:2014-11-13

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24542

    摘要: According to an aspect, a system includes a query engine configured to obtain a multi-provider query model for a query specifying a filter to be applied on provider partitions. The obtained multi-provider query model incorporates a pruning plan. The query engine includes a query optimizer configured to execute the pruning plan during optimization of the multi-provider query model. The pruning plan determines if each of the provider partitions includes content that is required to execute the filter based on pruning information. The query optimizer configured to reduce a scope of the query by excluding at least one provider partition that is determined as not required to execute the filter.

    摘要翻译: 根据一个方面,系统包括被配置为获得用于指定要在提供商分区上应用的过滤器的查询的多供应商查询模型的查询引擎。 获得的多供应商查询模型包含修剪计划。 查询引擎包括配置为在多提供者查询模型的优化期间执行修剪计划的查询优化器。 修剪计划确定每个提供者分区是否包括基于剪枝信息执行过滤器所需的内容。 查询优化器被配置为通过排除确定为不需要执行过滤器的至少一个提供者分区来减少查询的范围。

    Database calculation engine with dynamic top operator

    公开(公告)号:US10275490B2

    公开(公告)日:2019-04-30

    申请号:US14607762

    申请日:2015-01-28

    IPC分类号: G06F17/30

    摘要: A database server receives a query from a remote application server that is associated with a calculation scenario. The calculation scenario defines a data flow model that includes one or more calculation nodes that each define one or more operations to execute on the database server. A top operator node of the calculation nodes specifies a plurality of attributes and the query requests a subset of the attributes specified by the top operator node; Thereafter, the database server instantiates the calculation scenario so that it is optimized by requesting only the subset of attributes. The database server then executes the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set. The database server then provides the data set to the application server.

    Database Calculation Engine with Dynamic Top Operator
    5.
    发明申请
    Database Calculation Engine with Dynamic Top Operator 审中-公开
    具有动态顶级运算符的数据库计算引擎

    公开(公告)号:US20160217210A1

    公开(公告)日:2016-07-28

    申请号:US14607762

    申请日:2015-01-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30474

    摘要: A database server receives a query from a remote application server that is associated with a calculation scenario. The calculation scenario defines a data flow model that includes one or more calculation nodes that each define one or more operations to execute on the database server. A top operator node of the calculation nodes specifies a plurality of attributes and the query requests a subset of the attributes specified by the top operator node; Thereafter, the database server instantiates the calculation scenario so that it is optimized by requesting only the subset of attributes. The database server then executes the operations defined by the calculation nodes of the optimized calculation scenario to result in a responsive data set. The database server then provides the data set to the application server.

    摘要翻译: 数据库服务器从与计算方案相关联的远程应用程序服务器接收查询。 计算方案定义了一个数据流模型,其中包括一个或多个计算节点,每个计算节点定义一个或多个在数据库服务器上执行的操作。 计算节点的顶部运营商节点指定多个属性,并且查询请求由顶部运营商节点指定的属性的子集; 此后,数据库服务器实例化计算场景,以便通过仅请求属性子集来优化。 然后,数据库服务器执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 然后,数据库服务器将数据集提供给应用程序服务器。