System, device and method for realizing data migration of heterogeneous database

A database and data technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to generate default data, unfavorable technology development, long downtime, etc., to achieve rapid migration and reduce host pressure and the effect of network burden

Inactive Publication Date: 2012-06-20
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF1 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] 1) Since the above solution is only a modeling tool, it cannot generate default data, and cannot automatically convert the data model of the source database into the data model of the target database, so it is difficult to achieve rapid data migration of heterogeneous databases in a short period of time
[0010] 2) It cannot ensure that the target database is in an active state, resulting in long downtime during data migration, such as Oracle's own component physical backup mechanism, etc.
[0011] Due to the above-mentioned technical deficiencies, it is difficult for IT personnel to solve the above-mentioned problems they face, resulting in a bottleneck that is not conducive to the continued development of technology

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
  • System, device and method for realizing data migration of heterogeneous database
  • System, device and method for realizing data migration of heterogeneous database
  • System, device and method for realizing data migration of heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings and preferred embodiments. The following examples are only used to illustrate and explain the present invention, but not to limit the technical solution of the present invention.

[0048] A relational database is composed of a collection of all entities and the relationships between entities in a given application field. The type of a relational database is called a relational database schema, which is a description of a relational database and involves the definition of several domains, that is, several relational schemas are defined on these domains. The value of a relational database is a collection of relations corresponding to these relational schemas at a certain moment, and is usually referred to simply as a relational database. Usually, data migration of heterogeneous databases is for relational databases.

[0049] When the environme...

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 system, a device and a method for realizing data migration of a heterogeneous database. The system comprises a source end database, a data migration device and a target end database, wherein the source end database converts a data model or application service of the database into a general data model or service through reverse engineering of a relational database; the data migration device compiles and decompiles the general standard data model or service converted from the source end database into a standard data model or application service of the target end database according to the characteristics of the target end database, and explains the data model or application service into standard database query sentences and transmits to the target end database; and the target end database executes the standard database query sentences transmitted by the data migration device, and finishes the data migration from the source end database through a pipeline mechanism type channel. Through the invention, quick migration of the cross-platform and cross-database data can be realized relatively well.

Description

technical field [0001] The invention relates to a method for data migration between different databases in computer technology, in particular to a system, device and method for realizing database data migration under a heterogeneous platform. Background technique [0002] Information Technology (IT, Information Technology) system has been in operation for a long time. On the one hand, its heterogeneity has brought greater complexity to the enterprise's information upgrade and management. As a result, the amount of data is becoming larger and larger, and the types of business are becoming more and more diverse. As a result, the various operations of the enterprise are strongly dependent on the normal operation of the IT system, which makes many IT personnel face problems similar to the following: [0003] (1) How to realize the migration of customer business under different platform architectures [0004] For example, migrating customer business under a non-X86 architecture...

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
Inventor 徐国强乔鑫
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
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