Distributed joins in a distributed database system

    公开(公告)号:US10657127B2

    公开(公告)日:2020-05-19

    申请号:US15362586

    申请日:2016-11-28

    Applicant: SAP SE

    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.

    DISTRIBUTED JOINS IN A DISTRIBUTED DATABASE SYSTEM

    公开(公告)号:US20180150521A1

    公开(公告)日:2018-05-31

    申请号:US15362586

    申请日:2016-11-28

    Applicant: SAP SE

    CPC classification number: G06F16/24544 G06F16/2282 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.

Patent Agency Ranking