The Application Of Steams Replication Technology In The Provincial Land Tax Data Distribution

With the advancement of informatization,Data Integration has become the mainstream trend of the financial institutions,government departments,hospitals and enterprise informationization.With the limit of different territory,storage mode,platform type and access method,different utility system can't share the information of data warehouse,which cause the"Information Isolated Island".To design a data sharing schema of breaking the Information "Isolated Island" and sharing the data of data warehouse is of great practical significance.The main method to break Information "Isolated Island" is to realize the synchronization and sharing of the Main database and Secondary databases in the internal organization' s utility system.There exist some problems in the common data synchronization technology,such as the exorbitant price,higher requirements for the system,complicated configuration,the unsolvable data conflicts,the bad supportive to the heterogeneous environment,The deployment architecture is single and the database must be copy completely to another.According to the different application requirements,it' s important to choose the appropriate data synchronization technology.Under the background of provincial taxation data centralization,GUI ZHOU Local Taxation Bureau realized the data centralization in 2013.The product data of Cities and states in GUI ZHOU Province have been centralized to the GUI ZHOU Local Taxation Bureau,however,the cities and states' special software system was based on the data produced by the cities and states' local taxation bureau,thus,the major issue to be addressed is to choose the right schema solving the data synchronization and sharing.Based on the Oracle database,The dissertation take Guizhou local tax bureau as the Application scenarios introduces the application of data synchronization technology in large scale distributed business system through four aspects.1)In the dissertation,The common data synchronization technology are analyzed and compared such as DataGuard,Advanced Replication,Oracle GoldenGate,Oracle Streams Replication technology etc.Focuses on the free Oracle Streams Replication data synchronization technology which can support data replication between different hardware platforms and different versions of the Oracle database,and support a flexible deployment architecture.2)Based on the current situation analysis of Guizhou Provincial Local Taxation Bureau data distribution,Completed the specific scheme of the provincial data distribution and based on the data distribution scheme the configuration and optimization of the table level Streams Replication scheme with local capture process is implemented.The dissertation detail introduce the packet data distribution scheme according to the data type difference in the case of large amount of data and complex data types.3)With the configuration and optimization complete,this dissertation studies the conflict and error processing of Streams Replication,and implements a custom data conflict solution and error handling scheme.Combined with Streams Replication own DBMS_APPLY_ADM data conflict processing package,Design and implemente the data conflict processing program which can handle all DML(insert,delete,update)operation conflic.By analysising and summarying of the Streams replication error types,implete a custom stored procedure which can classified processing common application process errorr.4)In order to ensure the data distribution go on wheels,The System combined with scheduling mechanism of the open source system DNN(Dote Net Nuke),binding the short message interface which realized the real-time page monitoring and real-time message monitoring of Streams Replication.At the end of the dissertation the operation status of Streams Replication is described,then discussed the application direction of the Streams Replication technology in the future.