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

Mass data migration method and device

A massive data and data technology, applied in the database field, can solve problems such as long-term business interruption, multiple requirements for database types, and long migration time of massive data, so as to reduce business interruption time and control the migration process

Inactive Publication Date: 2014-07-09
HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
View PDF4 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] In order to solve the technical problems in the prior art that the migration time of massive data is too long, there are many types of database requirements, and the business needs to be interrupted for a long time during data migration, the present invention proposes a method and device for massive data migration, which can greatly reduce the data migration time , business interruption time, and requirements for database types

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] figure 1 It is a flowchart of a method for mass data migration in an embodiment of the present invention. Such as figure 1 shown, including the following steps:

[0023] Step 101, creating a migration configuration table;

[0024] Step 102, judging the type of data to be migrated according to whether the massive data changes within a preset time period;

[0025] Step 103, modifying the migration configuration table according to the migration data type;

[0026] Step 104. Migrate the mass data according to the migration configuration table.

[0027] This embodiment analyzes the data that needs to be migrated, and classifies the data that needs to be migrated into data that does not change, data in a large table that changes frequently, and data in a small table. Use the configuration table to mark various tables, and mark the current status, whether it is being copied or the copy is over. Through the internal table monitoring provided by large databases, such as th...

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 mass data migration method and device. The method comprises the following steps of establishing a migration configuration table; determining the data migrating type according to whether mass data change in a preset time period; according to the data migrating type, correcting the migration configuration table; migrating the mass data according to the migration configuration table. The mass data migration method can greatly reduce data migration time, service interruption time and the requirements on the varieties of databases.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for mass data migration. Background technique [0002] With the development of business, expansion of system hardware, change of system architecture, platform conversion and other reasons will require migration of system data. Among them, there are three technical solutions for the migration of massive data: [0003] 1. Use the logical import and export tools that come with the database, such as oracle's export and import. [0004] Using this solution for migration can achieve cross-platform migration. In order to ensure the consistency of migrated data, business services must be interrupted, and for massive data, the interruption time is long. You can use the full library, user mode, or table mode when exporting and importing. [0005] 2. Use the physical backup tool that comes with the database for recovery, such as oracle's rman. [0006] Using this ...

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
CPCG06F16/214
Inventor 芦薇
Owner HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
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