CN105653532A

CN105653532A - Method for synchronizing heterogeneous database

Info

Publication number: CN105653532A
Application number: CN201410638666.XA
Authority: CN
Inventors: 戎强
Original assignee: ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD
Current assignee: ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD
Priority date: 2014-11-13
Filing date: 2014-11-13
Publication date: 2016-06-08

Abstract

Provided is a method for synchronizing a heterogeneous database. The method is an extensible network application system which realizes resources integration and information sharing, and the method improves timeliness and accuracy of information acquisition, transmission, and processing of management, so as to establish a distributed heterogeneous multi-media resource system with interoperability.

Description

A kind of method that heterogeneous database synchronizes

Technical field

A kind of method that heterogeneous database synchronizes is directed primarily to Computer Database field.

Background technology

Along with the development of computer technology, the environment that modern enterprise faces becomes increasingly complex, and its information system great majority are complication system multi-platform, multisystem. This just requires that the enterprise solution of today has compatibility widely, it is possible to support different system platform, data form and multiple connected mode. In addition, when current distributed database environment is widely used, in the urgent need to a kind of Data Replication Technology in Mobile supporting distributed environment, to realize changing the data of a node transferring to other node up, thus ensure that in distributed environment the uniform synchronization of data on each node, each node can be carried out local autonomous, largely reduce the traffic load to network, enhance the redundancy ability of node simultaneously also by redundant data.

Under the leading that current information technology develops rapidly, information management technique is all stepped into the operational phase of profound level by each enterprise, the environment that enterprise faces becomes increasingly complex, market development and expansion due to enterprise, increasing enterprise has all marched toward the ranks of trans-regional distributed operation, and the result echoed mutually with Corporation Distributed operation creates distributed database environment exactly. The development of information technology is with rapid changepl. never-ending changes and improvements, and a lot of Information System configuration are different periods, and are each designed by different departments again so that the platform of these systems often presents isomerism, result in the discordance of data. In distributed database environment, if distributed data message can not get effectively sharing, so these independent data systems will become one by one " information island ", in addition, flourish along with ecommerce, data exchange between each application system is also day by day frequent, therefore the data in highly desirable each information system integrated of enterprise, eliminate " information island ", between guarantee information system, information exchange is unimpeded, ensure the concordance in data transmission and safety, really realize data sharing. For this, how flexibly and effectively the information processed in these heterogeneous databases becomes interesting studying a question.

For solving data sharing and the integration problem of distributed data base, spy introduces Heterogeneous Database Replication technology, is realized the data syn-chronization of data source and target database by reproduction technology. Data base's duplication refers at disparate databases node and safeguards its conforming method by multiple Replica placement of same data object automatically. This is the important technology improving system availability and reliability in distributed environment. Database synchronization replicates the distribution reproduction technology being the access of a kind of real time remote with real-time update data, most basic function is to improve the performance of database work, by the data in remote data base are copied to this locality, enable an application to access nearby data, avoid and remotely read data, thus reducing network transport load, improve efficiency. When change occurs the data in source database, replicate and can propagate target database updating immediately, as a part of issued transaction. So not only can reduce network transport overhead and shorten response time, moreover it is possible to ensureing that when node and communication failure system is still properly functioning, serve the effect of data backup.

Existing replication theme all relies on the support of data base management system, it is common to there is the premise meeting certain architecture or standard, therefore compatible shortcoming, therefore range of application is subject to certain restrictions.

In practical application, reproduction technology is in data warehouse, application integration, to mobile office, ecommerce, from highly available system, load balancing, has all played important effect to multiple field such as embedded system, internet device.

Summary of the invention

Do not have to find the application materials about this system aspects by national patent retrieval.

This method be the conversion of logical data carry out data syn-chronization itself particularly as follows: list of modification data on districts and cities data base that JDBC is remotely read, produced with dom4j.org increases income and resolves bag DOM4J and realize toward the data write of XML document and the parsing to XML. Dom4j is a storehouse easy-to-use, that increase income, and it is applied to JAVA platform, have employed JAVA and gathers framework and support DOM, SAX and JAXP completely.

In the XML structure of definition, each data of every record are provided with a type attribute, the value of this type be inside java.sql.Types, general data type is compiled number, corresponding type value will be returned according to its field type in data base when program reads data from source database time, then will transfer the type of corresponding target database when reading in data in target database according to this type value to.

The process that data transfer will be gone in needing the content of transmission from SQLServer database transmissions to oracle database exactly. After this synchronization module starts, initially set up and the connection of each SQLServer data base, after the data changing tables of data are changed into XML document, XML document is resolved and then the data parsed is performed with the form of SQL statement on oracle database, thus completing the transfer of data.

This synchronization is remotely to be connected SQLServer data base by JDBC, and obtains the data changed in tables of data, is also finally write data in Oracle data by JDBC.

DriverManager class is the management level of JDBC, acts between user and driver, and it can be followed the tracks of available driver and set up connection between data base and respective drive program. Additionally, DriverManager class also processes the affairs such as the display of the such as restriction of driver login time and login and tracking message;

Statement is for being sent in data base by SQL statement, it includes statement, PreStatement and CallableStatement three kinds, PreStatement is the subclass of statement, and CallableStatement is the subclass of PreStatement. Statement object is for performing the Simple SQL statement without parameter; PreparedStatement object is for performing the precompile SQL statement with or without IN parameter; CallableStatement object is for performing calling data base storing process.

Statement uses executeQuery perform SQL statement and returns ResultSet. ReslutSet comprises all row meeting SQL statement conditional, and it can go the data in access line by get method, and statement object is created by the method createStatement of Connection.

The operating procedure of data base is by JDBC: after calling the connection that DriverManager.getConnection method is set up with data base, create and perform java.sql.Statement, use executeQuery to perform SQL statement and be positioned in ResultSet by meeting all of SQL statement condition in connection, then by ResultSet call get method go to access or obtain the concrete row in the inside value.

In this method, multiple tables use associating major key, a primary key column is comprised owing to changing in tables of data, using the information as recovery SQL statement when being inserted in oracle database, structure (metadata) and the data of major key therefore will be obtained in the different stages. In this synchronization module, the processing mode to associating major key is to devise major key list of meta data and major key data list. Major key list of meta data mainly includes record corresponding to this major key sequence number in tables of data, column name and field type, and major key list of meta data class essentially describes the value list of the major key field for certain table. Value in Table_Delta.update_key can be resolved by major key data list, and correctly processes the situation of many major key fields.

It is taken based on the mode of trigger to obtain change data, what data conversion was taked is as intermediate form to complete the conversion of data using XML document, and the realization of data transfer is to set up the connection with SQLServer data base by JDBC thus reading change data and the data parsed being written in Oracle.

Claims

1. its conversion being mainly characterized by being carried out data by XML of method that a heterogeneous database synchronizes.

2. according to claim 1, initially set up and the connection of each SQLServer data base, the data changing tables of data are changed into XML document.

3. then XML document is resolved according to claim 2 and then the data parsed are performed with the form of SQL statement on oracle database, thus completing the transfer of data.

4. remotely connect SQLServer data base by JDBC, and obtain the data that change in tables of data, be also finally write data into Oracle data by JDBC.