Design and Implementation of ETL Based on University Data Integration System

WANG Xiao-hong,LIU Ying,ZHANG Yan-feng
DOI: https://doi.org/10.3969/j.issn.1673-629x.2011.07.048
2011-01-01
Abstract: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.
What problem does this paper attempt to address?