Invention Grant
- Patent Title: Efficient data retrieval in staged use of in-memory cursor duration temporary tables
-
Application No.: US15268522Application Date: 2016-09-16
-
Publication No.: US10783142B2Publication Date: 2020-09-22
- Inventor: Janaki Latha Lahorani , Mohamed Ziauddin , You Jung Kim
- 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/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/2455

Abstract:
Techniques are presented herein for storing cursor duration temporary tables in memory of nodes in a clustered database system in association with iterations of an iterative query operation. The techniques involve associating a portion of memory with one or more iteration values. The iteration values indicate which iterations correspond to data that is stored in the portion of memory. When data is requested for a particular iteration, portions of memory are checked to determine if it stores the particular iteration.
Public/Granted literature
- US20170116272A1 EFFICIENT DATA RETRIEVAL IN STAGED USE OF IN-MEMORY CURSOR DURATION TEMPORARY TABLES Public/Granted day:2017-04-27
Information query