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

Data migration method and device

A data and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of low database access efficiency and unsatisfactory data migration speed, so as to avoid low efficiency, save time and improve efficiency Effect

Inactive Publication Date: 2011-05-18
BEIJING YOKA TECH
View PDF1 Cites 50 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Limited by the current technology, the current speed of general data migration is not ideal, especially the migration of massive data, such as migrating a large amount of data in a database to another database. Due to the huge amount of data, completing the migration of all data may require days or even weeks
In the existing technology, the migration of massive data is generally completed through multiple batch operations. For example, for 1 million pieces of user data, every 10,000 pieces of user data are divided into 100 pieces, and the migration is performed in batches. However, in the mass data migration process, if the position of the number fetched is very high, the access efficiency of the database will be greatly reduced. The inventor of this patent has found in practice that when the first batch of fetches ( That is, when extracting 10,000 sets of data from the first set of data), it takes about 5 minutes; and when extracting 10,000 sets of data from the 50th user data, it takes about 15 minutes

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 method and device
  • Data migration method and device
  • Data migration method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0041] refer to figure 1 , which shows a flow chart of Embodiment 1 of a data migration method of the present invention, which may specifically include the following steps:

[0042] Step 101, connect to the source database to obtain source data that meets preset conditions, the source data has field index information, and the preset conditions are extraction conditions set for the field index information;

[0043] Step 102, connect to the target database and store the acquired source data as target data.

[0044] The embodiment of the present invention analyzes the characteristics of the source data and extracts the data that needs to be migrated in the current batch according to the preset conditions in the field of the index, i...

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 discloses a data migration method. The method comprises the following steps of: connecting a source database to acquire source data according with a preset condition, wherein the source data have field index information, and the preset condition is an extraction condition set aiming at the field index information; and connecting a target database to store the acquired source data as target data. The invention can improve the efficiency of data migration, particularly the efficiency of mass data migration and save the migration time.

Description

technical field [0001] The present invention relates to the technical field of data migration, in particular to a data migration method and a data migration device. 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 BEIJING YOKA TECH
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