公开(公告)号：US20210303583A1

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

申请号：US16832419

申请日：2020-03-27

Applicant: SAP SE

Inventor： Michael Ludwig ,  Johannes Merx

IPC: G06F16/2457 ,  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 a first calculation node corresponding to a ranking filter operation. A calculation engine executes the calculation scenario and performs the ranking filter operation to generate a data structure storing a plurality of rows of the database tables. Based on the executing of the calculation scenario, a result data set including at least one row from the plurality of rows is generated and provided by a database server to an application server.

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

公开(公告)号：US12147434B2

公开(公告)日：2024-11-19

申请号：US16832419

申请日：2020-03-27

Applicant: SAP SE

Inventor： Michael Ludwig ,  Johannes Merx

IPC: G06F16/2457 ,  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 a first calculation node corresponding to a ranking filter operation. A calculation engine executes the calculation scenario and performs the ranking filter operation to generate a data structure storing a plurality of rows of the database tables. Based on the executing of the calculation scenario, a result data set including at least one row from the plurality of rows is generated and provided by a database server to an application server.

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

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