高校数字化校园建设是高校教育信息化发展的一项重要任务。由于高校普遍采用不同的数据库系统来管理学校的一切事务,致使信息存在大量的冗余、不一致,乃至"信息孤岛"的现象,从而严重制约了高校的信息化的建设。基于ETL的数据集成技术能够很好地解决这个难题。以高校集成数字校园平台建设为背景,提出了高校数据集成系统中基于ETL平台的建设方案。系统将ETL技术与传统的数据集成技术相结合,采用适配器技术和中间件技术,处理大批量的历史数据、实时处理小批量的变化的数据,全方位地满足用户对所有数据处理的需求,解决了异构数据集成和共享问题。
Digital campus construction is an important task for the higher education information development.Due to the different database commonly used by universities to manage all matters of the school system,there are a lot of redundant and inconsistent information or even the information island.These have seriously hampered the university information construction.The data integration technology based on ETL can solve this problem.Taking the university integrated digital campus platform as the background,the construction program of the university data integration system based on ETL is proposed.The system integrates the ETL technology with traditional technology,and use adapter technology and middleware technology to handle large quantities of historical data and to deal with small quantities of data in real-time,which can meet customer demand of all the data processing,and solve the problem of heterogeneous data integration and sharing.