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

System, device and method for implementing database data migration under heterogeneous platforms

A heterogeneous platform and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of long downtime, difficult for IT personnel to solve, unfavorable technology development, etc., to avoid data retransmission and The effect of disconnection, reducing pressure and network burden, and preventing buffer queue overflow

Inactive Publication Date: 2011-11-30
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF9 Cites 40 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] 1) Due to the requirement that the source and target database types must be the same, it is difficult to meet the seamless migration of data in databases under heterogeneous platforms, such as the seamless migration of data between SharePlex architecture and RealSync architecture
[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 implementing database data migration under heterogeneous platforms
  • System, device and method for implementing database data migration under heterogeneous platforms
  • System, device and method for implementing database data migration under heterogeneous platforms

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] 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.

[0046] Such as figure 1 As shown, the embodiment of the system for implementing database data migration under the heterogeneous platform of the present invention is shown, including the source database connected in sequence, the embodiment of the data migration device of the present invention, and the target database, wherein:

[0047] The source database is used to record the changed data of each application business in the log stream;

[0048] The data migration device is used to capture the changed data of each application business from the log stream recorded in the source database, convert each application business of the source database into standard database...

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 present invention discloses a system, device and method for realizing database data migration under a heterogeneous platform, wherein the system includes a source-end database, a data migration device and a target-end database connected in sequence, wherein: the source-end database changes the data of each application business Recorded in the log stream; the data migration device captures the changed data of the application business from the log stream recorded in the source database, converts the changed data together with the corresponding application business into a standard database query statement through corresponding interpretation, and Pass it to the target-side database; the target-side database completes data synchronization with the source-side database by executing standard database query statements. The invention solves the problem of database description syntax differences between different databases such as business triggering and data storage, and ensures the data consistency between the source end and the target end.

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. The larger the data volume, the more diverse the types of business. 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 to an X86 architecture that can be continuously expanded...

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
Inventor 王友升乔鑫
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
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