The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 06, 2019
Filed:
Aug. 09, 2016
International Business Machines Corporation, Armonk, NY (US);
Andreas Brodt, Gerlingen, DE;
Oliver Koeth, Stuttgart, DE;
Daniel Martin, Stuttgart, DE;
Knut Stolze, Hummelshain, DE;
International Business Machines Corporation, Armonk, NY (US);
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.