Data for exchanging data among homogenous and heterogenous DBMSs (database management systems) on basis of active database technology

Abstract

The invention discloses a method for exchanging and synchronizing data among homogenous and heterogenous DBMSs (database management systems) on the basis of an active database technology. The method is used for conveniently and efficiently exchanging and synchronizing data among homogenous and heterogenous databases. The method includes steps of determining data environments of a source end and a target end with data to be synchronized; determining a corresponding relation between the data of the target end and the data of the source end; creating an initialization table and a log table in a database of the source end; forming corresponding operating commands in the database of the source end by the aid of data required for synchronization initialization in a storage process, and writing the operating commands into the created initialization table; creating inserting, modifying and deleting triggers on tables related to the source end with the data to be synchronized, splicing the synchronization operating commands required to be executed at the target end into character strings whenever the data change, and using the character strings as values of fields of operating commands of the log table to form a record in the log table; and exchanging and synchronizing the data. The operating commands are executed at the target end.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data exchange and data synchronization method between homogeneous and heterogeneous DBMSs based on active database technology. Background technique [0002] At present, with the continuous advancement of information construction in various enterprises and institutions, different application systems continue to increase. However, due to different application departments, different development undertaking units, different development platforms, and common database heterogeneity, especially the lack of consideration for information sharing and exchange in the construction of various application systems, there are more and more "information islands". This not only affects the consistency, reliability and authority of data, but also leads to the obstruction or limitation of industry information services, which affects the quality of information construction. Therefore, strengthening the co...

AI Technical Summary

Problems solved by technology

Third, even if there is a synchronization program, when the target needs to calculate and process the source data before storing it, the synchronization application needs to be changed, which brings inconvenience to data synchronization

Images