-
公开(公告)号:US20160140174A1
公开(公告)日:2016-05-19
申请号:US14540789
申请日:2014-11-13
申请人: Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Joerg Schad , Julian Schwing , Daniel Patejdl
发明人: Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Joerg Schad , Julian Schwing , Daniel Patejdl
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.
摘要翻译: 根据一个方面,系统包括被配置为获得用于指定要在提供商分区上应用的过滤器的查询的多供应商查询模型的查询引擎。 获得的多供应商查询模型包含修剪计划。 查询引擎包括配置为在多提供者查询模型的优化期间执行修剪计划的查询优化器。 修剪计划确定每个提供者分区是否包括基于剪枝信息执行过滤器所需的内容。 查询优化器被配置为通过排除确定为不需要执行过滤器的至少一个提供者分区来减少查询的范围。
-
2.
公开(公告)号:US20140365465A1
公开(公告)日:2014-12-11
申请号:US13914357
申请日:2013-06-10
IPC分类号: G06F17/30
CPC分类号: G06F17/30699 , G06F17/30424 , G06F17/30592
摘要: A query associated with a calculation scenario comprising a plurality of calculation nodes can be received by a calculation engine. The calculation scenario is instantiated and the query is transformed into a convex hull filter based on the at least one multiple selection condition that can be executed at any of the calculation nodes. The instantiated calculation scenario and the convex hull filter are executed to provide a result set. Related apparatus, systems, methods, and articles are also described.
摘要翻译: 可以由计算引擎接收与包括多个计算节点的计算场景相关联的查询。 计算场景被实例化,并且基于可以在任何计算节点处执行的至少一个多选择条件将查询转换成凸包过滤器。 执行实例计算场景和凸包过滤器以提供结果集。 还描述了相关装置,系统,方法和制品。
-
3.
公开(公告)号:US09037570B2
公开(公告)日:2015-05-19
申请号:US13914357
申请日:2013-06-10
IPC分类号: G06F17/30
CPC分类号: G06F17/30699 , G06F17/30424 , G06F17/30592
摘要: A query associated with a calculation scenario comprising a plurality of calculation nodes can be received by a calculation engine. The calculation scenario is instantiated and the query is transformed into a convex hull filter based on the at least one multiple selection condition that can be executed at any of the calculation nodes. The instantiated calculation scenario and the convex hull filter are executed to provide a result set. Related apparatus, systems, methods, and articles are also described.
摘要翻译: 可以由计算引擎接收与包括多个计算节点的计算场景相关联的查询。 计算场景被实例化,并且基于可以在任何计算节点处执行的至少一个多选择条件将查询转换成凸包过滤器。 执行实例计算场景和凸包过滤器以提供结果集。 还描述了相关装置,系统,方法和制品。
-
公开(公告)号: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.
-
公开(公告)号: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.
摘要翻译: 数据库服务器从与计算方案相关联的远程应用程序服务器接收查询。 计算方案定义了一个数据流模型,其中包括一个或多个计算节点,每个计算节点定义一个或多个在数据库服务器上执行的操作。 计算节点的顶部运营商节点指定多个属性,并且查询请求由顶部运营商节点指定的属性的子集; 此后,数据库服务器实例化计算场景,以便通过仅请求属性子集来优化。 然后,数据库服务器执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 然后,数据库服务器将数据集提供给应用程序服务器。
-
-
-
-