Research Of Synchronized Trigger And Update Technology Between Heterogeneous Relational Database Systems

Today’s society, science and technology industry is in rapid development, withthe expansion of each enterprise development and the informationization levelunceasing enhancement, the enterprise can build up a variety of different informationsystems to meet their growing business development needs. In the enterprise isindependent of each other between each other between multiple applications. Andused to store user information management, and even between different systemshave different type of database. Departments data storage, access, and there arecertain heterogeneity, platform type and may occur after the system upgradecompatibility problems, thus can cause will not be able to share information betweendifferent departments, to form what we usually call "information island"."Information island" will produce a lot of fragmented and isolated informationsystem, the information can’t interactions on the function, system application andbusiness processing will be isolated from each other. In this way, will bring manyinconvenience to daily business, it will also increase the maintenance cost of theenterprise. Therefore, under the environment of heterogeneous database, completethe data synchronization between heterogeneous database systems management isvery important.In order to solve the disadvantages brought by the "information island", betteruse of existing data, the information interaction between application systemperformance, and improve the user experience, avoid repeated data entry andmanagement problem, reduce the maintenance cost of the enterprise, increase theability of enterprise business process, avoid the operation complexity caused byheterogeneous database system, the enterprise needs to set up a unified informationmanagement system, to achieve heterogeneous database data synchronization triggerupdates, the seed information system information through this system, unified tocomplete a variety of applications, such as create, delete, and update accountinformation, etc.This paper studies the data synchronization update problem between heterogeneous database systems. Including the two methods. Is a whole libraryscanning synchronization system: using the middle database as a bridge and scannedthe whole database application system, find out the user information has changed,and then complete the master-slave synchronization of information system. Anothermethod is synchronized trigger updates the system: this system has realized the threeheterogeneous database subsystem and information synchronization between a mainsystem, the main idea is:1. The subsidiary system of database log tables, through thetrigger technology will all the data in the subsystem changes are recorded in the logtable.2. Using the regular scanning technology for scan log tables for timing systemaccording to the scan data records regularly update the data of the primary system, soas to realize the data synchronization of master-slave system updates. Innovationpoint of this paper is to use a trigger mechanism to create a log table, improve workefficiency, reduce maintenance cost. To avoid the data synchronization in themaster-slave system update, to scan all the data library, causing a huge increase inworkload, reduce the operation efficiency of the system.