Invention Grant
- Patent Title: Loading and reloading an in-memory copy of a database object without blocking concurrent updates to the database object
-
Application No.: US14983481Application Date: 2015-12-29
-
Publication No.: US10067974B2Publication Date: 2018-09-04
- Inventor: Vivekanandhan Raja , Atrayee Mullick , Sanket Hase , Sukhada Pendse , Amit Ganesh , Vineet Marwah , Neil MacNaughton
- 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 ; G06F3/06

Abstract:
Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.
Public/Granted literature
Information query