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

Data table migrating method and device

A data table and database technology, applied in the field of data processing, can solve problems such as large amount of data and complex data migration process, and achieve the effect of improving efficiency, reducing complexity, and reducing the amount of code writing

Active Publication Date: 2015-12-30
ZHENGZHOU XIZHI INFORMATION TECH
View PDF5 Cites 45 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to realize the conversion of the data table format in data migration, before each heterogeneous database migration, the business personnel need to write the corresponding migration code according to the data table structure in the source database and the destination database. The amount of data written in the code is large, making The data migration process is more complicated

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 table migrating method and device
  • Data table migrating method and device
  • Data table migrating method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The embodiment of the present application provides a data table migration method and device, so that by providing a general code migration program, the user only needs to modify less configuration data, so that there is no need to rewrite the migration code, reduce the amount of data written in the code, and reduce the code Write complexity.

[0046] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0047] The inventors of the present application researched the existing heterogeneous database migration process and found that: due 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

An embodiment of the invention provides a data table migrating method and device. The method comprises steps as follows: target data in a currently to-be-migrated target source field are acquired from a source data table of a source database; field conversion information configured by a user in a configuration file is called and comprises the correspondence relation of a source field and a target field as well as a conversion function of the data format of the source field and the data format of the target field, wherein the target field is a field in a target data table; on the basis of the field conversion information, the data format of the target data is converted into the data format of the target field corresponding to the target source field; the target data in the converted data format are migrated to the target field corresponding to the target source field in the target data table. With the adoption of the method and the device, data of codes required to be written for data migration can be reduced, and the code writing complexity can be reduced.

Description

technical field [0001] The present application relates to the technical field of data processing, and more specifically relates to a data table migration method and device. Background technique [0002] Database migration refers to transferring the data in the data table from the source database to the data table of the destination database. [0003] If the data table structures of the source database and the destination database are inconsistent, that is, the source database and the destination database are heterogeneous databases, before data migration, the format of the data tables in the source database needs to be converted, and the converted database Tables are migrated to the destination database. In order to realize the conversion of the data table format in data migration, before each heterogeneous database migration, the business personnel need to write the corresponding migration code according to the data table structure in the source database and the destinatio...

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): G06F17/30
CPCG06F16/182G06F16/214G06F16/22
Inventor 文帅营刘建辉闫艳利
Owner ZHENGZHOU XIZHI INFORMATION TECH
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