Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for data migration

A data and data table technology, applied in the field of data processing, can solve problems such as spending a lot of time and affecting normal business, and achieve the effect of improving efficiency

Active Publication Date: 2017-10-31
IBM CORP
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0015] There is such a common problem in the above-mentioned traditional data migration method. Since there is usually a large amount of data in the target data table, it often takes a lot of time to directly rebuild the index in the target data table, which seriously affects normal business.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for data migration
  • Method and system for data migration
  • Method and system for data migration

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0028] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: it can be complete hardware, it can also be complete software (including firmware, resident software, microcode, etc.), and it can also be a combination of hardware and software. Called a "circuit", "module" or "sy...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

In one embodiment, a method for data migration includes: receiving intermediate data and corresponding key value-row location information mapping list; importing each row of the intermediate data to a corresponding row of a target data table, where each row of the target data table has a target physical row ID; and establishing, by a computer processor, a target index of the target data table based on the target physical row IDs and the key value-row location information mapping list. With the method or system of this invention, the efficiency of reestablishing a data index after data migration can be improved.

Description

technical field [0001] The present invention relates to a data processing method, and more particularly, to a method and system for data migration. Background technique [0002] In the current era of big data, data migration is a frequent occurrence. figure 2 It shows a typical process of data migration, which is applicable to various database systems most widely used in business at present. From a source data table (Table 1) in a source database (DB1), all the tables in the table The data is migrated to the target data table (Table 2) with the same structure or a different structure in the target database (DB2). The general steps of the existing technology are to first export the data in the source data table (Table 1) to an intermediate The intermediate data is formed in the file. The intermediate file can be in the form of various files, of course, it can also be in the form of a table in a related database, but its data information is consistent with the data informatio...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/214G06F16/10G06F16/2228G06F16/31G06F16/9027G06F16/951
Inventor 殷卓李昂刘健高英明邹献
Owner IBM CORP