College Student Intormation Data Integration System

With the rapid development of information technology,each department in colleges and universities uses information management system to handle daily business.However,the development environment,the development stage and the handled business of management systems of these departments are different,so database designs of these management systems are very different.Thus the mutual sharing of data is not realized between databases and the data between these management systems is inconsistent.Also,the overall business cannot be handled by individual department management system but only manual work,therefore a lot of manpower and material resources will be consumed.This paper carries out a detailed analysis based on the existing data integration system schemes.These integration systems realize the integration of heterogeneous data,but they also have some defects such as high development cost,high data redundancy rate,etc.Accordingly,this paper designs and realizes an integration system based on XML technique.The main realization process is as follows:The first step,finding out changes in subsystem database: adding trigger in data table with public fields,capturing types and parameters with which users operate on public data table and storing in recording table;The second step,packaging changes into XML file: using packaging module to package contents in recording table into XML file and transferring to the integration system via Web Service interface;The third step,converting XML file: analyzing the conversion type of corresponding files and the typed file of corresponding fields and generating conversion functions to convert numerical parts of XML file;The fourth step,pushing XML file to realize synchronization: sending the converted XML file to the subsystem through push module,analyzing through the subsystem to generate SQL statement,and executing SQL statement to realize synchronization;The fifth step,handling overall business: splitting overall query business into several query operations on subsystem database based on overall view and respectively carrying out query handling.Compared with the existing database integration system,the system developed by this paper has the following advantages:(1)By using XML technique to convert heterogeneous data,each subsystem can be still normally used while original database design modes are maintained;the original data is better protected.(2)It realizes the real-time synchronization between heterogeneous databases,ensures the consistency of the data of the student information management system in colleges and universities,and greatly reduces the repeated inputting of public data.(3)Without the need for establishing large database,it can copy and store the information of the whole school;it has low data redundancy rate and low development cost.(4)Through the test,it verifies the correctness and the robustness of the developed system;the system is expected to be used in actual management in colleges and universities;it improves management efficiency and saves management cost.