Invention Grant
- Patent Title: Predicate offload of large objects
-
Application No.: US13831137Application Date: 2013-03-14
-
Publication No.: US10409795B2Publication Date: 2019-09-10
- Inventor: Vineet Marwah , Amit Ganesh , Teck Hua Lee , Hui Joe Chang , Zhen Hua Liu
- 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: G06F16/22
- IPC: G06F16/22

Abstract:
In an approach, the database server generates a request for data representing rows of a table, the request identifying one or more data blocks stored on a storage system. The database server then generates metadata describing one or more filtering conditions to be applied to the rows and sends the metadata along with the request to the storage system. The storage system, when applying filtering conditions to a column containing a LOB, determines whether the LOB is stored in-line or out-of-line. If the column contains an out-of-line LOB, the storage system skips the filtering conditions on the column. If the column contains an in-line LOB, the storage system applies the filtering conditions to the column. Upon obtaining the filtered data from the storage system, the database server retrieves the data blocks for out-of-line LOBs and applies the skipped filtering conditions to create a final result set.
Public/Granted literature
- US20140280249A1 PREDICATE OFFLOAD OF LARGE OBJECTS Public/Granted day:2014-09-18
Information query