Sap Se

Royalty Pharma Collection Trust

Jörn Schmidt

Hans-Ulrich Demuth

Colin Florendo

Michael Muehle

Martin Heidel

Rolando Blanco

Chaitanya Gottipati

Peter Steinemann

Vivek Kandiyanallur

Sarika Iyer

Thorsten Glebe

Shiping Chen

Carsten Thiel

Nirvik Basak

Stephan Kottler

Fred Rosche

Ray A Pederson

Robert P Dr Walter Mckenzie Centre Pauly

Christopher HS Mcintosh

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.

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

Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

Caching DML statement context during asynchronous database system replication

Growing community of inventors

Walldorf, Germany

Jörn Schmidt