公开(公告)号：US10324930B2

公开(公告)日：2019-06-18

申请号：US14723205

申请日：2015-05-27

Applicant: SAP SE

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

IPC: G06F16/20 ,  G06F16/2453 ,  G06F16/27 ,  G06F16/28

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.

公开(公告)号：US10324927B2

公开(公告)日：2019-06-18

申请号：US14946658

申请日：2015-11-19

Applicant: SAP SE

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

IPC: G06F16/2453

Abstract: Methods and apparatus, including computer program products, are provided for union node pruning. In one aspect, there is provided a method, which may include receiving, by a calculation engine, a query; processing a calculation scenario including a union node; accessing a pruning table associated with the union node, wherein the pruning table includes semantic information describing the first input from the first data source node and the second input from the second data source node; determining whether the first data source node and the second data source node can be pruned by at least comparing the semantic information to at least one filter of the query; and pruning, based on a result of the determining, at least one the first data source node or the second data source node. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US10140335B2

公开(公告)日：2018-11-27

申请号：US14945300

申请日：2015-11-18

Applicant: SAP SE

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

IPC: G06F17/30

Abstract: 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 a higher-level programming language query that stacks the calculation scenario on top of another semantic node based calculation scenario for operations that call for processing of non-processable key figures. Non-processable key figures being key figures that produce incorrect semantics when processed by higher-level calculation scenarios. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US20170139988A1

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

申请号：US14945360

申请日：2015-11-18

Applicant: SAP SE

Inventor： JOHANNES MERX ,  Tobias Mindnich ,  Christoph Weyerhaeuser

IPC: G06F17/30

CPC classification number: G06F17/30451

Abstract: A stacked calculation view, defining a calculation scenario, having calculation views associated with high-level programming logic which can include complex analytical privileges. Resolving, using a high-level programming logic layer, a calculation view having associated high-level programming logic with the next calculation view in the stack to generate a sub-query. Converting the sub-query into a format readable by a database system and separating the part of the sub-query provided by the high-level programming logic from the sub-query to form a high-level programming logic filter in the database system format. Merge the high-level programming logic filter into the calculation scenario to provide a calculation scenario including high-level programming logic information in the database system format.

公开(公告)号：US20170139982A1

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

申请号：US14945339

申请日：2015-11-18

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F17/30395 ,  G06F17/30557

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.

公开(公告)号：US20160350368A1

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

申请号：US14723627

申请日：2015-05-28

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: 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.

Abstract translation: 请求过滤器属性的查询由数据库服务器从与包括具有关系运算符的计算节点和具有非关系运算符的计算节点的至少一个计算方案相关联的远程应用程序服务器接收。 具有关系或非关系运算符的计算节点由计算引擎模型优化器进行优化，并且具有关系运算符的计算节点由关系数据库优化器进一步优化。 此后，可以执行由优化的计算节点定义的操作以产生响应数据集。 接下来，由数据库服务器将数据集提供给应用服务器。