Invention Grant
- Patent Title: Main-memory database checkpointing
- Patent Title (中): 主内存数据库检查点
-
Application No.: US13719248Application Date: 2012-12-19
-
Publication No.: US09304998B2Publication Date: 2016-04-05
- Inventor: Cristian C. Diaconu , Ryan L. Stonecipher , Michael James Zwilling , Marcel Van Der Holst
- Applicant: Microsoft Corporation
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agent Nicholas Chen; Kate Drakos; Micky Minhas
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present invention extends to methods, systems, and computer program products for main-memory database checkpointing. Embodiments of the invention use a transaction log as an interface between online threads and a checkpoint subsystem. Using the transaction log as an interface reduces synchronization overhead between threads and the checkpoint subsystem. Transactions can be assigned to files and storage space can be reserved in a lock free manner to reduce overhead of checkpointing online transactions. Meta-data independent data files and delta files can be collapsed and merged to reduce storage overhead. Checkpoints can be updated incrementally such that changes made since the last checkpoint (and not all data) are flushed to disk. Checkpoint I/O is sequential, helping ensure higher performance of physical I/O layers. During recovery checkpoint files can be loaded into memory in parallel for multiple devices.
Public/Granted literature
- US20140172803A1 MAIN-MEMORY DATABASE CHECKPOINTING Public/Granted day:2014-06-19
Information query