Invention Grant
- Patent Title: Versatile in-memory database recovery using logical log records
-
Application No.: US12914753Application Date: 2010-10-28
-
Publication No.: US10430298B2Publication Date: 2019-10-01
- Inventor: Mike Zwilling , Per-Ake Larson , Cristian Diaconu
- Applicant: Mike Zwilling , Per-Ake Larson , Cristian Diaconu
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Wade IP Law LLC
- Main IPC: G06F16/20
- IPC: G06F16/20 ; G06F11/14 ; G06F16/23

Abstract:
The subject disclosure relates to a database recovery technique that implements various aspects of transaction logging to optimize database recovery performance. Transactions are logged logically with no reference to physical location, which enables logging to be performed via multiple independent log streams in parallel. A set of log streams can further be adjusted to conform to a local configuration of a mirror or secondary node in order to increase mirroring flexibility. Additionally, individual transactions or groups of transactions are recorded using a single log record, which contains timestamp information to enable database recovery without reference to physical checkpoint files. Further, techniques are provided herein for processing transactions without Write Ahead Logging or hardening of undo information. As further described herein, a transaction can be committed via a set of hierarchical stages, which in turn can facilitate integration of an in-memory database system with one or more external database systems.
Public/Granted literature
- US20120109895A1 VERSATILE IN-MEMORY DATABASE RECOVERY Public/Granted day:2012-05-03
Information query