Design And Implementation Of Campus Card Data Sharing Based On Data Sharing Platform

In this paper,through the analysis of the relevant technology of data sharing and integration in colleges and universities,combined with the digital campus project and e-card project construction of Northwest A&F University,in the departmental business system,mainly for the lack of top-level system design and information standards are not uniform.Such as,these leads to data sharing difficulties,poor circulation of information resources and other issues within the school.Through the research on the data synchronization of campus card system and data sharing platform,the purpose is to solve the information sharing in different architectures and systems,realize and business cooperation between different department in colleges and universities,and,alleviate the contradiction of data barriers in the process of deepening the development of informationization in colleges and universities,and finally break the situation of information island.Through the campus data sharing platform to achieve the data sharing of the business system of colleges and universities.It will provide a comprehensive and accurate data base for the school to achieve a full range of information query,deeper data mining,intelligent decision-making research,in order to further realize the wisdom of the campus has a profound meaning.This paper's main conclusions are as follows:(1)Studied the data integration technology based on ETL and ODI of Oracle data integration tool,and discussed the different ways of data extraction.It focuses on the comparison of trigger,timestamp,Oracle CDC and other incremental extraction methods to achieve the e-card system Data sharing provides reliable technical support.(2)Realized the design of data incremental extraction scheme of campus card system based on ODI.In the data source to create a separate timestamp table,used to save the data synchronization time node information,the next data extraction,just extract the time point after the record,you can complete the incremental extraction,this design has advantageous for improve the efficiency of data extraction to avoid the impact on the operation of the database table.(3)Combined with the campus card system data,and determined the data type and structure needed from the data sharing platform,and completed the docking database design.(4)Studied the data sharing between e-card system and third party business system through campus data sharing platform.To achieve the campus card system database of students and faculty basic information and extended information sharing,reducing the basic information of the repeated collection,improve the data sharing rate.To achieve the campus card and grants system,asset management and financial reimbursement and other data sharing,to facilitate the teachers and students,for the research support work to provide a convenient work.