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