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

公开(公告)号：US20140337314A1

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

申请号：US14339412

申请日：2014-07-23

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Yiu Woon Lau ,  Hakan Jakobsson ,  Umesh Panchaksharaiah ,  Poojan Kumar

IPC: G06F17/30

CPC classification number: G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

Abstract: Processing resources at a storage system for a database server are utilized to perform aspects of a join operation that would conventionally be performed by the database server. When requesting a range of data units from a storage system, the database server includes join metadata describing aspects of the join operation for which the data is being requested. The join metadata may be, for instance, a bloom filter. The storage system reads the requested data from disk as normal. However, prior to sending the requested data back to the storage system, the storage system analyzes the raw data based on the join metadata, removing a certain amount of data that is guaranteed to be irrelevant to the join operation. The storage system then returns filtered data to the database server. The database system thereby avoids the unnecessary transfer of certain data between the storage system and the database server.

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.

公开(公告)号：US09336275B2

公开(公告)日：2016-05-10

申请号：US14339412

申请日：2014-07-23

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Yiu Woon Lau ,  Hakan Jakobsson ,  Umesh Panchaksharaiah ,  Poojan Kumar

IPC: G06F17/30 ,  G06F3/06 ,  G06F12/00

CPC classification number: G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

Abstract: Processing resources at a storage system for a database server are utilized to perform aspects of a join operation that would conventionally be performed by the database server. When requesting a range of data units from a storage system, the database server includes join metadata describing aspects of the join operation for which the data is being requested. The join metadata may be, for instance, a bloom filter. The storage system reads the requested data from disk as normal. However, prior to sending the requested data back to the storage system, the storage system analyzes the raw data based on the join metadata, removing a certain amount of data that is guaranteed to be irrelevant to the join operation. The storage system then returns filtered data to the database server. The database system thereby avoids the unnecessary transfer of certain data between the storage system and the database server.

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.