International Business Machines Corporation

Dzmitry Lepniakou

Dirk Alexander Seelemann, Ii

Michael Jory

Mohammad Wasif Khan

An embodiment generates, responsive to receiving a declarative replication specification, a logical map comprising a plurality of paths to completing a data replication process identified by the replication specification. The embodiment determines, responsive to generating the logical map, an optimal path to completing the data replication process by searching the plurality of paths of the logical map using a cost-directed search algorithm to find the optimal path from among the plurality of paths. The embodiment also performs, responsive to finding the optimal path, a series of data replication operations for replicating source data on a target database. The embodiment also detects, during a runtime of the data replication process, a predetermined change to a runtime environment of the data replication process. The embodiment also determines, responsive to detecting the predetermined change, a revised optimal path for performing the data replication process in the changed runtime environment.

Declarative configuration for database replication

An embodiment includes extracting, after a first specified time interval, recovery data from a recovery log for a data table corresponding to a set of database operations on the data table that occurred during the first specified time interval. The embodiment also generates index data for a progress record associated with the first time interval. The progress record includes a first data field for storing data representative of a first net change to the data table resulting from a first subset of the set of database operations. The first subset of database operations are associated with a first transaction. The embodiment also detects a commit operation in the first subset of database operations that committed the first transaction. The embodiment also recovers the first transaction in a target data table using the recovery log and the first net change data associated with the first transaction in the progress record.

Growing community of inventors

Toronto, Canada

Dzmitry Lepniakou