公开(公告)号：US20140280022A1

公开(公告)日：2014-09-18

申请号：US13839228

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Unmesh Jagtap ,  Thierry Cruanes

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30498

Abstract: A method, system, and computer program product for planning relational database joins in systems with multiple parallel computational units. The computer implemented method compiles an execution plan for dissemination to a plurality of execution units where the plan combines a smaller left-side table with a portion of a larger right-side object to reduce system overhead. Upon receiving a request for a join operation comprising left-side table data and right-side table data where the left-side table data is much smaller than the right-side table data, then the method compiles a plan to apportion an entirety of the left-side table data and only a portion of the right-side object to a plurality of computational units. The method continues by sending distribution instructions to respective computational units where the distribution instructions include retrieval of the entirety of the left-side table data with the retrieval of only a portion of the right-side object.

Abstract translation: 一种用于在具有多个并行计算单元的系统中规划关系数据库连接的方法，系统和计算机程序产品。 计算机实现的方法编译用于传播到多个执行单元的执行计划，其中计划将较小的左侧表与较大右侧对象的一部分组合以减少系统开销。 在接收到包括左侧表数据和左侧表数据远小于右侧表数据的左侧表数据和右侧表数据的联接操作的请求时，该方法编译计划以分配整数 左侧表数据和右侧对象的一部分到多个计算单元。 该方法继续通过发送分发指令到相应的计算单元，其中分发指令包括仅检索右侧对象的一部分的左侧表格数据的整体的检索。

公开(公告)号：US10019481B2

公开(公告)日：2018-07-10

申请号：US13839399

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Unmesh Jagtap ,  Andrew Witkowski ,  Mohamed Zait ,  Allison Waingold Lee ,  Hari Sankar Sivarama Subramaniyan ,  Thierry Cruanes

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/2456

Abstract: A method, system, and computer program product for high-performance database systems. The method commences by estimating, during a compile phase, a statically-calculated system cost of performing parallel join operations over two relations, then selecting, during the compile phase, a first distribution method to perform the parallel join operations. Instructions (e.g., table partitioning) are communicated to two or more execution units for execution of the parallel join operations, and during execution, various measurements are taken pertaining to the performance of a first portion of the parallel join operations using the selected first distribution method. Then, responsive to the measurements a second distribution method is selected and corresponding instructions are communicated to the two or more execution units. The parallel join operations continue, now using the second distribution method.

公开(公告)号：US09298772B2

公开(公告)日：2016-03-29

申请号：US13839228

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Unmesh Jagtap ,  Thierry Cruanes

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30498

Abstract: A method, system, and computer program product for planning relational database joins in systems with multiple parallel computational units. The computer implemented method compiles an execution plan for dissemination to a plurality of execution units where the plan combines a smaller left-side table with a portion of a larger right-side object to reduce system overhead. Upon receiving a request for a join operation comprising left-side table data and right-side table data where the left-side table data is much smaller than the right-side table data, then the method compiles a plan to apportion an entirety of the left-side table data and only a portion of the right-side object to a plurality of computational units. The method continues by sending distribution instructions to respective computational units where the distribution instructions include retrieval of the entirety of the left-side table data with the retrieval of only a portion of the right-side object.

Abstract translation: 一种用于在具有多个并行计算单元的系统中规划关系数据库连接的方法，系统和计算机程序产品。 计算机实现的方法编译用于传播到多个执行单元的执行计划，其中计划将较小的左侧表与较大的右侧对象的一部分组合以减少系统开销。 在接收到包括左侧表数据和左侧表数据远小于右侧表数据的左侧表数据和右侧表数据的加入操作的请求时，该方法编译计划以分配整数 左侧表数据和右侧对象的一部分到多个计算单元。 该方法继续通过发送分发指令到相应的计算单元，其中分发指令包括仅检索右侧对象的一部分的左侧表格数据的整体的检索。