Patent · US Active

Consistent query execution in hybrid DBMS

US10372726B2 · kind B2 · utility

2Cited by

4References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Andreas Brodt · Gerlingen, DE
Oliver Koeth · Stuttgart, DE
Daniel Martin · Stuttgart, DE
Knut Stolze · Jena, DE

Key dates

Filing date	Aug 9, 2016
Grant date	Aug 6, 2019
Priority date	—
Expiry date	Oct 4, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2455
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A method includes, where a first database engine maintains a first database, a second database engine maintains a second database, and a table has a first instance in the first database and a second instance in the second database, executing write transactions, asynchronously pooling the changes of the first instance, and, in response to receiving a query against the table, determining to execute the query against the second instance. The method further includes identifying a first time, defining a current replication batch that selectively comprises the pooled changes of the transactions before the first time, asynchronously replicating the current replication batch, storing each change, assigning a batch-ID to the query, sending the query and the batch-ID to the second engine, responsive to the current replication batch being completed, executing the query on the second instance, and returning results of the query execution on the second instance.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.