US 12,067,003 B2
Performance enhancement for writing database pages
Padmaja Dhairyasheel Thorat, Pune (IN); Amit Pathak, Pune (IN); and Mukundakrishnan Parthasarathy, Mumbai (IN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Nov. 28, 2022, as Appl. No. 17/994,583.
Prior Publication US 2024/0176772 A1, May 30, 2024
Int. Cl. G06F 16/23 (2019.01); G06F 9/52 (2006.01); G06F 16/22 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 9/526 (2013.01); G06F 16/2228 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A computer-implemented method, the method comprising:
receiving a request to update a timestamp associated with database pages of a database instance, the database pages logically organized into at least one page set, each of the at least one page set including a plurality of the database pages;
updating, for each of the at least one page set, the timestamp associated with each database page in each respective at least one page set;
issuing, in response to updating the timestamp associated with a last database page in each of the at least one page set, a write request to write the plurality of database pages in each of the respective at least one page set to a persistent data store;
setting, in response to issuing the write request for each of the respective at least one page set, a writing flag for each of the respective at least one page set to indicate an executing of the writing of the plurality of database pages;
writing the plurality of database pages in each of the respective at least one page set to a persistent data store, the plurality of database pages written to the persistent data store having an updated timestamp associated therewith; and
setting, in response to a completion of the executing of the writing of the plurality of database pages, the writing flag for each of the respective at least one page set to indicate a non-executing of the writing of the plurality of database pages.