Checksum mechanism for data replication in batches
AssigneeInternational Business Machines Corporation
InventorsShailesh Chandra Jamloki, Kiran K. Venkatachala
Life of this patent
Estimating the term…
Abstract
A method verifies data integrity in a data replication. Changes to data in a source database are received. The changes are for replication in a target database. A batch of data is created from the changes to the data. A target checksum is determined for the batch of data. Whether the data integrity is present for the batch of data is determined from a comparison of the target checksum with a source checksum for the batch of data. Data in the batch of data is replicated in which the data integrity is present.
Claims20
A method for verifying data integrity in a data replication, the method comprising:
- receiving changes to data in a source database, wherein the changes are for replication in a target database;
- creating a batch of data from the changes to the data, wherein the batch of data comprises changes to the data in records in the source database;
- determining a target checksum for the batch of data, wherein determining the target checksum comprises:
- determining a target record checksum for each record in the batch of data received for a target database to form target record checksums;
- aggregating the target record checksums to form the target checksum;
- and
- aggregating source record checksums determined for corresponding records in the source database to form the source checksum;
- determining whether the data integrity is present for the batch of data from a comparison of the target checksum with a source checksum for the batch of data;
- and
- replicating data in the batch of data in which the data integrity is present.
A computer system comprising:
- a processor set;
- a set of one or more computer-readable storage media;
- and
- program instructions, collectively stored in the set of one or more storage media to cause the processor set to perform operations comprising:
- receiving changes to data in a source database, wherein the changes are for replication in a target database;
- creating a batch of data from the changes to the data, wherein the batch of data comprises changes to the data in records in the source database;
- determining a target checksum for the batch of data, wherein determining the target checksum comprises:
- determining a target record checksum for each record in the batch of data received for a target database to form target record checksums;
- aggregating the target record checksums to form the target checksum;
- and
- aggregating source record checksums determined for corresponding records in the source database to form the source checksum;
- determining whether data integrity is present for the batch of data from a comparison of the target checksum with a source checksum for the batch of data;
- and
- replicating data in the batch of data in which the data integrity is present.
A computer program product for verifying data integrity in a data replication, the computer program product comprising:
- a set of one or more computer-readable storage media;
- program instructions stored on the set of one or more computer-readable storage media to perform operations comprising:
- receiving changes to data in a source database, wherein the changes are for replication in a target database;
- creating a batch of data from the changes to the data, wherein the batch of data comprises changes to the data in records in the source database;
- determining a target checksum for the batch of data, wherein determining the target checksum comprises:
- determining a target record checksum for each record in the batch of data received for a target database to form target record checksums;
- aggregating the target record checksums to form the target checksum;
- and
- aggregating source record checksums determined for corresponding records in the source database to form the source checksum;
- determining whether the data integrity is present for the batch of data from a comparison of the target checksum with a source checksum for the batch of data;
- and
- replicating data in the batch of data in which the data integrity is present.
Dependencies are inferred from the claim text.