公开(公告)号：US11893026B2

公开(公告)日：2024-02-06

申请号：US16372951

申请日：2019-04-02

Applicant: SAP SE

Inventor： Julian Schwing ,  Christoph Weyerhaeuser ,  Johannes Merx ,  Davide Corradi ,  Timo Hochberger

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/25 ,  G06F16/21

CPC classification number: G06F16/24561 ,  G06F16/217 ,  G06F16/2282 ,  G06F16/24544 ,  G06F16/256

Abstract: A calculation engine of a database management system is described that determines a multiprovider includes a first data source and a second data source that each require different approaches for operation optimization. The calculation engine can split the multiprovider into a first node corresponding to a first operation compatible with the first data source and a second node corresponding to a second operation compatible with the second data source. The calculation engine can perform the first operation at the first data source to produce a first result and perform the second operation at the second data source to produce a second result. The calculation engine can then merge the first result and the second result according to a third operation, and perform such third operation at the first data source.

公开(公告)号：US11188540B2

公开(公告)日：2021-11-30

申请号：US15945605

申请日：2018-04-04

Applicant: SAP SE

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

IPC: G06F16/2455 ,  G06F16/22

Abstract: Described herein includes a calculation scenario of a calculation engine that efficiently filters and joins data for processing. The calculation engine enhances the performance of the join operations by allowing join inputs to be pre-filtered more effectively. Such join operations can allow for faster processing times, and a reduction in the amount of data to be joined, resulting in more efficient processing.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US20170323001A1

公开(公告)日：2017-11-09

申请号：US15150365

申请日：2016-05-09

Applicant: SAP SE

Inventor： Julian Schwing ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F17/30

CPC classification number: G06F16/284 ,  G06F16/2365 ,  G06F16/2445

Abstract: A calculation engine of a database management system is described. In some implementations, the calculation engine receives a calculation scenario including a plurality of calculation views comprising one or more relational operations. The calculation engine determines whether a first calculation view includes a second calculation view configured as an operand of one of the relational operations of the first calculation view, and also determines whether the second calculation view comprises a non-relational operation. The calculation engine further converts the plurality of calculation views into a calculation plan via merging the first calculation view with the second calculation view when the first calculation view is determined to comprise the second calculation view as an operand, and replacing the second calculation view with a view search operation when the second calculation view is determined to comprise the non-relational operation. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20170322988A1

公开(公告)日：2017-11-09

申请号：US15150368

申请日：2016-05-09

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Johannes Merx

IPC: G06F17/30

CPC classification number: G06F16/24554

Abstract: A calculation engine of a database management system is described. In an exemplary implementation, the calculation engine receives a calculation scenario. The calculation scenario includes one or more relational operations and one or more non-relational operations of a multiprovider, the multiprovider utilizing a plurality of database partitions. The calculation engine processes the one or more non-relational operations via the multiprovider. After processing the one or more non-relational operations, the calculation engine converts the one or more relational operations. This converting comprises filtering first data from the plurality of partitions to form second data and forming third data by performing a union operation on the second data. Thereafter, the third data is filtered to form fourth data. Related systems, methods, and articles of manufacture 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.