The Research And Development Of Data Exchange Platform Based On XML

With the rise of digital medical treatment, requirements for hospital informatization are gradually improving. More and more hospitals begin to build their own data centers to integrate disperse medical data resources to process, storage, transmit and exchange intensively. They aim to realize the consolidation and standardization of medical data management and data sharing between various departments and branches to improve the level of hospital informatization and comprehensive service. But the original systems of the hospital use different databases to store data, so how to exchange the cross-databases data to the data center has become the critical problem in the construction of hospital data center.In this paper, we mainly research the data synchronization problem between heterogeneous databases for the actual situation during the construction of the data center. The key of data synchronization is to find the data format which can be identified and processed by any platform. The XML becomes the ideal medium of heterogeneous data conversion because of its cross-platform, extensible, easy parsing advantages. Therefore the synchronization technology research of heterogeneous database is based on XML. The main work includes the following several aspects:(1) This paper puts forward a method to get change data based on triggers and record tables. This method can be used with any database which supports trigger mechanism and we need not modify the structure of the original table. All the change data and control information are stored in the change record tables. This method not only applies to many databases, but also easy to extend.(2) The paper uses XML as an intermediary heterogeneous data format for data exchange. The cross-platform, easy to parse, strong structure and easy to expand attributes makes it become the ideal intermediary format for heterogeneous data conversion.(3) Sampling data validation method is designed to check databases on a number of critical and important data table to ensure the consistency and integrity of data exchange on both sides. We also add the role detection and validating user login code to prevent unauthorized access and malicious attacks. Otherwise we use MD5 algorithm to encrypt important data to prevent leaks.(4) Log4Net logging component is used to record system operation information to ensure the stable operation of the system. We designed queue storing solutions for concurrent access problems. We use brute force and unauthorized access test to verify security of the platform. Also we through timing task test and bulk data insertion to test the stability and reliability of the platform.