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

A data migration method and device

A technology for data and migration, applied in the database field, can solve problems affecting the data transmission speed and stability of the database, and achieve the effect of improving data access performance, improving efficiency, high reliability and high concurrent storage access

Active Publication Date: 2020-12-29
ADVANCED NEW TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present application provides a data migration method and device to solve the problem in the prior art that the storage and access of binary files affects the data transmission speed and stability of the database

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] Such as figure 2 As shown, the flow chart of the data migration method provided in Embodiment 1 of the present application includes the following steps:

[0044] S201: Determine a first file to be migrated based on data records to be migrated in the first database.

[0045] Here, there may be multiple data records to be migrated in the first database, and for each data record to be migrated, the first file to be migrated is determined.

[0046] In the embodiment of the present application, considering that the storage space occupied by binary files is large, and the non-binary files in the data records to be migrated, that is, the storage space occupied by text files is relatively small, the steps can only be performed on the binary files. Processing of S202.

[0047] Specifically, a binary file may be extracted from the data records to be migrated; and at least one of the extracted binary file and a text file converted based on the binary file may be determined as t...

Embodiment 2

[0054] The following takes the first file to be migrated as a binary file and the second file to be migrated as a non-binary file as an example for further introduction.

[0055] Such as image 3 As shown, the flow chart of the data migration method provided in Embodiment 2 of the present application includes the following steps:

[0056] S301: Distinguish binary files and non-binary files in the data records to be migrated in the first database, perform the following S302 for the binary files, and perform the following S303 for the non-binary files.

[0057] Here, the data record to be migrated can be new data (newly received, not yet formally entered into the database) written into the queue to be processed in the first database (old database) after it is determined that the database needs to be moved, or it can be stored in Historical data in the first database.

[0058] For historical data, the identification information (Identity, ID) of each historical data record in t...

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 relates to the technical field of databases, in particular to a data migration method and device. The data migration method and device are used for solving the problems that in the prior art, the data transmission speed and stability of a database are affected by storage of a binary file and access to the binary file. The data migration method includes the steps that a first to-be-migrated file is determined based on a to-be-migrated data record in a first database; the first to-be-migrated file is stored in a set file system, and identification information of the first to-be-migrated file is stored in a second database, wherein the identification information of the first to-be-migrated file is information for identifying the storage position of the first to-be-migrated file in the file system.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data migration method and device. Background technique [0002] Computer files are basically divided into two types: binary files and ASCII (also known as plain text text files), computer programs such as graphic files and word processing programs are all binary files. These files contain special formatting and computer code. ASCII is a simple text file that can be read with any word processing program. [0003] In some cases, such as when the business is split, the current database cannot meet the storage requirements of binary files (binary files generally occupy a large storage space), etc., we will need to save the data in the current database (hereinafter referred to as the old library) The data is migrated to another database (hereinafter referred to as the new database), and after the data migration is completed, the online business is migrated from the old...

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): G06F16/21
CPCG06F16/214
Inventor 赵振林
Owner ADVANCED NEW TECH CO LTD