Invention Grant
- Patent Title: LOB query performance via automatic inference of locator-less LOB by value semantics
-
Application No.: US15807336Application Date: 2017-11-08
-
Publication No.: US10942924B2Publication Date: 2021-03-09
- Inventor: Zhen Hua Liu , Geeta Arora , Hui Joe Chang
- 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: Vista IP Law Group, LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2455 ; G06F16/28 ; G06F16/22 ; G06F16/242

Abstract:
An approach for improving LOB query performance via automatic inference of locator-less LOB by value semantics in a relational database system is provided. A relational database management system (RDBMS) is implemented to perform operations on LOBs based on the semantics of a statement. During statement compilation, the RDBMS identifies inline LOB column(s) that are not required to be returned to a client. During execution, the identified column(s) are accessed via a shared buffer cache and fed to an operator for evaluation. For inline LOB column(s) that must be returned to the client, during execution, the inline LOB data is copied from the shared buffer cache to a temporary buffer area. Data in the temporary buffer area is fed to an operator for evaluation and is used to create a LOB locator for the inline LOB column(s) that must be returned to the client.
Public/Granted literature
- US20190102450A1 LOB QUERY PERFORMANCE VIA AUTOMATIC INFERENCE OF LOCATOR-LESS LOB BY VALUE SEMANTICS Public/Granted day:2019-04-04
Information query