Replay of redo log records in persistency or main memory of database systems

US11170023B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Colin Florendo · Marlborough, US
• Michael Muehle · Walldorf, DE
• Thorsten Glebe · Leimen, DE
• Rolando Blanco · Schreiber, CA
• Chaitanya Gottipati · Pune, IN
• Nirvik Basak · Pune, IN
• Martin Heidel · Walldorf, DE
• Peter Steinemann · Mannheim, DE
• Vivek Kandiyanallur · San Francisco, US
• Shiping Chen · Pleasanton, US
• Sarika Iyer · San Ramon, US
• Jörn Schmidt · Walldorf, DE

Key dates

• Filing date: Feb 28, 2017
• Grant date: Nov 9, 2021
• Expiry date: May 7, 2038

Classification

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

Abstract

A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.