公开(公告)号：US11386087B2

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

申请号：US16374521

申请日：2019-04-03

Applicant: SAP SE

Inventor： Marius Eich ,  Dennis Felsing

IPC: G06F16/245 ,  G06F16/2453

Abstract: In some aspects, there is provided a method including receiving an execution plan file, the execution plan file utilizing at least one operator of interest and further utilizing other actions separate from the at least one operator of interest. The method further includes forming an execution plan object by modifying the execution plan file by isolating the at least one operator of interest from the other actions. The method further includes performing a series of tests executing an extended execution plan object. The series of tests can include receiving the input data identified by the one or more pointers in the extended execution plan object, executing the extended execution plan object using the received input data, measuring, based on the execution of the extended execution plan object, at least one cost metric representative of execution of the at least one operator of interest, and outputting the measured cost metric.

公开(公告)号：US20200320078A1

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

申请号：US16374521

申请日：2019-04-03

Applicant: SAP SE

Inventor： Marius Eich ,  Dennis Felsing

IPC: G06F16/2453

Abstract: In some aspects, there is provided a method including receiving an execution plan file, the execution plan file utilizing at least one operator of interest and further utilizing other actions separate from the at least one operator of interest. The method further includes forming an execution plan object by modifying the execution plan file by isolating the at least one operator of interest from the other actions. The method further includes performing a series of tests executing an extended execution plan object. The series of tests can include receiving the input data identified by the one or more pointers in the extended execution plan object, executing the extended execution plan object using the received input data, measuring, based on the execution of the extended execution plan object, at least one cost metric representative of execution of the at least one operator of interest, and outputting the measured cost metric.

公开(公告)号：US20250036627A1

公开(公告)日：2025-01-30

申请号：US18358270

申请日：2023-07-25

Applicant: SAP SE

Inventor： Marius Eich ,  Christina Teflioudi ,  Paul Willems

IPC: G06F16/2455 ,  G06F16/2453

Abstract: In some implementations, there is provided executing a query execution plan for a query; setting a first flag to indicate to a plurality of worker threads to stop executing tasks in a first queue of a memory stack; pushing into the memory stack, a second queue containing one or more exclusive tasks associated with the query; setting a second flag to indicate to the plurality of worker threads to resume working; and in response to the second queue being empty of the one or more exclusive tasks, setting a third flag to indicate to the plurality of worker threads to stop executing tasks in the second queue, and setting a fourth flag to indicate to the plurality of worker threads to resume working on the tasks in the first queue.

公开(公告)号：US11138165B2

公开(公告)日：2021-10-05

申请号：US16375008

申请日：2019-04-04

Applicant: SAP SE

Inventor： Oliver Horn ,  Marius Eich

IPC: G06F17/00 ,  G06F16/21 ,  G06F16/22 ,  G06F16/2453

Abstract: A method, a system, and a computer program product for executing a query. A query plan for execution of a query is generated. The query requires access to at least one table stored in a database system. The query includes one or more filter predicates. A filter predicate in the one or more filter predicates is selected. For the selected filter predicate, a plurality of cost function values associated executing a filter evaluation of the selected filter predicate are determined. Filter evaluation of the selected predicate is executed in accordance with at least one determined cost function value in the plurality of cost function values.

公开(公告)号：US20200320048A1

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

申请号：US16375008

申请日：2019-04-04

Applicant: SAP SE

Inventor： Oliver Horn ,  Marius Eich

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

Abstract: A method, a system, and a computer program product for executing a query. A query plan for execution of a query is generated. The query requires access to at least one table stored in a database system. The query includes one or more filter predicates. A filter predicate in the one or more filter predicates is selected. For the selected filter predicate, a plurality of cost function values associated executing a filter evaluation of the selected filter predicate are determined. Filter evaluation of the selected predicate is executed in accordance with at least one determined cost function value in the plurality of cost function values.