Analyze Design And Realization Of The Publishing Group's Data Exchange Platform

With the development of information technology and Internet, a global information society has been founded. As the contribution of information has been developed, the contribution of standard information is more and more important. Now in China, because of the lack of the unified rules, the system patterns and standard data formats are not unified in most existing information-based management system. It's very hard to contact with each other, so a great many "Isolated information nodes" have been appeared. The goal of data exchange platform in the data center is data exchanging and data sharing between different-constructional data sources, which can be more effective in building data standard, decreased data redundancy and finally eliminated "isolated information nodes". But the data that need to be exchanged has many conflicts in field names, format types and constructions. The essence of data exchange is to deal with these conflicts and exchange data.Firstly in this paper we analyzed the theory of heterogeneous database system, described the basic concepts of heterogeneous database system and system construction in detail, introduced the strategy of data copy in the environment of heterogeneous database system, the interconnection methods of heterogeneous database system. We started on data exchange theory and divided the data express and construction express in source tables and target tables. So heterogeneous database was matching construction first, and then exchanging the data. Based on the way of data exchange —initialized copy and timing copy was used a heterogeneous replication scheme based on incremental transactions. Initialized copy used comparatively spare time of the net, did initialize copy in great amount of data, realized coherence and security of inside data. Timing copy is after initialized copy. It used database flip-flop method and time mark control method to insert, delete and update the data, which can meet the need of a little data timely update in press group. In the process of platform development, according to users' actuality and function requirement, we use the method based on setting transmission variable which match limitation and system actuality as transmission strategy. This paper has strictly written about the requirement analysis, system design and software engineering of Shandong Publishing Group data center information exchange platform. Described the data exchange platform data flow, build and maintain public dictionary, build the basic data comparison table and data standard, and successfully implemented the platform solved the data exchange problem of the group's part Data Base.