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

Research of university data statistical platform based on data warehouse

作　　者：龙新征[1] 李丽[1] 彭一明[1] 王倩宜[1] 欧阳荣彬[1] 刘云峰[1] 

机构地区：[1]北京大学计算中心,北京100871

出　　处：《通信学报》2013年第S2期163-169,共7页Journal on Communications

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

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

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]