公开(公告)号：US11294903B2

公开(公告)日：2022-04-05

申请号：US16373950

申请日：2019-04-03

Applicant: SAP SE

Inventor： JunGyoung Seong ,  Jane Jung Lee ,  Jung Kook Lee ,  Sehee Shim

IPC: G06F16/2453 ,  G06F16/2458

Abstract: A system includes determination, for a first partitioned physical query operator in a query operator tree, of a partition-wise placement cost based on a cost of each table partition associated with the first partitioned physical query operator and a partition-wise placement cost of any child physical query operator of the first partitioned physical query operator, determination of a placement cost for the first partitioned physical query operator physical query operator for each of a plurality of operator execution locations based on the determined partition-wise placement cost, determination, for a logical query operator associated with the first partitioned physical query operator, of a merged placement cost for each of the plurality of operator execution locations, and determination an execution location for the first partitioned physical query operator based on the determined partition-wise placement cost.

公开(公告)号：US20200320077A1

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

申请号：US16373950

申请日：2019-04-03

Applicant: SAP SE

Inventor： JunGyoung Seong ,  Jane Jung Lee ,  Jung Kook Lee ,  Sehee Shim

IPC: G06F16/2453

Abstract: A system includes determination, for a first partitioned physical query operator in a query operator tree, of a partition-wise placement cost based on a cost of each table partition associated with the first partitioned physical query operator and a partition-wise placement cost of any child physical query operator of the first partitioned physical query operator, determination of a placement cost for the first partitioned physical query operator physical query operator for each of a plurality of operator execution locations based on the determined partition-wise placement cost, determination, for a logical query operator associated with the first partitioned physical query operator, of a merged placement cost for each of the plurality of operator execution locations, and determination an execution location for the first partitioned physical query operator based on the determined partition-wise placement cost.