Patent · US Active

Consistent query execution in hybrid DBMS

US11138227B2 · kind B2 · utility

1Cited by

4References

20Claims

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	Jun 12, 2019
Grant date	Oct 5, 2021
Priority date	—
Expiry date	Dec 9, 2039

Classification

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

Abstract

A computer-implemented method for computer query processing and/or data-table management in a computer system. The method includes generating a table that exists as a first instance in a first database and as a second instance in a second database. The method includes generating a current replication batch of pooled changes of the first instance that committed at or before a first time. The method includes propagating changes specified in the current replication batch to the second instance. The method includes assigning a batch-ID of the current replication batch to the query. The method includes executing the query on the second instance using the batch-ID as a filter to exclude any changes that have an assigned batch-ID of a replication batch having committed later than the current replication batch. The method includes returning results of the query execution on the second instance.

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