公开(公告)号：US20230140121A1

公开(公告)日：2023-05-04

申请号：US17705981

申请日：2022-03-28

申请人： Microsoft Technology Licensing, LLC

发明人： Rogério RAMOS ,  Kareem Aladdin GOLAUB ,  Chaitanya GOTTIPATI ,  Alejandro Hernandez SAENZ ,  Raj Kripal DANDAY

IPC分类号： G06F13/16

摘要： Methods for local page writes via pre-staging buffers for resilient buffer pool extensions are performed by computing systems. Compute nodes in database systems insert, update, and query data pages maintained in storage nodes. Data pages cached locally by compute node buffer pools are provided to buffer pool extensions on local disks as pre-copies via staging buffers that store data pages prior to local disk storage. Encryption of data pages occurs at the staging buffers, which allows a less restrictive update latching during the copy process, with page metadata being updated in buffer pool extensions page tables with in-progress states indicating it is not yet written to local disk. When stage buffers are filled, data pages are written to buffer pool extensions and metadata is updated in page tables to indicate available/valid states. Data pages in staging buffers can be read and updated prior to writing to the local disk.

公开(公告)号：US20240126706A1

公开(公告)日：2024-04-18

申请号：US18534126

申请日：2023-12-08

申请人： Microsoft Technology Licensing, LLC

发明人： Rogério RAMOS ,  Kareem Aladdin GOLAUB ,  Chaitanya GOTTIPATI ,  Alejandro Hernandez SAENZ ,  Raj Kripal DANDAY

IPC分类号： G06F13/16

CPC分类号： G06F13/1673

摘要： Methods for local page writes via pre-staging buffers for resilient buffer pool extensions are performed by computing systems. Compute nodes in database systems insert, update, and query data pages maintained in storage nodes. Data pages cached locally by compute node buffer pools are provided to buffer pool extensions on local disks as pre-copies via staging buffers that store data pages prior to local disk storage. Encryption of data pages occurs at the staging buffers, which allows a less restrictive update latching during the copy process, with page metadata being updated in buffer pool extensions page tables with in-progress states indicating it is not yet written to local disk. When stage buffers are filled, data pages are written to buffer pool extensions and metadata is updated in page tables to indicate available/valid states. Data pages in staging buffers can be read and updated prior to writing to the local disk.