高校异构系统数据集成平台的构建研究  

Research on the construction of data integration platform of heterogeneous systems in universities

作　　者：张军[1] 王芬芬[1] Zhang Jun;Wang Fenfen(Hunan Railway Professional Technology College,Zhuzhou 412001,China)

机构地区：[1]湖南铁道职业技术学院,湖南株洲412001

出　　处：《无线互联科技》2020年第19期62-63,共2页Wireless Internet Technology

基　　金：2018年度湖南省教育厅科学研究项目,项目名称:基于Hadoop和MPP混合模式的高校数据仓库构建及应用研究,项目编号:18C1528。;2018年度湖南铁道职业技术学院校级课题,项目名称:基于ETL高校数据仓库的构建及应用研究,项目编号:K201823。

摘　　要：针对高校当前异构数据环境所带来的数据冗余、不一致、共享困难等问题,文章分析高校各业务系统所存在的数据壁垒,从信息标准的建立、数据清洗规则与数据ETL过程等方面介绍了数据集成的过程,设计了基于ODI的数据交换与流转的数据集成方案,采用虚拟视图和中间库的方式降低了数据集成过程中的耦合性,提高了数据集成平台的灵活性和扩展性。In view of the problems of data redundancy,inconsistency,and sharing difficulties caused by the current heterogeneous data environment in colleges and universities,the article analyzes the data barriers existing in various business systems in colleges and universities,and introduces from the aspects of establishment of information standards,data cleaning rules,and data ETL processes.The data integration process was designed,and a data integration scheme based on ODI data exchange and circulation was designed.The use of virtual views and intermediate libraries reduced the coupling during the data integration process and improved the flexibility and scalability of the data integration platform.

关 键 词：数据集成 数据共享 ODI 

分 类 号：G647[文化科学—高等教育学] TP311.13[文化科学—教育学]