知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

5 records (took 0.019 seconds)

    Write-behind optimization of covering cache
    3.
    发明授权
    Write-behind optimization of covering cache 有权

    公开(公告)号：US12169455B2

    公开(公告)日：2024-12-17

    申请号：US18311699

    申请日：2023-05-03

    Applicant: Microsoft Technology Licensing, LLC

    Inventor： Krystyna Ewa Reisteter ,  Cristian Diaconu ,  Rogério Ramos ,  Sarika R. Iyer ,  Siddharth Deepak Mehta ,  Huanhui Hu

    IPC: G06F12/08 ,  G06F3/06 ,  G06F12/02 ,  G06F12/0871 ,  G06F12/0882

    Abstract: Data base performance is improved using write-behind optimization of covering cache. Non-volatile memory data cache includes a full copy of stored data file(s). Data cache and storage writes, checkpoints, and recovery may be decoupled (e.g., with separate writes, checkpoints and recoveries). A covering data cache supports improved performance by supporting database operation during storage delays or outages and/or by supporting reduced I/O operations using aggregate writes of contiguous data pages (e.g., clean and dirty pages) to stored data file(s). Aggregate writes reduce data file fragmentation and reduce the cost of snapshots. Performing write-behind operations in a background process with optimistic concurrency control may support improved database performance, for example, by not interfering with write operations to data cache. Data cache may store (e.g., in metadata) data cache checkpoint information and storage checkpoint information. A stored data file may store storage checkpoint information (e.g., in a file header).

    Local page writes via pre-staging buffers for resilient buffer pool extensions
    4.
    发明授权
    Local page writes via pre-staging buffers for resilient buffer pool extensions 有权

    公开(公告)号：US11880318B2

    公开(公告)日：2024-01-23

    申请号：US17705981

    申请日：2022-03-28

    Applicant: Microsoft Technology Licensing, LLC

    Inventor： Rogério Ramos ,  Kareem Aladdin Golaub ,  Chaitanya Gottipati ,  Alejandro Hernandez Saenz ,  Raj Kripal Danday

    IPC: G06F13/16

    CPC classification number: G06F13/1673

    Abstract: 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.

Patent Agency Ranking