Data migration in a networked computer environment

Patent metadata

Field	Value
Publication number	US-10783124-B2
Application number	US-201715833339-A
Country	US
Kind code	B2
Filing date	Dec 6, 2017
Priority date	Nov 14, 2016
Publication date	Sep 22, 2020
Grant date	Sep 22, 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 method for migrating data structures stored on a source database to a destination database, the method comprising:
generating, via one or more processors, 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;
generating, via the one or more processors, 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, transferring, via the one or more processors, the data structure and the requested dictionary of the corresponding structural format from the source database to the destination database system; and
loading, via the one or more processors, 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 method of claim 1 , further comprising:
analyzing, via the one or more processors, user database statements for the data structure to form the plurality of representations of the data structure; and
generating, via the one or more processors, the plurality of dictionaries from the formed plurality of representations of the data structure.

3. The method of claim 2 , further comprising:
including in the plurality of dictionaries via the one or more processors:
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 method of claim 2 , further comprising:
updating, via the one or more processors, the plurality of dictionaries continually to specify compression operations based on user database statements for the source database as submitted over time.

5. The method of claim 1 , further comprising:
determining, via the one or more processors, the corresponding structural format of the target data structure stored on the destination database; and
requesting, from the source database via the one or more processors, 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

• G06F16/214 Primary

  Database migration support · CPC title

• H04L67/10

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