Design And Implementation Of Campus Data Sharing Platform

The development of information technology in higher education is an important part of the development of information technology.At present,the informatization development of colleges and universities at home and abroad has already entered the construction period of digital campus,most of which are focused on the reorganization of functional departments and the integration of existing systems.At the level of data integration,problems such as business gap,system barrier,data island,low data quality and different data standards of heterogeneous database need to be faced with.At the same time,mutual coordination among various departments needs to be taken into account.Therefore,in the development and planning of digital campus,the informationization construction facing the whole school level is more important.On the basis of existing business systems,the data sharing platform is established to connect the databases of various business systems and achieve the extraction and push of heterogeneous data.Through the maintenance of the data sharing platform,the unified management of campus data is realized.Based on the research status of domestic and foreign technical literature and the implementation of various universities,this paper makes a detailed study on the data sharing platform in the digital campus construction project.First,the functional requirements and architectural design of the platform are introduced through use case diagram,three-layer architecture diagram,class diagram and activity diagram.Then,through the investigation and consultation of various departments,we jointly determined a unified data specification of the university,and designed the table structure of the data sharing platform on this basis.Finally,the detailed design and implementation process of the data sharing platform is described in detail.The main technologies involved are as follows:1.Based on the traditional relational database,the heterogeneous database isintegrated by middleware technology and distributed management,and the interactive process of data is discussed by means of JDBC technology and JMS message transmission mechanism.2.The process of ETL is described in detail,and various kinds of KM in ODI are introduced,including the files generated corresponding to each KM,as well as the principle and process of cooperation between them.3.Introduced the management of view and authority of data operation through the construction of business system intermediate library and the setting of relevant authority of data supplier and demander.4.By introducing the configuration of ODI and Oracle with swimlane diagram,especially the interface of ODI and the configuration of KM,the process of data extraction from the source business system and pushing to the target business system was demonstrated.5.In the process of setting up Oracle database,through the establishment of"process",the way of using interface and "process" together is introduced.6.Finally,the process of data extraction and push is tested.Through the status analysis of "task",the accuracy and time of data synchronization are modified to optimize the configuration.7.As the page display of the data sharing platform,the front-end JSP page is published through Tomcat,combined with JAVA and js to deploy the logic implementation of the server,extracted the background data by calling jQurey,and displayed the data obtained to the Oracle database through ODI,and supported the functions of online query and import.After the deployment of the data sharing platform,it was gradually improved through testing and analysis.Through regular data transmission,it basically realized the sharing of business system data,and successively integrated the commonly used systems in the university.With the help of Oracle and ODI,the basic ETL operation was completed in the whole project,enabling the mutual connection between business systems and the mutual transfer of data in the campus.Through the establishment of data sharing platform has changed the old management mode and made the use of data in the university more flexible,timely and accurate.