校园一卡通数据共享设计与实现

Design and Implementation of Data Sharing of Campus Card

针对目前我国学校中普遍存在的各业务系统缺乏数据交互问题,以校园一卡通作为切入点,设计了一种通过中间数据表来实现各业务系统间数据共享的方案。通过ODI工具建立一个共享数据库,对各业务系统的数据进行抽取和存储,并周期性地进行数据更新;当其他业务系统需要查询数据时,共享数据库将指定数据推送到校园一卡通的中间数据表中,以此实现不同业务系统间的数据共享。

In view of the current lack of data interaction problems in various business systems in China＇s schools,this paper takes the all-in-one campus card as a breakthrough point,and designs a scheme to achieve data sharing among different business systems through intermediate data tables.The program is mainly through ODI tools to build a shared database,it extracts and stores data of various business systems,and periodically updates the data.When other business systems need to query the data,sharing data between databases will be specified in the data sheet onto the campus card in order to achieve different business systems data sharing.