Data migration in a networked computer environment

Patent metadata

Field	Value
Publication number	US-10649965-B2
Application number	US-201615350435-A
Country	US
Kind code	B2
Filing date	Nov 14, 2016
Priority date	Nov 14, 2016
Publication date	May 12, 2020
Grant date	May 12, 2020

Abstract

Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.

First claim

What is claimed is:

1. A system comprising:
one or more memories configured to store a source database with data structures and a destination database; and
one or more processors configured to:
generate a plurality of representations for a data structure stored on the source database based on access patterns for the data structure on the source database, wherein each representation corresponds to a different structural format than a structural format of the data structure on the source database;
generate a plurality of dictionaries, wherein each of the plurality of dictionaries corresponds to a representation for the data structure from the plurality of representations, and wherein each of the plurality of dictionaries is used to convert the data structure to the different structural format of the representation for the data structure corresponding to each of the plurality of dictionaries;
in response to a request from a destination database system for a dictionary of a corresponding structural format for a target data structure of the destination database, transfer the data structure and the requested dictionary of the corresponding structural format from the source database to the destination database system; and
load the transferred data structure onto the destination database in the corresponding structural format for the target data structure in accordance with the transferred dictionary.

2. The system of claim 1 , wherein the one or more processors are further configured to:
analyze user database statements for the data structure to form the plurality of representations of the data structure; and
generate the plurality of dictionaries from the formed plurality of representations of the data structure.

3. The system of claim 2 , wherein the one or more processors are further configured to:
include in the plurality of dictionaries:
instructions for formatting the transferred data structure into the different structural formats of the representations for the data structure corresponding to the plurality of dictionaries; and
instructions for compressing the transferred data structure.

4. The system of claim 2 , wherein the one or more processors are further configured to:
update the plurality of dictionaries continually to specify compression operations based on user database statements for the source database as submitted over time.

5. The system of claim 1 , wherein the one or more processors are further configured to:
determine the corresponding structural format of the target data structure stored on the destination database; and
request, from the source database, a dictionary of the determined corresponding structural format of the target data structure stored on the destination database.

6. A computer program product for migrating data structures stored on a source database to a destination database, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions being executable by one or more processors to cause the one or more processors to:
generate a plurality of representations for a data structure stored on the source database based on access patterns for the data structure on the source database, wherein each representation corresponds to a different structural format than a structural format of the data structure on the source database;
generate a plurality of dictionaries, wherein each of the plurality of dictionaries corresponds to a representation for the data structure from the plurality of representations, and wherein each of the plurality of dictionaries is used to convert the data structure to the different structural format of the representation for the data structure corresponding to each of the plurality of dictionaries;
in response to a request from a destination database system for a dictionary of a corresponding structural format for a target data structure of the destination database, transfer the data structure and the requested dictionary of the corresponding structural format from the source database to the destination database system; and
load the transferred data structure onto the destination database in the corresponding structural format for the target data structure in accordance with the transferred dictionary.

7. The computer program product of claim 6 , wherein the program instructions include further instructions that cause the one or more processors to:
analyze user database statements for the data structure to form the plurality of representations of the data structure; and
generate the plurality of dictionaries from the formed plurality of representations of the data structure.

8. The computer program product of claim 7 , wherein the program instructions include further instructions that cause the one or more processors to:
include in the plurality of dictionaries:
instructions for formatting the transferred data structure into the different structural formats of the representations for the data structure corresponding to the plurality of dictionaries; and
instructions for compressing the transferred data structure.

9. The computer program product of claim 7 , wherein the program instructions include further instructions that cause the one or more processors to:
update the plurality of dictionaries continually to specify compression operations based on user database statements for the source database as submitted over time.

10. The computer program product of claim 6 , wherein the program instructions include further instructions that cause the one or more processors to:
determine the corresponding structural format of the target data structure stored on the destination database; and
request, from the source database, a dictionary of the determined corresponding structural format of the target data structure stored on the destination database.

Assignees

• IBM

Inventors

• Barbas Pedro M
• Emanowicz Konrad
• Jenkins Gareth
• Mccallig Enda
• Pan Lei

Classifications

• H04L67/10

  in which an application is distributed across nodes in the network (software deployment G06F8/60; multiprogramming arrangements G06F9/46) · CPC title

• G06F16/214 Primary

  Database migration support · CPC title