Method for migrating data records from a source database to a target database

A computer program product for using a database engine for migrating data records from a source database to a target database, wherein said data records are arranged in a sorted source table of the source database in accordance with a clustered-base-table order (“CBT order”) following the Hilbert-Filling-Curve algorithm, the computer program product comprising:

• one or more computer-readable storage devices and program instructions stored on at least one of the one or more computer-readable storage devices for execution by at least one or more computer processors of a computer system, the program instructions, when executed by the at least one of the one or more computer processors, causing the computer system to perform a method comprising:
• 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;
• performing a reading step to read said data records from said source table, wherein in said reading step said stored CBT order is used;
• transferring the read data records and the stored CBT order to the target database in accordance with the stored CBT order;
• and
• writing at the target database the transferred data to said target table in accordance with the CBT order using the stored CBT order.

A computer system for using a database engine for migrating data records from a source database to a target database, wherein said data records are arranged in a sorted source table of the source database in accordance with a clustered-base-table order (“CBT order”) following the Hilbert-Filling-Curve algorithm, the computer system comprising:

• one or more computer processors, one or more computer-readable storage media, and program instructions stored on one or more of the computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions, when executed by the at least one of the one or more computer processors, causing the computer system to perform a method comprising:
• 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;
• performing a reading step to read said data records from said source table, wherein in said reading step said stored CBT order is used;
• transferring the read data records and the stored CBT order to the target database in accordance with the stored CBT order;
• and
• writing at the target database the transferred data to said target table in accordance with the CBT order using the stored CBT order.