Code generating method and device for migration of data in isomerous database

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: 2018-04-24
SUNING COM CO LTD
View PDF10 Cites 20 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
  • Code generating method and device for migration of data in isomerous database
  • Code generating method and device for migration of data in isomerous database
  • Code generating method and device for migration of data in isomerous database

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 generating method and device for migration of data in an isomerous database, and relates to the technical field of big data. The workload of code development during data migration can be reduced, and the labor cost can be reduced. The method comprises the steps that a script file and mapping information are acquired; a data migration template is processed according to the mapping information, and a data read-write task is generated, wherein the data read-write task is used for reading the data to be migrated from the source database and writingthe data to be migrated into a target database; the data migration template is processed according to the script file and the mapping information, and a data conversion task is generated, wherein thedata conversion task is used for converting the data form of the data to be migrated into a target database table from a source database table; the data read-write task and the data conversion task are run, and the data to be migrated is migrated into the target database from the source database. The method and device are suitable for migration of the data in the isomerous database.

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 Applications(China)
IPC IPC(8): G06F17/30G06F8/30
CPCG06F8/30G06F16/214
Inventor 孙迁叶国华司孝波龚钢邓涛
Owner SUNING COM CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap