基于Oracle的人事科研数据仓库设计与实现

Design and Implementation for Data Warehouse of Personnel and Scientific Research Based on Oracle

本文所建立的人事科研数据仓库是基于安阳师范学院的人事科研管理数据,结合计算机软件开发技术、数据库技术和数据仓库技术,建立的高校科研管理决策支持模型。主要包括结构设计、模型建立、数据抽取、转换、加载等。

The Data Warehouse of personnel and scientific research in this paper based on Data Warehouse management of Anyang Normal University establishes a model for strategic decision of scientific research man- agement with Development of Computer Software Technology, Database and Data Warehouse. The model in- cludes structural design of application model, establishment of logical model, implementation of physical mod- el, data pickup, data conversion and data loading.