Invention Grant
- Patent Title: Query execution against an in-memory standby database
-
Application No.: US15253780Application Date: 2016-08-31
-
Publication No.: US11657037B2Publication Date: 2023-05-23
- Inventor: Vasudha Krishnaswamy , Yunrui Li , Vivekanandhan Raja , Tirthankar Lahiri , Mahesh B. Girkar , Sukhada Pendse , Kartik Kulkarni , Jing Zheng , Shruti Gautam , Henry Chau
- 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 Becker Bingham Ledesma LLP
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/25 ; G06F16/27

Abstract:
Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.
Public/Granted literature
- US20170116252A1 QUERY EXECUTION AGAINST AN IN-MEMORY STANDBY DATABASE Public/Granted day:2017-04-27
Information query