Hierarchical Runtime Settings Within Distributed Query Execution Frameworks
    2.
    发明申请
    Hierarchical Runtime Settings Within Distributed Query Execution Frameworks 有权
    分布式查询执行框架内的分层运行时设置

    公开(公告)号:US20150261822A1

    公开(公告)日:2015-09-17

    申请号:US14205007

    申请日:2014-03-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30477

    摘要: A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes. The calculation nodes each define one or more operations to execute by a calculation engine on the database server. Thereafter, the database server instantiates a runtime model of the calculation scenario by accessing a local settings object stored with the calculation scenario that specifies local settings for the calculation scenario. Subsequently, the database server executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. The data set can then be provided by the database server to the application server.

    摘要翻译: 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包含一个或多个计算节点的数据流模型的计算方案相关联。 计算节点各自定义一个或多个由数据库服务器上的计算引擎执行的操作。 此后,数据库服务器通过访问使用指定计算方案的本地设置的计算方案存储的本地设置对象来实例化计算方案的运行时模型。 随后,数据库服务器执行由实例计算场景的计算节点定义的操作以产生响应数据集。 数据集可以由数据库服务器提供给应用程序服务器。

    DATA DRIVEN MULTI-PROVIDER PRUNING FOR QUERY EXECUTION PLAN
    6.
    发明申请
    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.

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

    DECOUPLING FILTER INJECTION AND EVALULATION BY FORCED PUSHDOWN OF FILTER ATTRIBUTES IN CALCULATION MODELS
    9.
    发明申请
    DECOUPLING FILTER INJECTION AND EVALULATION BY FORCED PUSHDOWN OF FILTER ATTRIBUTES IN CALCULATION MODELS 审中-公开
    通过计算滤波器强制推算滤波器注入和评估计算模型

    公开(公告)号:US20160140241A1

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

    申请号:US14540781

    申请日:2014-11-13

    IPC分类号: G06F17/30

    摘要: According to an aspect, a system for moving a filter in a query model to ensure query semantics includes a query engine configured to obtain a query model for a query to be executed on a database. The query engine includes a query optimizer configured to instantiate the query model by merging the query with the query model. The query optimizer includes a filter mover configured to move a filter to a point within the instantiated query model such that semantics for the query within the instantiated query model is ensured.

    摘要翻译: 根据一方面,一种用于在查询模型中移动过滤器以确保查询语义的系统包括被配置为获得要在数据库上执行的查询的查询模型的查询引擎。 查询引擎包括一个查询优化器,用于通过将查询与查询模型合并来实例化查询模型。 查询优化器包括过滤器移动器,其被配置为将过滤器移动到实例化查询模型中的点,使得确保在实例化查询模型内的查询的语义。