通信学报 ›› 2013, Vol. 34 ›› Issue (Z2): 163-169.doi: 10.3969/j.issn.1000-436x.2013.Z2.031

• 数字化校园与典型应用 • 上一篇    下一篇

基于数据仓库的高校数据统计服务平台研究

龙新征,李丽,彭一明,王倩宜,欧阳荣彬,刘云峰   

  1. 北京大学 计算中心,北京 100871
  • 出版日期:2013-12-25 发布日期:2017-06-16

Research of university data statistical platform based on data warehouse

Xin-zheng LONG,Li LI,Yi-ming PENG,Qian-yi WANG,Rong-bin OUYANG,Yun-feng LIU   

  1. Computer Center,Peking University,Beijing 100871,China
  • Online:2013-12-25 Published:2017-06-16

摘要:

为了适应新形势下高校对大数据统计、分析的需求,设计实现了一套基于数据仓库的高校数据统计服务平台的整体方案。对高校数据仓库的整体架构、数据仓库的建模进行了研究,井设计了一种基于数据仓库星型结构的统计数据模型;进一步探讨了统计服务平台在实现过程中ETL(extraction transformation loading)以及界面设计等方面的关键技术;为高校下一步搭建管理与决策支持平台提供了重要的实践基础和理论支撑。

关键词: 商业智能, 数据统计, 数据仓库, 星型模型, 统计数据模型

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.

Key words: business intelligence, data statistics, data warehouse, star-schema model, statistics data model