Patent · US Active

Copying data changes to a target database

US11429641B2 · kind B2 · utility

0Cited by

11References

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	Sep 30, 2019
Grant date	Aug 30, 2022
Priority date	—
Expiry date	Jun 30, 2040

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.