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

A code generation method and device for data migration in heterogeneous databases

A code generation and database technology, applied in the field of big data, can solve the problem of high labor costs, and achieve the effect of reducing labor costs, reducing workload, and saving time and energy

Active Publication Date: 2022-04-05
SUNING COM CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Excessively consumes the time and energy of technicians, and the labor cost is high

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 code generation method and device for data migration in heterogeneous databases
  • A code generation method and device for data migration in heterogeneous databases
  • A code generation method and device for data migration in heterogeneous databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] In order to enable those skilled in the art to better understand the technical solutions of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Hereinafter, embodiments of the present invention will be described in detail, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention. Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the description of the present invention refe...

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 embodiment of the invention discloses a code generation method and device for data migration in heterogeneous databases, relates to the technical field of big data, can reduce the workload of code development in data migration, and reduce labor costs. The present invention includes: acquiring a script file and mapping information; processing a data migration template according to the mapping information to generate a data reading and writing task, the data reading and writing task is used to read the data to be migrated from the source database, and is used to The target database is written into the data to be migrated; according to the script file and the mapping information, the data migration template is processed to generate a data conversion task, and the data conversion task is used to convert the data of the data to be migrated The form is converted from the source database table to the target database table; the data to be migrated is migrated from the source database to the target database by running the data reading and writing task and the data conversion task. The invention is suitable for data migration of heterogeneous databases.

Description

technical field [0001] The invention relates to the technical field of big data, in particular to a code generation method and device for data migration in heterogeneous databases. Background technique [0002] With the increasing scale of various e-commerce platforms, more costs need to be invested in maintaining and building database systems that support e-commerce platforms. Regardless of whether it is the launch of a new business system or the backup and upgrade of an old system, data migration is often required. [0003] In the existing data migration scheme, logical steps such as data extraction between heterogeneous databases, logical conversion, target database, back-extraction comparison and verification are required, and each logical step requires technicians to manually write a large number of codes and scripts . Especially when there are data tables with tens of millions or even hundreds of millions of data rows, technical personnel are usually required to deve...

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/21G06F8/30
CPCG06F8/30G06F16/214
Inventor 孙迁叶国华司孝波龚钢邓涛
Owner SUNING COM CO LTD