Patent · US Active

ACL based open transactions in replication environment

US10198328B2 · kind B2 · utility

1Cited by

4References

1Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Pravin K. Kedia · Mumbai, IN
Nirmal Kumar · Bengaluru, IN
James D. Spyker · Schreiber, CA

Key dates

Filing date	Dec 20, 2017
Grant date	Feb 5, 2019
Priority date	—
Expiry date	Dec 20, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F2201/80
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

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