Hybrid SCM-DRAM transactional storage engine for fast data recovery

US10162716B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Daniel Booss · Angelbachtal, DE
• Peter Bumbulis · Kitchener, CA
• Wolfgang Lehner · Dresden, DE
• Ismail Oukid · Berlin, DE
• Thomas Willhalm · Sandhausen, DE

Key dates

• Filing date: Nov 26, 2014
• Grant date: Dec 25, 2018
• Expiry date: Jan 29, 2037

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F2201/87
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A data recovery system and method are disclosed. Primary data is stored a database in byte-addressable NVRAM, where the database includes one or more persistent tables of data in a byte-addressable, RAM format, and a persistent memory allocator that maps persistent memory pointers of the persistent memory to virtual memory pointers of a virtual memory associated with the database. Secondary data is stored in volatile DRAM. A failure recovery includes recovering the persistent memory allocator, mapping the persistent memory to the virtual memory to recover primary data using their persistent memory pointers, translating the persistent memory pointers to virtual memory pointers, undoing changes to the primary data made by unfinished transactions of the query execution at the time of failure of one of the one or more queries, and reconstructing the secondary data from the primary data.