公开(公告)号：US20180081767A1

公开(公告)日：2018-03-22

申请号：US15273273

申请日：2016-09-22

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Sanket Hase

IPC: G06F11/14 ,  G06F3/06 ,  G06F17/30

Abstract: Techniques are described for maintaining coherency of a portion of a database object mirrored in a particular node of a database. The techniques involve maintaining invalidation logs which identify transactions that have committed to a database. Based on the invalidation logs, the particular node generates invalid-row ID metadata which identifies, for each system change number, one or more rows that are not transactionally consistent with data stored in the database object as of said system change number.

公开(公告)号：US10437688B2

公开(公告)日：2019-10-08

申请号：US15273273

申请日：2016-09-22

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Sanket Hase

IPC: G06F17/30 ,  G06F11/14 ,  G06F3/06 ,  G06F16/23

Abstract: Techniques are described for maintaining coherency of a portion of a database object mirrored in a particular node of a database. The techniques involve maintaining invalidation logs which identify transactions that have committed to a database. Based on the invalidation logs, the particular node generates invalid-row ID metadata which identifies, for each system change number, one or more rows that are not transactionally consistent with data stored in the database object as of said system change number.

公开(公告)号：US10372699B2

公开(公告)日：2019-08-06

申请号：US15264978

申请日：2016-09-14

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Solmaz Kolahi ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Vasudha Krishnaswamy ,  Sanket Hase

IPC: G06F16/23

Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.

公开(公告)号：US20180075079A1

公开(公告)日：2018-03-15

申请号：US15264978

申请日：2016-09-14

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Solmaz Kolahi ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Vasudha Krishnaswamy ,  Sanket Hase

IPC: G06F17/30

CPC classification number: G06F16/2322 ,  G06F16/2365

Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.