Database log performance

Patent metadata

Field	Value
Publication number	US-12373420-B2
Application number	US-202218053033-A
Country	US
Kind code	B2
Filing date	Nov 7, 2022
Priority date	Jun 16, 2021
Publication date	Jul 29, 2025
Grant date	Jul 29, 2025

Abstract

A computer-implemented method improves the performance of write ahead logging. The method includes generating a set of query data and a set of log data, where the set of log data is configured to create a write ahead log, and the set of query data is configured to make changes to data in a database. The method also includes writing the set of query data to a virtual file system. The method further includes separating the set of log data into a set of control intervals, where each control interval includes an entry. The method includes writing, each entry into a log buffer, where the writing the set of query data to the virtual file system and the writing each entry into the log buffer are performed in parallel. The method also includes combining each entry into a complete log.

First claim

What is claimed is:

1. A computer-implemented method comprising:
generating a set of log data for a query, wherein the generating is configured to create a write ahead log for the query prior to the query making changes in a database, the query is configured to make changes to data in the database, and the creating the write ahead log further comprises:
writing a set of query data for the query into a virtual file system in parallel with the writing the set of log data in a log buffer;
separating the set of log data into a set of control intervals, wherein each control interval includes an entry for an address and an action of the query and each control interval is associated with a corresponding portion of the log buffer;
writing, in response to the separating, the set of log data into the log buffer, wherein the log buffer includes a first log buffer and a second log buffer and the writing into the first log buffer and the second log buffer occurs in parallel; and
combining, in response to the writing, the set of log data from the first log buffer and the second log buffer into a complete log.

2. The computer-implemented method of claim 1 , wherein the first log buffer includes a first log, and the second log buffer includes a second log.

3. The computer-implemented method of claim 2 , wherein each entry in the first log buffer is transferred into the first log, and each entry in the second log buffer is transferred into the second log.

4. The computer-implemented method of claim 2 , wherein each entry includes a sequence marker, wherein the sequence marker indicates a relative order of operations of the query that are performed.

5. The computer-implemented method of claim 4 , wherein the combining of each entry into the complete log further comprises re-sequencing, based on the sequence marker for each entry, all entries into the relative order of operations of the query.

6. The computer-implemented method of claim 5 , further comprising:
storing the complete log on a disk; and
updating, in response to storing the complete log on the disk, data in the database based on the query data.

7. The computer-implemented method of claim 2 , wherein each entry includes a parent object identifier.

8. The computer-implemented method of claim 1 , wherein the writing of the log data into the log buffer is configured to reduce a number of copies of the log data.

9. The computer-implemented method of claim 1 , wherein each entry uses a parent object identifier to identify an associated database object.

10. The method of claim 1 , further comprising:
updating the database, wherein the update occurs after the writing the set of log data into the log buffer and before the combining the set of log data into the complete log.

11. A system comprising:
a processor;
a database;
a write ahead log that includes two or more log buffers and the write ahead log is configured to write entries into the two or more log buffers in parallel; and
a computer-readable storage medium communicatively coupled to the processor and storing program instructions which, when executed by the processor, are configured to cause the processor to:
generate a set of log data from a query, wherein the query is configured to make updates to data in a database, wherein the generating is configured to create the write ahead log prior to the query applying the updates to the database, and wherein the program instructions for creating the write ahead log further comprise program instructions to:
write a set of query data for the query into a virtual file system in parallel with the writing the set of log data into the two or more log buffers;
separate the set of log data into a set of control intervals, wherein each control interval includes an entry for an address and an action of the query and each control interval is associated with a corresponding portion of a log buffer;
write, in response to the separating, the set of log data into the log buffer, wherein the writing into the two or more log buffers occurs in parallel; and
combine, in response to the writing the set of log data from a first log buffer and a second log buffer into the log buffer, the set of log data into a complete log.

12. The system of claim 11 , wherein the first log buffer includes a first log where each entry in the first log buffer is transferred into the first log, and the second log buffer includes a second log where each entry in the second log buffer is transferred into the second log.

13. The system of claim 12 , wherein each entry includes a sequence marker, wherein the sequence marker indicates a relative order of operations of the query are performed.

14. The system of claim 13 , wherein the combining of each entry into the complete log further comprises re-sequencing into the relative order of operations of the query based on the sequence marker for each entry.

15. A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processing unit to cause the processing unit to:
generate a set of log data for a query, wherein the set of log data is configured to create a write ahead log, and the query is configured to make changes to data in a database;
separate the set of log data into a set of control intervals, wherein each control interval includes an entry for an address and an action of the query and each control interval is associated with a corresponding portion of a log buffer;
write the set of log data into the log buffer, wherein the log buffer includes a first log buffer and a second log buffer and the writing into the first log buffer and the second log buffer occurs in parallel and writing a set of query data for the query into a virtual file system occurs in parallel with the writing the set of log data into the log buffer; and
combine, in response to the writing the set of log data from the first log buffer and the second log buffer into the log buffer, the set of log data into a complete log.

16. The computer program product of claim 15 , wherein the first log buffer includes a first log where each entry in the first log buffer is transferred into the first log, and the second log buffer includes a second log where each entry in the second log buffer is transferred into the second log.

17. The computer program product of claim 16 , wherein each entry includes a sequence marker, wherein the sequence marker indicates a relative order of operations of the query are performed.

18. The computer program product of claim 17 , wherein the combining of each entry into the complete log further comprises re-sequencing into the relative order of operations of the query based on the sequence marker for each entry.

Assignees

• IBM

Inventors

• Zhang Hong Mei
• Li Shuo
• Wang Xiaobo
• Sun sheng yan

Classifications

• G06F16/188

  Virtual file systems · CPC title

• G06F16/148

  File search processing · CPC title

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title

• G06F16/2358 Primary

  Change logging, detection, and notification (replication G06F16/27) · CPC title