公开(公告)号：US11657037B2

公开(公告)日：2023-05-23

申请号：US15253780

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Vasudha Krishnaswamy ,  Yunrui Li ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Mahesh B. Girkar ,  Sukhada Pendse ,  Kartik Kulkarni ,  Jing Zheng ,  Shruti Gautam ,  Henry Chau

IPC: G06F16/23 ,  G06F16/25 ,  G06F16/27

CPC classification number: G06F16/2379 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/258 ,  G06F16/27 ,  G06F16/275

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.

公开(公告)号：US20170116252A1

公开(公告)日：2017-04-27

申请号：US15253780

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Vasudha Krishnaswamy ,  Yunrui Li ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Mahesh B. Girkar ,  Sukhada Pendse ,  Kartik Kulkarni ,  Jing Zheng ,  Shruti Gautam ,  Henry Chau

IPC: G06F17/30

CPC classification number: G06F16/2379 ,  G06F16/275

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.