公开(公告)号：US20200320082A1

公开(公告)日：2020-10-08

申请号：US16372951

申请日：2019-04-02

Applicant: SAP SE

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

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

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.

公开(公告)号：US20170139989A1

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

申请号：US14945207

申请日：2015-11-18

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F16/24537 ,  G06F16/24545 ,  G06F16/24554

Abstract: A calculation engine of a database management system receives a calculation scenario. The calculation scenario comprises a query of a multiprovider that comprises a plurality of partitions. The calculation engine evaluates the query to identify a partition of the plurality of partitions that is not necessary for responding to the query. The calculation engine prunes the partition from the calculation scenario. The pruning comprises not loading or accessing the partition in the execution of the query and/or removing the filter constraint for the partition.

公开(公告)号：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: 描述了执行包括指定要执行以执行查询的操作的多个计算节点的计算场景的计算引擎。 其中一个节点可以是一个语义节点，用于修改需要特殊处理的操作的查询，包括层次结构视图的处理。 还描述了相关装置，系统，方法和制品。

公开(公告)号：US10558652B2

公开(公告)日：2020-02-11

申请号：US15650800

申请日：2017-07-14

Applicant: SAP SE

Inventor： Julian Schwing ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F17/30 ,  G06F16/242 ,  G06F16/84 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

Abstract: A method may include executing a calculation scenario at a database. The calculation scenario may include a parent multiprovider aggregating data from a child multiprovider. The calculation scenario may be executed by mapping a first count keyfigure of the child multiprovider to a first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from part providers but not from multiproviders. A second sum keyfigure of the child multiprovider may be mapped to the first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from multiproviders but not from any part providers. The first count keyfigure of the child multiprovider may be mapped to a second count keyfigure of the parent multiprovider and the second sum keyfigure of the child multiprovider may be mapped to the first sum keyfigure of the parent multiprovider if the child multiprovider aggregates data from part providers and multiproviders.

公开(公告)号：US10552388B2

公开(公告)日：2020-02-04

申请号：US15402779

申请日：2017-01-10

Applicant: SAP SE

Inventor： Davide Corradi ,  Daniel Patejdl ,  Christoph Weyerhaeuser ,  Johannes Merx ,  Julian Schwing

IPC: G06F16/215 ,  G06F16/25

Abstract: Described herein includes finding and replacing, including automatically, at least one null value in a table for allowing processing of the table with an ABAP-based application. In some implementations, the null values are replaced with replacement values that are compatible with further processing of the data in the table. For example, a replacement value can be a string providing information or a value, such as for performing a calculation.

公开(公告)号：US10452659B2

公开(公告)日：2019-10-22

申请号：US15412765

申请日：2017-01-23

Applicant: SAP SE

Inventor： Berthold Von Haaren ,  Christoph Weyerhaeuser ,  Johannes Merx ,  Julian Schwing

IPC: G06F17/30 ,  G06F16/2455 ,  G06F16/28

Abstract: Described herein includes processing various instruction sets configured for online analytics processing (OLAP) using a calculation engine. This allows OLAP configured instruction sets or calculation scenarios to be efficiently and effectively processed with the calculation engine during run time thereby preventing delays and errors during processing.

公开(公告)号：US20180210921A1

公开(公告)日：2018-07-26

申请号：US15412765

申请日：2017-01-23

Applicant: SAP SE

Inventor： Berthold Von Haaren ,  Christoph Weyerhaeuser ,  Johannes Merx ,  Julian Schwing

IPC: G06F17/30

CPC classification number: G06F16/2456 ,  G06F16/283

Abstract: Described herein includes processing various instruction sets configured for online analytics processing (OLAP) using a calculation engine. This allows OLAP configured instruction sets or calculation scenarios to be efficiently and effectively processed with the calculation engine during run time thereby preventing delays and errors during processing.

公开(公告)号：US20180196833A1

公开(公告)日：2018-07-12

申请号：US15402779

申请日：2017-01-10

Applicant: SAP SE

Inventor： Davide Corradi ,  Daniel Patejdl ,  Christoph Weyerhaeuser ,  Johannes Merx ,  Julian Schwing

IPC: G06F17/30

Abstract: Described herein includes finding and replacing, including automatically, at least one null value in a table for allowing processing of the table with an ABAP-based application. In some implementations, the null values are replaced with replacement values that are compatible with further processing of the data in the table. For example, a replacement value can be a string providing information or a value, such as for performing a calculation.

公开(公告)号：US11113285B2

公开(公告)日：2021-09-07

申请号：US15945022

申请日：2018-04-04

Applicant: SAP SE

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

IPC: G06F17/30 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/2453

Abstract: Described herein includes a calculation scenario of a calculation engine that efficiently partitions data for processing at separate hosts, including in parallel, and unions intermediate results from such separate processing when required for further processing. Such parallel processing of partitions can allow for faster processing times, and such unioning of data only when required for further processing can limit the transferring of data that results in slower processing.

公开(公告)号：US20210182299A1

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

申请号：US16711141

申请日：2019-12-11

Applicant: SAP SE

Inventor： Michael Ludwig ,  Johannes Merx ,  Christoph Weyerhaeuser ,  Julian Schwing

IPC: G06F16/2457 ,  G06F16/21 ,  G06F16/27

Abstract: A calculation engine of a database management system is described. The calculation engine may receive a query associated with a calculation scenario that defines a data flow model. The data flow model may include one or more calculation nodes, each of which corresponding to an operation performed on one or more database tables stored at a database. The one or more calculation nodes may include at least one calculation node corresponding to a ranking filter operation. The calculation engine may execute the query including by executing the calculation scenario. The executing of the calculation scenario may include performing the ranking filter operation to generate a result corresponding to at least a portion of rows included in a first partition of a database table stored at the database. Related systems, methods, and articles of manufacture are provided.