Invention Grant
- Patent Title: Method for migrating data records from a source database to a target database
-
Application No.: US16131101Application Date: 2018-09-14
-
Publication No.: US10884998B2Publication Date: 2021-01-05
- Inventor: Artur M. Gruszecki , Tomasz Sekman , Tomasz Kazalski , Andrzej J. Wrobel
- 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
- Agent Reza Sarbakhsh
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/21 ; G06F17/14 ; G06F9/54

Abstract:
The present disclosure relates to a method using a database engine for migrating data records from a source database to a target database, where said data records are arranged in a sorted source table of the source database in accordance with a clustered-base-table order following the Hilbert-Filling-Curve algorithm. The method comprises configuring the database engine for storing the CBT order of each data record of the source table in a reference table to said source table or a in a column of said source table. A reading step may be performed to read said data records from said source table, wherein in said reading step said stored CBT order is used. The read data and the stored CBT order may be transferred to the target database in accordance with the stored CBT order. The transferred data may be written at the target database in accordance with the CBT order.
Public/Granted literature
- US20200089776A1 METHOD FOR MIGRATING DATA RECORDS FROM A SOURCE DATABASE TO A TARGET DATABASE Public/Granted day:2020-03-19
Information query