Invention Grant
- Patent Title: Copying data changes to a target database
-
Application No.: US15349496Application Date: 2016-11-11
-
Publication No.: US10671642B2Publication Date: 2020-06-02
- Inventor: Andreas Brodt , Bjoern Broll , Daniel Martin , Jens P. Mueller
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Winstead PC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F16/27 ; G06F16/21 ; G06F16/22 ; G06F16/23

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.
Public/Granted literature
- US20180137186A1 COPYING DATA CHANGES TO A TARGET DATABASE Public/Granted day:2018-05-17
Information query