Method and device for data exchanging among isomerous and heterogeneous databases

Abstract

The invention relates to a method and device for data exchanging among isomerous and heterogeneous databases. The method comprises the following steps of: establishing data exchanging channels among the databases; particularly, converting data in a special format in a source database into data in a basic format; and converting the data in the basic format into data in another special format and feeding the data in the another special format into a target database. The method and the device are applied to data exchanging among the isomerous and heterogeneous databases so as to keep the consistency of the data among the databases. The method and the device have the advantages that the method and the device for data exchanging among the databases, which are simple and easy to operate and have strong applicability, are adopted; and the problem of data exchanging among a plurality of databases, the problem of bidirectional updating of the same data table among the databases and the problem of system structure under the condition of an unspecialized line can be solved. The method and the device can be suitable for data exchanging among the databases with any type structure. The respective independences of the source database and application programs are reserved. The problem of synchronous updating of the data among the same group of databases is rapidly solved without manual intervention.

Description

technical field [0001] The invention relates to data exchange between databases, in particular to a method and device for data exchange between heterogeneous and heterogeneous databases. Background technique [0002] In the prior art, it is absolutely impossible to directly exchange data between databases of different brands and different structures. Not only are the internal protocols of databases different, but their data structures are also very different. In order to maintain data consistency between a group of databases for the same purpose during operation, many methods have been used. In the early days, it was useful to manually export the database content, use a disk as a carrier, and load it to another database; this method is too slow and labor-intensive, and it is difficult to apply to large-capacity databases. Commercial databases have a certain ability to replicate, but they must work under ideal conditions with many restrictions. The design ideas have relativ...

AI Technical Summary

Problems solved by technology

In the early days, it was useful to manually export the database content, use the disk as the carrier, and load it to another database; this method is too slow and labor-intensive, and it is difficult to apply to large-capacity databases

Commercial databases have a certain ability to replicate, but they must work under ideal conditions with many restrictions. The design idea has relatively large limitations and the scope of application is narrow.

There are also some independent data replication software, which is characterized by the point-to-point replication database architecture, but cannot solve the data transformation between databases with complex topological structures composed of multiple heterogeneous databases.

In addition, there is also specially developed data exchange software. Although the efficiency is high, its object is the data replication of specific application systems, which is not universal, and the development is time-consuming and laborious, and the cost is high.

Images