-
公开(公告)号：US20140330807A1
公开(公告)日：2014-11-06
申请号：US14337023
申请日：2014-07-21
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30991
摘要： A query is received which causes an initial data flow graph that includes a plurality of nodes that are used to execute the query is generated. Thereafter, the initial data flow graph is optimized using a model optimizer that includes an optimizer framework and an application programming interface (API). The optimizer framework provides logic to restructure the initial data flow graph and a rules engine for executing one or more optimization rules. The API allows for registration of new optimization rules to be executed by the rules engine. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到一个查询，该查询导致包括用于执行查询的多个节点的初始数据流图被生成。 此后，使用包含优化器框架和应用程序编程接口（API）的模型优化器来优化初始数据流图。 优化器框架提供了重构初始数据流图的逻辑和用于执行一个或多个优化规则的规则引擎。 API允许注册由规则引擎执行的新的优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US08793243B2
公开(公告)日：2014-07-29
申请号：US13457330
申请日：2012-04-26
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30991
摘要： A query is received which causes an initial data flow graph that includes a plurality of nodes that are used to execute the query is generated. Thereafter, the initial data flow graph is optimized using a model optimizer that includes an optimizer framework and an application programming interface (API). The optimizer framework provides logic to restructure the initial data flow graph and a rules engine for executing one or more optimization rules. The API allows for registration of new optimization rules to be executed by the rules engine. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到一个查询，该查询导致包括用于执行查询的多个节点的初始数据流图被生成。 此后，使用包含优化器框架和应用程序编程接口（API）的模型优化器来优化初始数据流图。 优化器框架提供了重构初始数据流图的逻辑和用于执行一个或多个优化规则的规则引擎。 API允许注册由规则引擎执行的新的优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US20130325874A1
公开(公告)日：2013-12-05
申请号：US13488143
申请日：2012-06-04
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/30241 , G06F17/30315 , G06F17/30445 , G06F17/30486
摘要： A database query of point data among two or more axes of a database is received. The database stores point data in distinct integer vectors with a shared dictionary. Thereafter, the dictionary is scanned to determine boundaries for each axis specified by the query. In response, results characterizing data responsive to the query within the determined boundaries for each axis are returned. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到数据库的两个或多个轴之间的点数据的数据库查询。 数据库使用共享字典将点数据存储在不同的整数向量中。 此后，扫描字典以确定查询指定的每个轴的边界。 作为响应，返回表征响应于针对每个轴的确定的边界内的查询的数据的结果。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US20120130942A1
公开(公告)日：2012-05-24
申请号：US12951948
申请日：2010-11-22
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30436 , G06F17/30592
摘要： In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data.
摘要翻译： 在一个实施例中，本发明包括使用关系操作的OLAP执行模型。 在一个实施例中，本发明包括一种方法，包括在一个或多个计算机上执行的在线分析处理器（OLAP）中接收第一查询，所述OLAP生成并包括指定限定多个节点的图形的模型和多个 每个节点对应于数据的不同操作。 第二个查询由OLAP生成。 第二查询包括多个分层子查询，每个子查询对应于图中的一个节点，用于指定关于数据的不同操作。 在耦合到数据存储的关系引擎中接收到第二个查询。 关系引擎执行第二个查询，并根据此查询数据。
-
公开(公告)号：US10114825B2
公开(公告)日：2018-10-30
申请号：US14212163
申请日：2014-03-14
摘要： As part of query processing within a distributed execution environment framework, available resources taken into account when generating an execution plan and/or executing an execution plan to determine whether to parallelize any operations. Related apparatus, systems, methods and articles are also described.
-
公开(公告)号：US09846724B2
公开(公告)日：2017-12-19
申请号：US14540792
申请日：2014-11-13
申请人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
发明人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.
-
公开(公告)号：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.
摘要翻译： 数据库服务器从与计算方案相关联的远程应用程序服务器接收查询。 计算方案定义了一个数据流模型，其中包括一个或多个计算节点，每个计算节点定义一个或多个在数据库服务器上执行的操作。 计算节点的顶部运营商节点指定多个属性，并且查询请求由顶部运营商节点指定的属性的子集; 此后，数据库服务器实例化计算场景，以便通过仅请求属性子集来优化。 然后，数据库服务器执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 然后，数据库服务器将数据集提供给应用程序服务器。
-
公开(公告)号：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.
摘要翻译： 根据一个方面，系统包括被配置为获得用于指定要在提供商分区上应用的过滤器的查询的多供应商查询模型的查询引擎。 获得的多供应商查询模型包含修剪计划。 查询引擎包括配置为在多提供者查询模型的优化期间执行修剪计划的查询优化器。 修剪计划确定每个提供者分区是否包括基于剪枝信息执行过滤器所需的内容。 查询优化器被配置为通过排除确定为不需要执行过滤器的至少一个提供者分区来减少查询的范围。
-
公开(公告)号：US09223828B2
公开(公告)日：2015-12-29
申请号：US14471368
申请日：2014-08-28
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30463
摘要： A query is received and an initial data flow graph comprising a plurality of nodes is generated for executing the query. The initial data flow graph is optimized using a model optimizer that accesses at least one of a plurality of patterns to identify a matching pattern and executes at least one optimization rule associated with a matching pattern. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到查询，并且生成包括多个节点的初始数据流图来执行查询。 使用模型优化器来优化初始数据流图，该模型优化器访问多个模式中的至少一个以识别匹配模式并且执行与匹配模式相关联的至少一个优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US09213737B2
公开(公告)日：2015-12-15
申请号：US13914214
申请日：2013-06-10
IPC分类号： G06F17/30
CPC分类号： G06F17/30389 , G06F17/30412
摘要： A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that each specify operations to be performed to execute the query. One of the nodes can be a semantic node that is used to modify the query for operations requiring special handling. Related apparatus, systems, methods, and articles are also described.
摘要翻译： 描述了执行包括多个计算节点的计算场景的计算引擎，每个计算节点指定要执行的执行查询的操作。 其中一个节点可以是一个语义节点，用于修改需要特殊处理的操作的查询。 还描述了相关装置，系统，方法和制品。
-
-
-
-
-
-
-
-
-
搜索结果
69 条记录 (耗时 0.016 秒)
