Method and system for data migration

A data and database technology, applied in database models, relational databases, structured data retrieval, etc., can solve the problems of multi-time, high accuracy requirements, and consumption, and achieve the effect of reducing duplication and improving work efficiency and efficiency.

Active Publication Date: 2019-12-31
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the face of complex business systems involving hundreds or thousands of tables, it takes a lot of time and effort to manually execute migration statements or write migration scripts, and manual migration or writing scripts has high requirements for accuracy, and no omissions can occur , errors, etc.

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
  • Method and system for data migration
  • Method and system for data migration
  • Method and system for data migration

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0048] The embodiment of the present invention discloses a method and system for data migration, so as to implement data migration for data.

[0049] see figure 1 , a data migration method provided by an embodiment of the present invention, comprising:

[0050] S101. Obtain the table name parameter file, obtain the database connection name information, obtain the first quantity information of the executable program, and obtain the second quantity information of th...

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 discloses a data migration method. The method comprises the steps of when data in a database is migrated, inputting migration parameters required for data migration into a programmed migration script framework; automatically generating a corresponding number of executable program sets according to the migration parameters; and migrating the data by running the executable program set, so that the problem of repetition, omission, errors or the like caused by manual execution of a migration process is reduced, the efforts of engineers are released, the migration process and a result are concerned, and the working efficiency and the data migration integrity and accuracy are improved, wherein the migration parameters are a table name parameter file, database connection name information, first quantity information of executable programs and second quantity information of statements in the executable programs. The invention furthermore discloses a data migration system, which can achieve the technical effect as well.

Description

technical field [0001] The present invention relates to the technical field of data migration, and more specifically, to a data migration method and system. Background technique [0002] The process of data migration from ORACLE to K-DB involves the migration of hundreds of gigabytes of large-capacity business tables. The common method is to use database connection or smooth text files for data migration. In the process of using database connection migration, you need to manually execute migration statements in multiple windows to achieve parallel migration and improve migration efficiency. In the face of complex business systems involving hundreds or thousands of tables, it takes a lot of time and effort to manually execute migration statements or write migration scripts, and manual migration or writing scripts has high requirements for accuracy, and no omissions can occur , errors, etc. [0003] Therefore, how to perform data migration is a problem to be solved by those ...

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/28
CPCG06F16/214G06F16/284
Inventor 关坤龙杜彦魁
Owner INSPUR SUZHOU INTELLIGENT TECH 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