公开(公告)号：US11442934B2

公开(公告)日：2022-09-13

申请号：US16833318

申请日：2020-03-27

Applicant: SAP SE

Inventor： Michael Ludwig ,  Johannes Merx ,  Matthias Vigelius ,  Christoph Weyerhaeuser

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/22

Abstract: A method, a system, and a computer program product for executing a query. A query associated with a calculation scenario defining a data flow model that includes one or more calculation nodes is received. Each calculation node corresponds to an operation being performed on one or more database tables stored at a database. The calculation nodes include one or more nodes specifying a window function operation. The window function operation including one or more first attributes and one or more second attributes. A calculation engine executes the calculation scenario by performing, using at least one of the first and second attributes, the window function operation on the database tables stored at the database. Based on the execution of the calculation scenario, a result data set is generated and provided by the database server to the application server.

公开(公告)号：US20210303562A1

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

申请号：US16833318

申请日：2020-03-27

Applicant: SAP SE

Inventor： Michael Ludwig ,  Johannes Merx ,  Matthias Vigelius ,  Christoph Weyerhaeuser

IPC: G06F16/2453 ,  G06F16/22

Abstract: A method, a system, and a computer program product for executing a query. A query associated with a calculation scenario defining a data flow model that includes one or more calculation nodes is received. Each calculation node corresponds to an operation being performed on one or more database tables stored at a database. The calculation nodes include one or more nodes specifying a window function operation. The window function operation including one or more first attributes and one or more second attributes. A calculation engine executes the calculation scenario by performing, using at least one of the first and second attributes, the window function operation on the database tables stored at the database. Based on the execution of the calculation scenario, a result data set is generated and provided by the database server to the application server.

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

公开(公告)号：US10114859B2

公开(公告)日：2018-10-30

申请号：US14946664

申请日：2015-11-19

Applicant: SAP SE

Inventor： Romans Kasperovics ,  Tobias Mindnich ,  Cornelia Kinder ,  Christoph Weyerhaeuser ,  Thomas Fischer

IPC: G06F17/30

Abstract: Based on received input, a vertex table of the database layer and a vertex key column in the vertex table can be identified. The vertex key column defines vertices of a graph representation. Also based on the received input, an edge table of the database layer, an edge key column in the edge table, a source column in the edge table, and a target column in the edge table can be identified. The source column and target column define relationships between vertices of the plurality of vertices. Within a graph workspace object, graph relationships linking the vertices defined by the vertex key column via edges defined by the source column and target column in the edge table can be assigned, and the graph workspace can be generated in a higher level programming layer based on the graph workspace object.

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

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

公开(公告)号：US20180137011A1

公开(公告)日：2018-05-17

申请号：US15354852

申请日：2016-11-17

Applicant: SAP SE

Inventor： JULIAN SCHWING ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F16/24554

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.