高校数据仓库多层架构设计与ETL实现

Design and Implementation of ETL for Multi-Layer Architecture of College Data Warehouse

为了充分利用高校各业务系统积累的大量数据,设计了5层数据仓库的系统架构,运用数据抽取、转换和加载(ETL)工具,把分散在学校不同业务系统的数据资源进行分类和整合,可以提供个人数据中心的集中展示、数据下载等服务;利用联机分析等工具进行数据展现,可以为学校领导提供决策支持.

In order to take full advantage of large amounts of data accumulated from each college operation system,a five-layer data warehouse architecture was designed.A data extract-transform-load（ETL）tool was used to classify and integrate the data scattered in different business systems.Data warehouse can provide teachers and students with intensive show of personal data center,data downloads and other services,as well as provide decision support for the colleges by using online analysis tools for data display.