公开(公告)号：US20160371330A1

公开(公告)日：2016-12-22

申请号：US14741377

申请日：2015-06-16

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing ,  Daniel Patejdl

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30451

Abstract: A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that 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 including handling of hierarchy views. Related apparatus, systems, methods, and articles are also described.

Abstract translation: 描述了执行包括指定要执行以执行查询的操作的多个计算节点的计算场景的计算引擎。 其中一个节点可以是一个语义节点，用于修改需要特殊处理的操作的查询，包括层次结构视图的处理。 还描述了相关装置，系统，方法和制品。

公开(公告)号：US10482110B2

公开(公告)日：2019-11-19

申请号：US15286445

申请日：2016-10-05

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Daniel Baeumges ,  Gerrit Simon Kazmaier

IPC: G06F16/28 ,  G06F16/29 ,  G06F16/22 ,  G06F16/2457

Abstract: A range k-nearest neighbor search query of a database is processed by first defining an inner rectangle bounded within a circle around a center point specified by the range k-nearest neighbor search query. Thereafter, a distance to the center point is calculated for each point within the inner rectangle. Query results are returned if k or more points are within the inner rectangle. Otherwise, at least one additional query is executed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US10303726B2

公开(公告)日：2019-05-28

申请号：US14540781

申请日：2014-11-13

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Joerg Schad ,  Stefan Dipper

IPC: G06F16/9535 ,  G06F16/2453 ,  G06F16/901

Abstract: 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.

公开(公告)号：US10255316B2

公开(公告)日：2019-04-09

申请号：US14945339

申请日：2015-11-18

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Alena Bakulina ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing

IPC: G06F17/30

Abstract: A database server receives a request to perform a primary query on a table of a database. A first table query can be generated and can include a starting row identifier, ROW A, and a number of rows, n, for generating a data chunk from the table of the database. Multiple table queries can be performed each having a different starting row identifier and each defining the number of rows forming a data chunk. The primary query can be extended with the first table query in preparation for performing the primary query on the first data chunk.

公开(公告)号：US10067980B2

公开(公告)日：2018-09-04

申请号：US14741377

申请日：2015-06-16

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing ,  Daniel Patejdl

IPC: G06F17/30

Abstract: A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that 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 including handling of hierarchy views. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US20170147636A1

公开(公告)日：2017-05-25

申请号：US14947627

申请日：2015-11-20

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing

IPC: G06F17/30

Abstract: Methods and apparatus, including computer program products, are provided for first and last aggregation. In one aspect, there is provided a method, which may include receiving, by a calculation engine, a query; detecting, by the calculation engine, whether the query includes a first aggregation and/or a last aggregation over at least one group and at least one keyfigure; optimizing the received query, when the detecting indicates the received query includes the first aggregation and/or the last aggregation, wherein the optimizing further comprises initiating execution of the received query by at least: performing a single read of a table, detecting, from the single table read, at least one group, and indicating, in the detected at least one group, the first aggregation in the at least one keyfigure and/or the last aggregation in the at least one keyfigure; and returning, for the at least one detected group, the indicated first aggregation and/or the indicated second aggregation. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US20160350374A1

公开(公告)日：2016-12-01

申请号：US14723205

申请日：2015-05-27

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing ,  Daniel Patejdl ,  Isil Pekel

IPC: G06F17/30

CPC classification number: G06F17/30466

Abstract: A query 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 including stacked multiproviders. Subsequently, the database server instantiates the calculation scenario and afterwards optimizes the calculation scenario. As part of the optimization, the calculation scenario is optimized by merging the two multiproviders. Thereafter, the operations defined by the calculation nodes of the optimized 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.

Abstract translation: 来自远程应用服务器的数据库服务器接收到查询，该远程应用程序服务器与定义包括一个或多个计算节点（包括堆叠的多维数据集）的数据流模型的计算方案相关联。 随后，数据库服务器实例化计算方案，然后优化计算方案。 作为优化的一部分，通过合并两个多维数据集优化计算方案。 此后，可以执行由优化的计算场景的计算节点定义的操作以产生响应数据集。 接下来，由数据库服务器将数据集提供给应用服务器。

公开(公告)号：US20160224628A1

公开(公告)日：2016-08-04

申请号：US15094708

申请日：2016-04-08

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Daniel Baeumges ,  Tobias Mindnich ,  Thomas Legler

IPC: G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30463 ,  G06F17/30466 ,  G06F17/30867

Abstract: 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.

Abstract translation: 数据库服务器从远程应用程序服务器接收到选择查询或引用计算方案的数据。 指定的计算场景是多个计算场景之一，并且其定义包括一个或多个计算节点的数据流模型。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器实例化指定的计算方案，并执行由实例化计算方案的计算节点定义的操作，以生成响应数据集。 然后，该数据集由数据库服务器提供给应用服务器。 还描述了相关设备，系统，技术和物品。

公开(公告)号：US11106666B2

公开(公告)日：2021-08-31

申请号：US14723627

申请日：2015-05-28

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/25

Abstract: A query that requests a filter attribute is received by a database server from a remote application server that is associated with at least one calculation scenario that includes calculation nodes having relational operators and calculation nodes having non-relational operators. The calculation nodes having relational or non-relational operators are optimized by a calculation engine model optimizer and the calculation nodes having relational operators are further optimized by a relational database optimizer. Thereafter, the operations defined by the optimized calculation nodes can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.

公开(公告)号：US11023468B2

公开(公告)日：2021-06-01

申请号：US14947627

申请日：2015-11-20

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Julian Schwing

IPC: G06F16/24 ,  G06F16/2455

Abstract: Methods and apparatus, including computer program products, are provided for first and last aggregation. In one aspect, there is provided a method, which may include receiving, by a calculation engine, a query; detecting, by the calculation engine, whether the query includes a first aggregation and/or a last aggregation over at least one group and at least one keyfigure; optimizing the received query, when the detecting indicates the received query includes the first aggregation and/or the last aggregation, wherein the optimizing further comprises initiating execution of the received query by at least: performing a single read of a table, detecting, from the single table read, at least one group, and indicating, in the detected at least one group, the first aggregation in the at least one keyfigure and/or the last aggregation in the at least one keyfigure; and returning, for the at least one detected group, the indicated first aggregation and/or the indicated second aggregation. Related apparatus, systems, methods, and articles are also described.