摘要
为解决高校信息化建设中各个子系统各自为建形成的信息孤岛问题,提出以Kettle为基础,通过对多源异构子系统数据的抽取、转换形成共享数据中心.研究了ETL原理及Kettle的使用方法,分析了高校现有数据整合存在的问题,提出了学校数据整合的基本步骤和原则,并以学校教务系统、一卡通平台和智慧教室平台整合为例,快速实现了信息系统间数据共享,同时也为未来建立数据挖掘分析提供了数据支撑.
In order to solve the problem of information islands in the information construction of colleges and universities,it is proposed to use Kettle as the basis to form a shared data center by extracting and transforming multi-source data.The principle of ETL and the usage method of Kettle are studied,the existing problems of data integration in colleges and universities are analyzed,and the basic steps and principles of school data integration are proposed.Finally,taking the integration of the school’s educational administration system,all-in-one card platform and smart classroom platform as an example,data sharing between information systems was quickly realized,and it also provides data support for data mining analysis in the future.
作者
赵建勋
ZHAO Jian-xun(Information Center,Xi’an University,Xi’an 710068,China)
出处
《西安文理学院学报（自然科学版）》
2020年第3期28-31,36,共5页
Journal of Xi’an University(Natural Science Edition)
