Grid based data mobility

Patent metadata

Field	Value
Publication number	US-2016259784-A1
Application number	US-201615157450-A
Country	US
Kind code	A1
Filing date	May 18, 2016
Priority date	Aug 7, 2012
Publication date	Sep 8, 2016
Grant date	—

Abstract

A data migration system and method are disclosed for migrating data from a source server to a target server. The system includes an index containing a plurality of data migration operations in a normalized data model, each data migration operation being stored in association with an attribute, and a data mover communicably connected to the index. The data mover is adapted to move data from the source server to the target server in accordance with the data migration operations contained in the index. The data mover has an attribute corresponding to the associated attribute of at least one data migration operation contained in the index, the attribute indicating the type of data migration operations that can be performed by the data mover.

First claim

What is claimed is:

1 . A computer system for migrating data from a source server to a target server, the computer system comprising:
one or more computer processors, one or more computer-readable storage media, and program instructions stored on the one or more computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:
program instructions to store a set of data migration operations in a normalized data model in a single index, each data migration operation being stored in association with an attribute;
program instructions to store an attribute profile in a data mover communicably connected to the single index, the attribute profile indicating the type of data migration operations that are performed by the data mover;
program instructions to acquire, by the single index, the attribute profile stored in the data mover;
program instructions to transmit, from the single index to the data mover, a data migration operation from the set of data migration operations stored in the single index, wherein the attribute profile of the data mover matches an attribute of the transmitted data migration operation;
program instructions to convert the transmitted data migration operation into a data extraction command in a source language of the source server;
program instructions to transmit the data extraction command to the source server;
program instructions to convert the transmitted data migration operation into a data commit command in a target language of the target server;
program instructions to transmit the data commit command to the target server; and
program instructions to move data from the source server to the target server.

2 . The computer system according to claim 1 , wherein a plurality of data movers having different attributes are connected to the single index, the method further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to connect an additional data mover to the single index or activating an additional data mover if the estimated time exceeds a predetermined upper threshold.

3 . The computer system according to claim 1 , wherein a plurality of data movers having different attributes are connected to the single index, the method further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to disconnect a data mover from the single index or deactivating a data mover if the estimated time falls below a predetermined lower threshold.

4 . The computer system according to claim 1 , wherein the single index further comprises an index of the data on the source server.

5 . The computer system according to claim 1 , wherein the attribute of the data migration operation comprises a source location, a target destination, a platform type, a data type, or some combination thereof.

6 . The computer system according to claim 1 , wherein the attribute profile of the data mover comprises a source location, a target destination, a platform type, a data type, or some combination thereof.

7 . A computer system for migrating data from a source server to a target server, the computer system comprising:
one or more computer processors, one or more computer-readable storage media, and program instructions stored on the one or more computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:
program instructions to store a set of data migration operations in a normalized data model in a central index, each data migration operation being stored in association with one or more attributes;
program instructions to acquire, by the central index, an attribute profile stored in one of a plurality of data movers communicably connected to the central index;
program instructions to transmit a data migration operation from the set of data migration operations stored in the central index, the data migration operation is transmitted from the central index to one of the plurality of data movers having an attribute profile matching the one or more attributes of the data migration operation;
program instructions to convert the transmitted data migration operation into a data extraction command in a source language of the source server;
program instructions to transmit the data extraction command to the source server;
program instructions to convert the transmitted data migration operation into a data commit command in a target language of the target server;
program instructions to transmit the data commit command to the target server; and
program instructions to move data from the source server to the target server.

8 . The computer system according to claim 7 , further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to connect an additional data mover to the central index based on a comparison between the estimated time required to complete movement of the data and a predetermined threshold.

9 . The computer system according to claim 7 , further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to activate an additional data mover to the central index based on a comparison between the estimated time required to complete movement of the data and a predetermined threshold.

10 . The computer system according to claim 7 , further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to disconnect a data mover from the central index based on a comparison between the estimated time required to complete movement of the data and a predetermined threshold.

11 . The computer system according to claim 7 , further comprising:
program instructions to estimate the time required to complete movement of the data from the source server to the target server; and program instructions to deactivate a data mover from the central index based on a comparison between the estimated time required to complete movement of the data and a predetermined threshold.

12 . The computer system according to claim 7 , wherein the central index further comprises an index of the data on the source server.

13 . The computer system according to claim 7 , wherein the one or more attributes of the data migration operation and the attribute profile of the data mover comprises a source location, a target destination, a platform type, a data type, or some combination thereof.

Assignees

• IBM

Inventors

• Smith Ian T

Classifications

• G06F16/2455

  Query execution · CPC title

• G06F3/0647 Primary

  Migration mechanisms · CPC title

• G06F16/214 Primary

  Database migration support · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/235

  Update request formulation · CPC title