# US 2015/0149704 A1 · Transaction Private Log Buffering for High Performance of Transaction Processing

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2015/0149704 A1
- Document ID: US20150149704A1
- Status: Published application
- Kind: A1
- Application number: 14/244,686
- Filed: 2014-04-03
- Published: 2015-05-28
- Earliest claimed: 2013-11-26
- Assignees: Sap SE
- Inventors: Juchang Lee; Beomsoo Kim; Kyu Hwan Kim; Jaeyun Noh; Sang Kyun Cha
- Web page: https://patentgrep.com/patent/US20150149704A1

## CPC

- G06F 16/2358: {Change logging, detection, and notification (replication G06F16/27)}
- G06F 9/466: {Transaction processing}
- G06F 12/08: in hierarchically structured memory systems, e.g. virtual memory systems
- G06F 2206/1014: One time programmable [OTP] memory, e.g. PROM, WORM
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

For each data change occurring transaction created as part of a write operation initiated for one or more tables in a main-memory-based DBMS, a transaction log entry can be written to a private log buffer corresponding to the transaction. All transaction log entries in the private log buffer can be flushed to a global log buffer upon completion of the transaction to which the private log buffer corresponds.

## Claims

### Claim 1

A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
creating one or more transactions as part of a write operation initiated for one or more tables in a main-memory-based database management system;
writing, for each data change occurring during a transaction of the one or more transactions, a transaction log entry to a private log buffer, the private log buffer corresponding to the transaction; and
flushing all transaction log entries in the private log buffer to a global log buffer upon completion of the transaction to which the private log buffer corresponds.

### Claim 2 (depends on 1)

A computer program product as in claim 1, wherein the operations further comprise flushing all entries in the global log buffer to a non-volatile storage during a commit operation comprising commitment of changes relating to the write operation.

### Claim 3 (depends on 2)

A computer program product as in claim 2, wherein the flushing during the commit operation comprises fewer input/output operations to the non-volatile storage for transaction logging than writing the transaction log entries directly to the non-volatile storage.

### Claim 4 (depends on 1)

A computer program product as in claim 1, wherein the operations further comprise receiving a data manipulation workload from a client machine, the data manipulation workload relating to the write operation.

### Claim 5 (depends on 4)

A computer program product as in claim 4, wherein the data manipulation workload comprises statements in a data manipulation language.

### Claim 6 (depends on 1)

A computer program product as in claim 1, wherein the transaction log entry comprises a redo log entry, and the redo log entry is applied when the redo log entry has a higher savepoint count than a savepoint count of a data page affected by the transaction.

### Claim 7

A system comprising:
computer hardware configured to perform operations comprising:
creating one or more transactions as part of a write operation initiated for one or more tables in a main-memory-based database management system;
writing, for each data change occurring during a transaction of the one or more transactions, a transaction log entry to a private log buffer, the private log buffer corresponding to the transaction; and
flushing all transaction log entries in the private log buffer to a global log buffer upon completion of the transaction to which the private log buffer corresponds.

### Claim 8 (depends on 7)

A system as in claim 7, wherein the operations further comprise flushing all entries in the global log buffer to a non-volatile storage during a commit operation comprising commitment of changes relating to the write operation.

### Claim 9 (depends on 8)

A system as in claim 8, wherein the flushing during the commit operation comprises fewer input/output operations to the non-volatile storage for transaction logging than writing the transaction log entries directly to the non-volatile storage.

### Claim 10 (depends on 7)

A system as in claim 7, wherein the operations further comprise receiving a data manipulation workload from a client machine, the data manipulation workload relating to the write operation.

### Claim 11 (depends on 10)

A system as in claim 10, wherein the data manipulation workload comprises statements in a data manipulation language.

### Claim 12 (depends on 7)

A system as in claim 7, wherein the transaction log entry comprises a redo log entry, and the redo log entry is applied when the redo log entry has a higher savepoint count than a savepoint count of a data page affected by the transaction.

### Claim 13 (depends on 7)

A system as in claim 7, wherein the computer hardware comprises a programmable processor, and a machine-readable medium storing instructions that, when executed by the programmable processor, cause the at least one programmable processor to perform at least some of the operations.

### Claim 14

A computer-implemented method comprising:
creating one or more transactions as part of a write operation initiated for one or more tables in a main-memory-based database management system;
writing, for each data change occurring during a transaction of the one or more transactions, a transaction log entry to a private log buffer, the private log buffer corresponding to the transaction; and
flushing all transaction log entries in the private log buffer to a global log buffer upon completion of the transaction to which the private log buffer corresponds.

### Claim 15 (depends on 14)

A computer-implemented method as in claim 14, further comprising flushing all entries in the global log buffer to a non-volatile storage during a commit operation comprising commitment of changes relating to the write operation.

### Claim 16 (depends on 15)

A computer-implemented method as in claim 15, wherein the flushing during the commit operation comprises fewer input/output operations to the non-volatile storage for transaction logging than writing the transaction log entries directly to the non-volatile storage.

### Claim 17 (depends on 14)

A computer-implemented method as in claim 14, further comprising receiving a data manipulation workload from a client machine, the data manipulation workload relating to the write operation.

### Claim 18 (depends on 17)

A computer-implemented method as in claim 17, wherein the data manipulation workload comprises statements in a data manipulation language.

### Claim 19 (depends on 14)

A computer-implemented method as in claim 14, wherein the transaction log entry comprises a redo log entry, and the redo log entry is applied when the redo log entry has a higher savepoint count than a savepoint count of a data page affected by the transaction.

### Claim 20 (depends on 14)

A computer-implemented method as in claim 14, wherein the creating, the writing, and the flushing comprise operations performed by computer hardware.
