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.

Date of Patent:
Jan. 14, 2020

Filed:

Sep. 30, 2016
Applicant:

International Business Machines Corporation, Armonk, NY (US);

Inventors:

Pravin K. Kedia, Mumbai, IN;

Nirmal Kumar, Bangalore, IN;

James D. Spyker, Toronto, CA;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 7/00 (2006.01); G06F 17/30 (2006.01); G06F 11/14 (2006.01); G06F 21/60 (2013.01); G06F 16/27 (2019.01); G06F 16/23 (2019.01);
U.S. Cl.
CPC ...
G06F 11/1474 (2013.01); G06F 11/1458 (2013.01); G06F 16/2379 (2019.01); G06F 16/27 (2019.01); G06F 16/273 (2019.01); G06F 21/604 (2013.01); G06F 2201/80 (2013.01);
Abstract

A method for handling of open transactions in a data replication environment. The method includes querying one or more tables of a source database to determine a first open transaction associated with the one or more tables of the source database. The method further includes determining a database user that initiated the first open transaction. The method further includes querying one or more tables of the target database corresponding to the one or more tables of the source database associated with the first open transaction, to determine whether the database user has access privileges for the one or more tables of the target database and dynamically skipping replication of the first open transaction to the target database, such that the data replication system no longer waits for the first open transaction to complete.


Find Patent Forward Citations

Loading…