Research of university data statistical platform based on data warehouse

Abstract

In order to adapt to the demand of statisting and analyzing huge-data in universities under current situation,an overall programme was designed and implemented to construct data statistical service platform based on data warehouse.The overall framework of university data warehouse and the modeling method of data warehouse were researched,and a statistical data model based on data star-schema model was designed.Furthermore,the key technology in the process of implementing statistical service platform like ETL(Extraction-Transformation-Loading) and UI interface design were explored.It provides practical basis and theoretical support for the next step to build the management and decision support platform of universities.

Keywords

• business intelligence;data statistics;data warehouse;star-schema model;statistics data model