Patent · US Active

Copying data changes to a target database

US10671642B2 · kind B2 · utility

6Cited by

8References

20Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Andreas Brodt · Gerlingen, DE
Bjoern Broll · Waldenbuch, DE
Daniel Martin · Stuttgart, DE
Jens Mueller · Stuttgart, DE

Key dates

Filing date	Nov 11, 2016
Grant date	Jun 2, 2020
Priority date	—
Expiry date	Feb 3, 2038

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2358
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A method, system and computer program product for copying data from a source database to a target database. A first database engine of the source database assigns a data-change-ID to each changed row in the source table. The data rows of the source table are stored in a plurality of source pages. Each source page comprises a source-page-ID and a highest-data-change-ID indicating its most recently changed data row. The target table comprises a source-page-ID-column. A second database engine of the target database maintains a metadata table comprising a source-page-ID column and a highest-data-change-ID column. The highest-data-change-IDs in the metadata table are compared with the highest-data-change-IDs of the source pages for selectively copying source table rows of source pages whose highest-data-change-ID is higher than their highest-data-change-ID in the metadata table to the target table.

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