Invention Grant
- Patent Title: Methods and apparatus of shared expression evaluation across RDBMS and storage layer
-
Application No.: US15716345Application Date: 2017-09-26
-
Publication No.: US10606834B2Publication Date: 2020-03-31
- Inventor: Thierry Cruanes , Junyi Xie , Yiu Woon Lau
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- 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.
Public/Granted literature
- US20180144029A1 Methods And Apparatus Of Shared Expression Evaluation Across RDBMS And Storage Layer Public/Granted day:2018-05-24
Information query