Data Migration System Based on Multiple Data Storage Platforms

A technology for migrating systems and data, applied in electrical digital data processing, special data processing applications, instruments, etc.

Active Publication Date: 2017-05-31
北京小笨鸟信息技术有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

These tools address the extraction and transformation of data to a certain extent

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
  • Data Migration System Based on Multiple Data Storage Platforms
  • Data Migration System Based on Multiple Data Storage Platforms
  • Data Migration System Based on Multiple Data Storage Platforms

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] Preferred embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0048] 1. Process design

[0049] First of all, it must be able to connect with the source database and the destination database; and then automatically map the data type according to the tool or set it manually. For the case where the data table structures of the source database and the destination database are different, the mapping relationship between tables and fields must also be set.

[0050] In general, the main steps of a complete migration task from creation to execution are as follows:

[0051] 1. Select the source database and destination database to connect.

[0052] 2. Select the database object to be migrated.

[0053] 3. Determine the conversion of the data type. The types of the source database and the destination database can be mapped through the type mapping table that comes with the system, and the corresponding situa...

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

A data migration method, comprising the following steps: connecting a source database and a destination database; reading out data to be migrated from the source database; converting the read data into data of an intermediate data type; converting the converted data of the intermediate data type to data of a data type of the destination database; and writing the data converted to the data type of the destination database into the destination database. According to the method, the problem of data migration on the condition that the source database and the destination database are different in data table structure can be solved, and meanwhile, the data migration across data platforms is supported.

Description

technical field [0001] The invention relates to data migration technology, in particular to a heterogeneous data migration technology of various data storage platforms. Background technique [0002] In the process of project development, we often encounter the problem of migrating the historical data of the old system to the new system. Many historical data are very important to the new system, and some are even necessary when the system is started. It can be said that a successful historical data migration is the basis for the successful launch of the new system. The quality of data migration not only determines the success of the new system launch, but also has a huge impact on the stable operation of the new system after launch. [0003] Database systems generally have many sub-tools, and data migration tools are one of them. Many database vendors provide data migration tools, such as Informi's InfoMover, Microsoft SQL Server's DTS and Oracle's Oracle Warehouse Builder,...

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/00
Inventor 许丹霞刘寅汪伟郑宇
Owner 北京小笨鸟信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap