Invention Grant
- Patent Title: Distributed joins in a distributed database system
-
Application No.: US15362586Application Date: 2016-11-28
-
Publication No.: US10657127B2Publication Date: 2020-05-19
- Inventor: Kornel Skalkowski , Youssef Hatem , Stephan Kessler , Christian Mathis
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/22 ; G06F16/2455

Abstract:
In one respect, there is provided a distributed database system that includes hosts configured to store and/or manage data, a first query processing engine comprising a master node and an executor node, and a second query processing engine. The master node can be implemented on programmable processors and configured to perform operations. The operations can include: offloading, to the second query processing engine, a creation of a first and a second table such that the first and the second table are partitioned by the second query processing engine; generating an execution plan for a query on data in the distributed database system, the execution plan including a distributed join operation that combines data from the first and second table; determining to push down, to the second query processing engine, the distributed join operation; and dispatching, to the executor node, a portion of the execution plan including the distributed join operation.
Public/Granted literature
- US20180150521A1 DISTRIBUTED JOINS IN A DISTRIBUTED DATABASE SYSTEM Public/Granted day:2018-05-31
Information query