Delayed snapshot isolation for read service at a database

US10452636B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Kyu Hwan Kim · Anyang-si, KR
• Juchang Lee · Seoul, KR
• Beomsoo Kim · Seoul, KR
• Chang Gyoo Park · Gwanak-gu, KR
• Reiner Singer · Schriesheim, DE
• Christoph Rottering · Sinsheim, DE
• Werner Thesing · Herbstein, DE
• Michael Muehle · Walldorf, DE

Key dates

• Filing date: Nov 28, 2016
• Grant date: Oct 22, 2019
• Expiry date: Dec 29, 2037

Classification

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

Abstract

A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.