Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Structure oriented data migration method and system

A data and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that the main table data and its sub-table data cannot be loaded at the same time, the code fields cannot be converted, and the data structure is not completely the same.

Inactive Publication Date: 2006-04-26
阎海强
View PDF0 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the existing data migration tool products, functions such as data filtering, conversion, and loading can be realized, but because the data structures of the old and new systems are not completely the same, the code fields in the old system cannot be converted into codes in the new system, or Automatic code generation in new systems
Therefore, the main table data and its sub-table data cannot be loaded at the same time in the new system
In this way, the old system data must be processed in advance, which increases the difficulty and workload of data migration

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
  • Structure oriented data migration method and system
  • Structure oriented data migration method and system
  • Structure oriented data migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] refer to figure 1 Shown is an implementation environment diagram of a structure-oriented data migration method and system of the present invention. The system runs on a client computer and connects with the source database server, source file server and target database server through the network. When the system is running, it reads data from the source database server or source file server, and stores the data to the target database through the network.

[0016] refer to figure 2 Shown is a functional block diagram of a structure-oriented data migration method and system of the present invention. The system consists of a template definition module, a data migration engine module, and a developer application program interface (API). The template definition module provides a graphical user interface for users to define data migration templates. To define a data migration template, first define the data source and target database, as well as the template event handle...

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

The invention provides a data migration method and system, which is characterized by the following: migrating the filtered and transmitted data source in the object data base; maintaining new data structure relationship of data to dictionary citing and main graph to subgraph automatically in the migration course. The system contains stencil definition mode, data migration engine mode and exploiter appliance program interface (API). The method contains the following steps: setting system parameter; defining data migration stencil; executing data migration.

Description

technical field [0001] The present invention relates to a data migration method and system, in particular to a structure-oriented data migration method and system. Background technique [0002] In the process of informatization construction, the original information system is constantly being replaced by a new system with more powerful functions. In the process of switching between the old and new systems, there is bound to be a problem of data migration. Some old systems often accumulate a large amount of precious historical data during their use from the start to the replacement of the new system, many of which are necessary for the smooth start of the new system. Data migration is the process of filtering, converting, and loading these historical data into the new system. Data migration is mainly applicable to the situation where one old system is switched to another new system, or multiple old systems are switched to the same new system, and the historical data in the ...

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
IPC IPC(8): G06F17/30
Inventor 阎海强
Owner 阎海强
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com