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

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

针对高校当前异构数据环境所带来的数据冗余、不一致、共享困难等问题,文章分析高校各业务系统所存在的数据壁垒,从信息标准的建立、数据清洗规则与数据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.