US 12,443,489 B2
Offloading redo log processing to solid-state drives in database systems
Zhiwei Xiao, Xi'an (CN); and BianHong Zheng, Xi'an (CN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Feb. 23, 2024, as Appl. No. 18/585,452.
Prior Publication US 2025/0272197 A1, Aug. 28, 2025
Int. Cl. G06F 11/14 (2006.01)
CPC G06F 11/1456 (2013.01) [G06F 11/1471 (2013.01); G06F 2201/80 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for processing of redo logs in database systems, the method being executed by one or more processors and comprising:
receiving, by a solid-state drive (SSD) and from a host, a write command to write content to memory, the content comprising a redo log of a database system, the redo log comprising a set of redo entries, each redo entry recording one or more changes to data in the database system;
writing, by a redo log processor executed by at least one processor of the SSD, redo entries of the redo log to a redo log buffer, the redo log buffer comprising a first set of bidirectional links that each bidirectionally link redo entries of different pages and a second set of bidirectional links that each bidirectionally link redo entries of a same page, the redo log buffer comprising a page identifier (page ID) ordered array and a set of bidirectional linked tables, the redo entries being written to the bidirectional linked tables in the set of bidirectional linked tables; and
executing, by the redo log processor, one or more of creating a data page and updating a data page in memory of the SSD, the data page being stored in memory of the SSD.