公开(公告)号：US20140258266A1

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

申请号：US13787663

申请日：2013-03-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Thierry Cruanes ,  Junyi Xie ,  Yiu Woon Lau

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30442 ,  G06F17/3046 ,  G06F17/30466 ,  G06F17/30489 ,  G06F17/30498 ,  G06F17/30516 ,  G06F17/30545

Abstract: Techniques are provided for sharing expression evaluation across a database management system and a storage layer. According to an embodiment, a plurality of target operators are identified that include a common expression. Each respective target operator corresponds to a step that evaluates the common expression during query execution. The plurality of target operators are modified to enable sharing of an evaluation result of the common expression. The query is executed according to the target operators. During query execution, the evaluation result is shared by the target operators. In other embodiments, the evaluation of the common expression is pushed to a storage layer. During query execution, a database management system retrieves the evaluation result of the common expression from the storage layer.

Abstract translation: 提供了用于在数据库管理系统和存储层中共享表达式评估的技术。 根据实施例，识别包括公共表达式的多个目标运算符。 每个相应的目标运算符对应于在查询执行期间评估公共表达式的步骤。 修改多个目标操作符以使得能够共享公共表达式的评估结果。 查询根据目标运算符执行。 在查询执行期间，评估结果由目标运算符共享。 在其他实施例中，将公共表达式的评估推送到存储层。 在查询执行期间，数据库管理系统从存储层检索公共表达式的评估结果。

公开(公告)号：US10606834B2

公开(公告)日：2020-03-31

申请号：US15716345

申请日：2017-09-26

Applicant: Oracle International Corporation

Inventor： Thierry Cruanes ,  Junyi Xie ,  Yiu Woon Lau

IPC: G06F17/30 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458

Abstract: Techniques are provided for sharing expression evaluation across a database management system and a storage layer. In an embodiment, a computer identifies, in a query execution plan compiled for a query, a plurality of target operators that includes an expression that computes a common value. A storage layer evaluates the expression that computes the common value during a table scan of stored data indicated by the expression. For at least one target operator of the plurality of target operators, the computer modifies a row input of the at least one target operator to add a column to receive an evaluation result comprising the common value from the storage layer. The query execution plan is performed by a database management system and the storage layer.

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

公开(公告)号：US20180144029A1

公开(公告)日：2018-05-24

申请号：US15716345

申请日：2017-09-26

Applicant: Oracle International Corporation

Inventor： Thierry Cruanes ,  Junyi Xie ,  Yiu Woon Lau

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/2453 ,  G06F16/2454 ,  G06F16/24544 ,  G06F16/24556 ,  G06F16/2456 ,  G06F16/24568 ,  G06F16/2471

Abstract: Techniques are provided for sharing expression evaluation across a database management system and a storage layer. In an embodiment, a computer identifies, in a query execution plan compiled for a query, a plurality of target operators that includes an expression that computes a common value. A storage layer evaluates the expression that computes the common value during a table scan of stored data indicated by the expression. For at least one target operator of the plurality of target operators, the computer modifies a row input of the at least one target operator to add a column to receive an evaluation result comprising the common value from the storage layer. The query execution plan is performed by a database management system and the storage layer.

公开(公告)号：US09773041B2

公开(公告)日：2017-09-26

申请号：US13787663

申请日：2013-03-06

Applicant: Oracle International Corporation

Inventor： Thierry Cruanes ,  Junyi Xie ,  Yiu Woon Lau

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30442 ,  G06F17/3046 ,  G06F17/30466 ,  G06F17/30489 ,  G06F17/30498 ,  G06F17/30516 ,  G06F17/30545

Abstract: Techniques are provided for sharing expression evaluation across a database management system and a storage layer. According to an embodiment, a plurality of target operators are identified that include a common expression. Each respective target operator corresponds to a step that evaluates the common expression during query execution. The plurality of target operators are modified to enable sharing of an evaluation result of the common expression. The query is executed according to the target operators. During query execution, the evaluation result is shared by the target operators. In other embodiments, the evaluation of the common expression is pushed to a storage layer. During query execution, a database management system retrieves the evaluation result of the common expression from the storage layer.

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