公开(公告)号：US11487740B2

公开(公告)日：2022-11-01

申请号：US17024552

申请日：2020-09-17

Applicant: SYBASE, INC.

Inventor： Fei Zhou ,  Sarika Iyer ,  Graham Ivey

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/24

Abstract: A system for managing database logging, the comprises a processor; and a user task executing in a database server process and executable by the processor, the user task to: receive in a database management system on a database server, a command to manipulate a portion of a database managed by the database management system; obtain a lock on the portion of the database; create a first log record in a first private log cache associated with the user task, the first log record recording a data manipulation to the portion of the database; enqueue the first log record to a queue; and release the lock on the portion of the database after copying the first log record to the queue.

公开(公告)号：US20210004364A1

公开(公告)日：2021-01-07

申请号：US17024552

申请日：2020-09-17

Applicant: SYBASE, INC.

Inventor： Fei Zhou ,  Sarika Iyer ,  Graham Ivey

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/2455

Abstract: A system for managing database logging, the comprises a processor; and a user task executing in a database server process and executable by the processor, the user task to: receive in a database management system on a database server, a command to manipulate a portion of a database managed by the database management system; obtain a lock on the portion of the database; create a first log record in a first private log cache associated with the user task, the first log record recording a data manipulation to the portion of the database; enqueue the first log record to a queue; and release the lock on the portion of the database after copying the first log record to the queue.

公开(公告)号：US10114848B2

公开(公告)日：2018-10-30

申请号：US15233575

申请日：2016-08-10

Applicant: SYBASE, INC.

Inventor： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

IPC: G06F11/00 ,  G06F17/30 ,  G06F11/14 ,  G06F11/16 ,  G06F11/20

Abstract: Disclosed in some examples is a method, the method including detecting that an RDMS is recovering from a failure; sending a request for a last committed transaction on a replication component to the replication component; receiving, from the replication component, the last committed transaction which identifies a transaction that was the last committed transaction at a replication component at a time of RDMS failure; determining that a transaction log on the RDMS includes a transaction that had not yet been replicated at the time of RDMS failure which was committed on the transaction log subsequent to the last committed transaction received from the replication component; and based on that determination rolling back the transaction that had not yet been replicated at the time of RDMS failure.

公开(公告)号：US20160350350A1

公开(公告)日：2016-12-01

申请号：US15233575

申请日：2016-08-10

Applicant: SYBASE, INC.

Inventor： Heping Shang ,  Ming-Chen Lo ,  Fei Zhou ,  Tom Campbell ,  Frank de Lange ,  Guo Gang Ye ,  Xia-ge Dai

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30351 ,  G06F11/1448 ,  G06F11/1474 ,  G06F11/1658 ,  G06F11/2094 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30595 ,  G06F2201/80 ,  G06F2201/805 ,  G06F2201/82

Abstract: Disclosed in some examples is a method, the method including detecting that an RDMS is recovering from a failure; sending a request for a last committed transaction on a replication component to the replication component; receiving, from the replication component, the last committed transaction which identifies a transaction that was the last committed transaction at a replication component at a time of RDMS failure; determining that a transaction log on the RDMS includes a transaction that had not yet been replicated at the time of RDMS failure which was committed on the transaction log subsequent to the last committed transaction received from the replication component; and based on that determination rolling back the transaction that had not yet been replicated at the time of RDMS failure.