公开(公告)号：US10437821B2

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

申请号：US15335330

申请日：2016-10-26

Applicant: SAP SE

Inventor： Benny Goerzig ,  Mathias Kohler ,  Florian Kerschbaum

IPC: G06F16/2453 ,  G06F21/60 ,  G06F21/62

Abstract: Methods and apparatus, including computer program products, are provided for split query optimization. In some example embodiments, a method may include: determining, for a query comprising a plurality of operations, a first workload distribution between a first data store and a second data store, the first workload distribution indicating that a first portion of the query is to be performed at the first data store and a second portion of the query is to be performed at the second data store; and determining, based at least on the first workload distribution, a second workload distribution, the determining of the second workload distribution includes pushing down, to the first portion of the query, a first operation from the second portion of the query such that the first operation is performed at the first data store instead of at the second data store.

公开(公告)号：US20180113905A1

公开(公告)日：2018-04-26

申请号：US15335330

申请日：2016-10-26

Applicant: SAP SE

Inventor： Benny Goerzig ,  Mathias Kohler ,  Florian Kerschbaum

IPC: G06F17/30 ,  G06F9/50 ,  G06F21/60

CPC classification number: G06F16/24542 ,  G06F21/602 ,  G06F21/6218

Abstract: Methods and apparatus, including computer program products, are provided for split query optimization. In some example embodiments, a method may include: determining, for a query comprising a plurality of operations, a first workload distribution between a first data store and a second data store, the first workload distribution indicating that a first portion of the query is to be performed at the first data store and a second portion of the query is to be performed at the second data store; and determining, based at least on the first workload distribution, a second workload distribution, the determining of the second workload distribution includes pushing down, to the first portion of the query, a first operation from the second portion of the query such that the first operation is performed at the first data store instead of at the second data store.