Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for migrating data from DB2 database to K-DB database

A database and data technology, applied in the database field, can solve the problems of consuming manpower and other resources, complex operation, high risk, etc., and achieve the effect of reducing the risk of data resource loss, simple operation, and high security

Inactive Publication Date: 2017-02-22
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method is complicated to operate, high in risk, low in efficiency, and consumes a lot of manpower and other resources, so it is not suitable for use in actual production

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 device for migrating data from DB2 database to K-DB database
  • Method and device for migrating data from DB2 database to K-DB database
  • Method and device for migrating data from DB2 database to K-DB database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The core of the present invention is to provide a method and device for migrating data from DB2 database to K-DB database, which converts the work of DBA into an automatic method, which is easy to operate, reduces the error and error rate of database administrator operations, and makes data migration Simpler, more efficient and safer.

[0045] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention. ...

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 method for migrating data from a DB2 database to a K-DB database. The method comprises the following steps: receiving source connection information and destination connection information; according to the connection of the source connection information to the source DB2 database, extracting the migration data from the source DB2 database; modifying the migration data into first migration data to support a K-DB syntax structure; according to the connection of the destination connection information to the source DB2 database, creating a table and index in the destination K-DB database and loading the first migration data. According to the method, the work of a DBA achieves automation, the operation is simple, the error rate of a database administrator is reduced, and data migration is thus more simple, more efficient and safer. The invention further discloses a device for migrating the data from the DB2 database to the K-DB database, and the device has above-mentioned advantages.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for migrating data from a DB2 database to a K-DB database. Background technique [0002] DB2 database is a set of relational database developed by IBM, and it is a relational database widely used in the market; K-DB database is an enterprise-level database management system launched by Inspur Information; DB2 and K-DB databases are heterogeneous Database, currently, the data migration between the two is usually implemented by a DBA (Data base Administrator, database administrator) in a completely manual way to migrate the DB2 database to the K-DB database. [0003] With the development of applications, the amount of data stored in the database is also increasing, and the structure becomes more complex. During data migration, the DBA needs to do a lot of manual operations during the short business downtime window to complete the data migration. This method i...

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/30
CPCG06F16/214G06F16/27
Inventor 宿叶露范红飞
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com