Vtd-xml-based Heterogeneous Database Data Exchange System Research And Design

With the development of Internet technology and network processing technology, enterprises,universities and government departments began to carry out a wide range of online information technology and intelligent office, departments for the network application systems a significant increase in data requirements.But there is exist heterogeneous data between the various departments.To complete the unity of the entire sector of data management and statistical analysis of the relative difficulties and can't provide authoritative data to the correct decision for the department in the shortest time. Data Exchange Technology of Heterogeneous Databases has been widespread concern that can be done heterogeneous data transmission and exchange interaction between the various departments to achieve data exchange and sharing, and promote enterprise-wide information and intelligent.This thesis mainly researchs and designs to solute data exchange of heterogeneous relational databases,using the XML documents as middle documents for data exchange of heterogeneous relational databases,adopting a new non-extraction (non-extrative) of the XML parsing technology,VTD-XML(Virtual Token Descriptor for eXtensible Markup Language) implementation principle of the analysis,using VTD-XML parsing techniques to handle XML documents related to the operation,the technology is relatively conventional XML's analysis techniques such as SAX and DOM, XML documents themselves do not need to be processed to generate a corresponding object in memory,VTD-XML technology to XML documents to binary character to read the memory directly,using the generated related to VTD (Virtual Token Description) and the location of caching mechanism (Location Cache) pairs of XML documents for fast operation.In this paper, we describe the relevant basic knowledge of XML,such as XML Schema,XML parsing techniques.Descripting and analysising about data exchange of the heterogeneous databases theory and the related process of extracting,transformating and loading.At the same time for the entire platform implementation detailed design the VTD-XML parsing technology.XML documents and relational database mapping technology among Heterogeneous database exchange,data conflict resolution techniques for Data exchange,Data exchange updated data synchronization technology and concurrency control,and based on these key technologies to the entire heterogeneous data exchange platform for design and implementation.Finally, the thesis introduces design of the entire platform system architecture and the overall implementation process, and describes the entire platform functionality of the core module to achieve the design implementation details.The test cases of the system can be a good solution to the heterogeneity between the heterogeneous data, heterogeneous relational database for data exchange capabilities.