Design And Implementation Of The Heterogeneous Data Exchange System

With the popularity of Internet and the Ever-changing development of information industries as well as the increasingly sophisticated computer technology, business data showed a geometric growth, so database technology has been more widely used. In the development of most enterprises and companies, they accumulated a mass of data in the course, but because of the very different data management systems, there is difference when we choose a variety of data processing systems and also makes the data sources vary widely, huge amount of data actually exists, which constitutes a huge and complex heterogeneous data environment. Therefore, how to implement distributed data exchange between heterogeneous databases and sharing has become a major problem to confront in urgent need and solve.In order to achieve the aim at exchange and sharing of data between heterogeneous databases, develop a common data exchange middleware could ensure the normal operation in the vast network of information systems, and also ensure the consistency of heterogeneous data and remote data updated in time. This paper presents a solution to design and implement heterogeneous data transmission, introduces the concept of transfer tasks systematically which use a common transmission preparation, make XML files as the intermediate vector of heterogeneous data exchange, design heterogeneous data exchange system by using buffer pool data and FTP file transfer protocol, in large measure to solve the problem of the data transmission between heterogeneous information systems are incompatible and the update problem in heterogeneous information systems in order to achieve the information exchange in a large-scale heterogeneous data network system .This pager design a data exchange platform by analysis ,to achieve information exchange in large-scale network system of between heterogeneous database information systems or multi-level network systems, data synchronization update in various types of heterogeneous correlation business system , business systems integration in Wide Area Network, data backup in a large remote database, and so on. The main research problem is about transferring data configuration, automatic task management technology, heterogeneous data formats, data extraction, analysis, merge and storage consolidation, the integrity constraint in data transfer task, and FTP services features. Apply the FTP services highly efficient and stable mechanism in upload and download remote data file to solve the data consistent in the exchange data of multi-level database information between upper and lower. Resolve universal platform problem by studying the heterogeneous database transmission configuration and data transmission configuration technology to study, using of XML formatted data file as a unified standard format, in order to unity the data format for unification of heterogeneous information systems, undifferentiated heterogeneous database information exchange, to achieve flexible configuration in data files or database transmission platform .The data transmission platform of universal heterogeneous primary goal is research data exchange information technology in large-scale network system; develop a common heterogeneous data transmission middleware software, to achieve information exchange in large-scale network heterogeneous information system and multi-level network systems. Thereby, solve the heterogeneous data transmission problems and provide reliable data exchange platform for e-government, e-commerce technology development and other related fields .Establish a common, efficient and safe, reliable and efficient transmission channels ,develop a common data transmission system, provide reliable protection for the normal operation of the network in large business information system, data consistency and timeliness of information updates between different regions .