摘要
为满足高校对各业务系统所有产生的操作型数据进行集成、统计和分析需求,需应用数据仓库技术,完成业务系统数据的采集与治理工作,为上层应用提供规范、有效的数据服务。基于此,文章结合高校业务数据的特点和实际应用需求,给出了高校数据仓库平台的架构设计,针对高校数据分析需求多变、统计复杂的特点,文章设计了集中抽取、分区治理、多维建模的建设方案,着重分析了主题数据区的维度模型构建方法,设计了教师基础数据星型模型和学生学籍数据雪花模型。最后给出了数据清洗策略,为高校数据仓库的建设提供了参考和借鉴。
In order to meet the needs of integration,statistics and analysis of all the operational data generated by various business systems in Colleges and universities,it is necessary to apply data warehouse technology to complete the collection and management of business system data and provide standardized and effective data services for the upper application.Based on this,combined with the characteristics and practical application requirements of university business data,this paper presents the architecture design of university data warehouse platform.According to the characteristics of the changeable and complex data analysis needs of universities,this paper designs a construction scheme of centralized extraction,partition governance and multidimensional modeling,and focuses on the analysis of the construction method of the dimensional model of the subject data area,the star model of teachers'basic data and the snowflake model of students'status data are designed.At last,The data cleaning strategy is given,which provides reference and reference for the construction of data warehouse in Colleges and universities.
作者
张军
王芬芬
ZHANG Jun;WANG Fenfen(Information and Technology Center,Hunan Railway Professional Technology College,Zhuzhou Hunan 412001,China)
出处
《智能计算机与应用》
2020年第5期218-223,共6页
Intelligent Computer and Applications
基金
2018年度湖南省教育厅科学研究项目(18C1528)。
关键词
数据仓库
数据分析
维度模型
雪花模型
Data Warehouse
Data Analysis
Dimension Model
Snowflake Model
