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

Data structured migration method and device, computer equipment and storage medium

A data and regular technology, applied in the database field, can solve problems such as error-prone, cumbersome operation, and slow backup and import process

Active Publication Date: 2019-09-06
SUNING COM CO LTD
View PDF11 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the traditional data migration method, the backup and import process is slow, and the databases in today's large enterprises are basically divided into databases and tables. This requires separate backups and corresponding imports. The operation is cumbersome and error-prone, and if the types of the new and old databases before and after migration are inconsistent, It is difficult to ensure the correctness of imported data

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 structured migration method and device, computer equipment and storage medium
  • Data structured migration method and device, computer equipment and storage medium
  • Data structured migration method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0049] The data regularization migration method provided by this application can be applied to such as figure 1 shown in the application environment. Wherein, the terminal 104 communicates with the source database server 102 and the target database server 106 through the network, but the communication method is not limited to network communication. Wherein, the terminal 104 can be but not limited to various personal computers, notebook computers, smart phones, tablet computers and portable wearable devices, and the source database server 102 and the target database server...

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 a data structured migration method and device, computer equipment and a storage medium. The data structured migration method comprises the steps: according to a preset sourcelibrary sub-library sub-table rule and source data table migration batch information, reading migration data of the batch from a source database; performing data analysis on the to-be-migrated data according to a preset data organization rule to obtain an analysis result which comprises a clean data table and a to-be-queried data table; writing data in the clean data table into a target database according to a preset target library sub-library sub-table rule; and detecting a selection operation of data in the to-be-queried data table, and writing the selected data into a target database according to a target library sub-library sub-table rule. By adopting the data structured migration method, the migration efficiency and the migration accuracy can be improved.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a method, device, computer equipment and storage medium for regularizing and migrating data. Background technique [0002] With the development of Internet technology and database technology, data migration has become a common technology in database data processing. Data migration is a key part of data system integration to ensure smooth system upgrades and updates, and there are various types of databases. [0003] The traditional data migration method mainly downloads different backup tools for different databases, and after the data is backed up locally, it is imported into the new database device, or copied to the new database device through the underlying binlog (binary log) file. In the traditional data migration method, the backup and import process is slow, and the databases in today's large enterprises are basically divided into databases and tables. Thi...

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): G06F16/21G06F16/215G06F16/22
CPCG06F16/214G06F16/215G06F16/2282
Inventor 张衡司孝波徐义飞
Owner SUNING COM CO LTD
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