公开(公告)号：US09842137B2

公开(公告)日：2017-12-12

申请号：US14590769

申请日：2015-01-06

Applicant: SAP SE

Inventor： Franz Faerber ,  Daniel Baeumges ,  Tobias Mindnich ,  Christoph Weyerhaeuser

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30315 ,  G06F17/30404 ,  G06F17/30433 ,  G06F17/30471

Abstract: The present invention includes a database with a semantic layer for performing standard SQL and complex operations custom to one or more application. In one embodiment the present invention includes receiving a data request from an application in a database, the data request specifying standard SQL operations and custom application operations to be performed for said application. The data request is processed in a semantic layer of the database. The semantic layer processes the standard SQL operations and the custom application operations and generates a logical execution plan comprising the standard SQL operations and the custom application operations. The logical execution plan is converted into a physical execution plan, which is executed by the database to generate a data result. The data result may be sent back to the application.

公开(公告)号：US09672250B2

公开(公告)日：2017-06-06

申请号：US15094708

申请日：2016-04-08

Applicant: SAP SE

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

IPC: G06F17/30 ,  G06F7/00

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.

公开(公告)号：US20170147705A1

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

申请号：US14946664

申请日：2015-11-19

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F17/30404

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.

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

公开(公告)号：US20170139987A1

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

申请号：US14945300

申请日：2015-11-18

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F17/30427

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.

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

公开(公告)号：US11455308B2

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

申请号：US15354852

申请日：2016-11-17

Applicant: SAP SE

Inventor： Julian Schwing ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F16/2455

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.

公开(公告)号：US11372863B2

公开(公告)日：2022-06-28

申请号：US16711141

申请日：2019-12-11

Applicant: SAP SE

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

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

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.

公开(公告)号：US10831784B2

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

申请号：US15150365

申请日：2016-05-09

Applicant: SAP SE

Inventor： Julian Schwing ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F16/28 ,  G06F16/23 ,  G06F16/242

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.

公开(公告)号：US10713244B2

公开(公告)日：2020-07-14

申请号：US15150371

申请日：2016-05-09

Applicant: SAP SE

Inventor： Julian Schwing ,  Johannes Merx ,  Christoph Weyerhaeuser

IPC: G06F16/2453

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 join operations defining an intersection between at least two nodes. The calculation engine optimizes a first join which is of a certain cardinality, and for which no attributes are requested, other than a join attribute. The optimization includes determining whether a static filter is present for a first node or a second node of the first join, and pruning the first node and/or the second node from the hierarchical join when the attribute is not requested from the first node or the second node and/or when the static filter is not present for the first node or the second node. Related systems, methods, and articles of manufacture are also described.