-
公开(公告)号：US08195643B2
公开(公告)日：2012-06-05
申请号：US12914445
申请日：2010-10-28
CPC分类号： G06F17/30471 , G06F17/30463 , G06F17/30466 , G06F17/30867
摘要： A select query or a data referencing a calculation scenario is received by a database server from a remote application server. The specified calculation scenario is one of a plurality of calculation scenarios and it defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the specified calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. This data set is then provided by the database server to the application server. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 数据库服务器从远程应用程序服务器接收到选择查询或引用计算方案的数据。 指定的计算场景是多个计算场景之一，并且其定义包括一个或多个计算节点的数据流模型。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器实例化指定的计算方案，并执行由实例化计算方案的计算节点定义的操作，以生成响应数据集。 然后，该数据集由数据库服务器提供给应用服务器。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US10198475B2
公开(公告)日：2019-02-05
申请号：US14607681
申请日：2015-01-28
IPC分类号： G06F17/30
摘要： A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.
-
公开(公告)号：US20160140175A1
公开(公告)日：2016-05-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.
摘要翻译： 根据一方面，用于将计算模型集成到执行计划中的数据库系统包括被配置为解析要应用于数据库的查询的第一引擎。 第一个引擎配置为在查询编译期间调用第二个引擎。 第二引擎被配置为基于查询实例化计算模型，并且第二引擎被配置为通过将计算模型转换成与第一引擎兼容的格式来导出转换的计算模型。 第一个引擎被配置为在查询编译期间将转换的计算模型合并到执行计划中，并根据执行计划对数据库执行查询。
-
公开(公告)号：US09229978B2
公开(公告)日：2016-01-05
申请号：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允许注册由规则引擎执行的新优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
15.发明申请Dynamic Resource-based Parallelization in Distributed Query Execution Frameworks 审中-公开分布式查询执行框架中基于动态资源的并行化公开(公告)号：US20150261765A1
公开(公告)日：2015-09-17
申请号：US14212163
申请日：2014-03-14
IPC分类号： G06F17/30
CPC分类号： G06F17/30067
摘要： 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.
摘要翻译： 作为分布式执行环境框架中查询处理的一部分，在生成执行计划时执行可用资源并执行执行计划以确定是否并行化任何操作。 还描述了相关装置，系统，方法和制品。
-
公开(公告)号：US20150142774A1
公开(公告)日：2015-05-21
申请号：US14083267
申请日：2013-11-18
IPC分类号： G06F17/30
CPC分类号： G06F17/30466
摘要： 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. The database server can be a column-oriented database and at least one of the calculation nodes comprises at least one join operation. Thereafter, the database server instantiates the calculation scenario so that it is optimized by removing one or more join operations and associated branches within the calculation scenario. 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.
摘要翻译： 数据库服务器从与计算方案相关联的远程应用程序服务器接收查询。 计算方案定义了一个数据流模型，其中包括一个或多个计算节点，每个计算节点定义一个或多个在数据库服务器上执行的操作。 数据库服务器可以是面向列的数据库，并且至少一个计算节点包括至少一个连接操作。 此后，数据库服务器实例化计算方案，以便通过在计算方案中删除一个或多个连接操作和关联的分支进行优化。 然后，数据库服务器执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 然后，数据库服务器将数据集提供给应用程序服务器。
-
公开(公告)号：US20150120746A1
公开(公告)日：2015-04-30
申请号：US14066496
申请日：2013-10-29
IPC分类号： G06F17/30
CPC分类号： G06F17/30477 , G06F17/30333 , G06F17/30424 , G06F17/30463 , G06F17/30489 , G06F17/30569
摘要： A database server receives a query associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server, the database server comprising a column-oriented database. Thereafter, the database server instantiates the calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set having a result table with a row for each column in the column-oriented database implicated by the query having a constant value. The database server then provides the data set to the application server. Related apparatus, systems, methods, and articles are also described.
摘要翻译： 数据库服务器接收与定义包括一个或多个计算节点的数据流模型的计算场景相关联的查询。 每个计算节点定义在数据库服务器上执行的一个或多个操作，数据库服务器包括一个面向列的数据库。 此后，数据库服务器实例化计算场景，并执行由实例化计算场景的计算节点定义的操作，以产生具有结果表的响应数据集，该结果表具有由查询所牵涉的面向列的数据库中的每列的行 具有恒定值。 然后，数据库服务器将数据集提供给应用程序服务器。 还描述了相关装置，系统，方法和制品。
-
公开(公告)号：US20140372409A1
公开(公告)日：2014-12-18
申请号：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.
摘要翻译： 接收到查询，并且生成包括多个节点的初始数据流图，以执行查询。 使用模型优化器来优化初始数据流图，该模型优化器访问多个模式中的至少一个以识别匹配模式并且执行与匹配模式相关联的至少一个优化规则。 然后使用优化的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
公开(公告)号：US08914387B2
公开(公告)日：2014-12-16
申请号：US13457315
申请日：2012-04-26
CPC分类号： G06F17/30463
摘要： A query statement is received that requires at least one calculated attribute. Thereafter, a data flow graph is generated that includes a plurality of nodes for executing the query. At least one of the nodes corresponds to the at least one calculated attribute and has at least one level of child nodes. The data flow graph is generated by generating at least one filter for each of the nodes corresponding to the at least one calculated attribute and by pushing down the generated filters to a corresponding child node. Once the data flow graph is generated, execution of the query can be initiated using the generated data flow graph. Related apparatus, systems, techniques and articles are also described.
摘要翻译： 接收到需要至少一个计算属性的查询语句。 此后，生成包括用于执行查询的多个节点的数据流图。 至少一个节点对应于至少一个计算的属性，并且具有至少一个级别的子节点。 通过针对与至少一个计算的属性相对应的每个节点生成至少一个过滤器并且通过将生成的过滤器推下到相应的子节点来生成数据流图。 一旦产生了数据流图，就可以使用生成的数据流图来启动查询的执行。 还描述了相关设备，系统，技术和物品。
-
20.发明申请公开(公告)号：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.
摘要翻译： 可以由计算引擎接收与包括多个计算节点的计算场景相关联的查询。 计算场景被实例化，并且基于可以在任何计算节点处执行的至少一个多选择条件将查询转换成凸包过滤器。 执行实例计算场景和凸包过滤器以提供结果集。 还描述了相关装置，系统，方法和制品。
-
-
-
-
-
-
-
-
-
搜索结果
69 条记录 (耗时 0.025 秒)
