US 12,169,455 B2
Write-behind optimization of covering cache
Krystyna Ewa Reisteter, Kirkland, WA (US); Cristian Diaconu, Kirkland, WA (US); Rogério Ramos, Redmond, WA (US); Sarika R. Iyer, San Ramon, CA (US); Siddharth Deepak Mehta, Kirkland, WA (US); and Huanhui Hu, Redmond, WA (US)
Assigned to MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US)
Filed by Microsoft Technology Licensing, LLC, Redmond, WA (US)
Filed on May 3, 2023, as Appl. No. 18/311,699.
Application 18/311,699 is a continuation of application No. 17/359,087, filed on Jun. 25, 2021, granted, now 11,681,631.
Prior Publication US 2023/0297510 A1, Sep. 21, 2023
Int. Cl. G06F 12/08 (2016.01); G06F 3/06 (2006.01); G06F 12/02 (2006.01); G06F 12/0871 (2016.01); G06F 12/0882 (2016.01)
CPC G06F 12/0882 (2013.01) [G06F 3/0604 (2013.01); G06F 3/0656 (2013.01); G06F 3/0679 (2013.01); G06F 12/0246 (2013.01); G06F 12/0871 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
a processor; and
a memory device storing program code configured to be executed by the processor, the program code comprising a database service configured to:
cache, in a data cache, subsets of data of a data file;
create a data cache checkpoint by storing a current redo log sequence number (LSN) as a cache checkpoint LSN in the data cache based at least on successfully performing a data cache write by flushing dirty subsets of data from a buffer pool to the data cache; and
create a storage checkpoint by storing the cache checkpoint LSN in a file header of the data file and storing the cache checkpoint LSN as a storage checkpoint LSN in the data cache based at least on successfully performing a write-behind (WB) storage write by flushing data segments comprising the dirty subsets of data from the data cache to the data file.