Smes Heterogeneous Database Integration And Implementation

With the gradual procedure of Enterprise Information,information islands can be found in these enterprises. They construct the heterogeneous database structure in the enterprises. How to resolve the problem is a hotspot in computer field.This paper designs and realizes the SME Heterogeneous Data Integration System, the main contents are as follows:Having analyzed the traditional method of data extraction, the thesis proposes two kinds of new Incremental data extraction methodes for the Mid- and small-scale enterprise practical system we develop: One is incremental data extraction method of virtual log. By making use of trigger it writes database operation sequence into operation tables, and acquires incremental data by reading operation tables. The means of virtual log reduces the extraction object from row to fields, and optimizes log, reducing the data redundancy. The other is incremental data extraction method of SHA1 under the scene of no trigger support by DBMS, we make use of SHA1 algorithm to calculate the record's summary. According to compare the new summary and old one, we can extract the incremental data. This strategy is simple, runs rapidly.In the research of heterogeneous data transformation method, Having analyzed and compared the traditional transformation methodes,we present a heterogeneous data transformation method basis of xml template. In this method, we make use of xml mapping to eliminate name heterogeneity,utilize transformation expression to eliminate unit heterogeneity, make use of transformation function and mapping tables to eliminate precision heterogeneity, data type heterogeneity and the heterogeneity of data expression method. We store the heterogeneity transformation information into xml template, which is separated from business system, and realizes the Scalability.Having analyzed current data integration method, we are aware of that they don't meet the demand of heterogeneous data integration for small and medium-sized enterprises, so we present a data integration method which is feasible to medium-sized enterprises: Incremental data extraction + Ftp transmission+ xml conversion template + XML signature encryption. Client program makes use of incremental Extraction procedure to extract local database incremental data,Afer dealing with the data, transmits the data to server.After the server program receives the data,it will eliminate the data heterogeneity by making use of Xml transformation template,and writes the data into center database. This method doesn't need to modify original business system programming, spends little money, has a good data transmission speed. It meets the demand of small and medium-sized enterprises.Lastly, the thesis presents an instance of Zhenjiang security monitor system. This system implements the data integration of heterogeneous databases in the environment of decentralized subsystems for small and medium-sized enterprises. The results show that the method of data integration for small and medium-sized which we present is available, it achieves the expectation.