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

A data migration method and related device applied to a distributed database

A database and data technology, applied in the computer field, can solve the problems of data migration from the source database to the target database, difficulty in meeting the diverse storage requirements of future scenarios, etc.

Active Publication Date: 2022-07-12
WANYI TECH
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the existing technology, when migrating from one database to another, the data cannot be migrated from the source database to the target database due to the different table structures between the databases, and it is difficult to meet the diverse storage requirements in future scenarios

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 related device applied to a distributed database
  • A data migration method and related device applied to a distributed database
  • A data migration method and related device applied to a distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0072] Optionally, based on the first aspect, in the first possible implementation manner of the present application, the method further includes:

[0073] If the data to be migrated exists in the N target data tables, determining the importance level corresponding to the data to be migrated contained in the N target data tables;

[0074] Setting a storage period for the data to be migrated according to the importance level;

[0075] obtaining a preset storage period corresponding to the importance level;

[0076] When the storage period exceeds a preset storage period, the data to be migrated contained in the N target data tables is deleted.

[0077] Optionally, based on the first aspect or the first possible implementation manner of the first aspect, in the second possible implementation manner of the present application, the determination is related to the data to be migrated contained in the N target data tables. The corresponding importance levels include:

[0078] Ext...

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 present application discloses a data migration method and related device applied to a distributed database. The method includes: acquiring data to be migrated from a source database, wherein the data to be migrated belongs to N source data tables, and N is a positive Integer; establish first data migration mapping information between the source database and the target database, wherein the first data migration mapping information is used to represent the N source data tables and the N target data of the target database The mapping relationship between the tables, each of the N target data tables belongs to each of the N target data sub-bases, and the N target data sub-bases belong to the target database ; Migrate the data to be migrated to the target database according to the first data migration mapping information. Implementing the embodiments of the present invention is beneficial to realize the migration of data from the source database to the target database, so as to meet the diversified storage requirements in future scenarios.

Description

technical field [0001] The present invention relates to the field of computer technology, and in particular, to a data migration method and related device applied to a distributed database. Background technique [0002] With the advent of the era of big data, the requirements for storage are also getting higher and higher. With the growing amount of data, a database is often unable to meet the storage requirements. Therefore, enterprises hope that the data stored in the database can be migrated to another database to meet the storage of massive data. [0003] In the prior art, when migrating from one database to another database, data cannot be migrated from the source database to the target database due to different table structures between the databases, and it is difficult to meet diverse storage requirements in future scenarios. SUMMARY OF THE INVENTION [0004] Embodiments of the present invention provide a data migration method and related device applied to a distr...

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/21G06F16/27
CPCG06F16/214G06F16/27
Inventor 石康唐小珍
Owner WANYI TECH