Research of Data Warehouse for Science and Technology Management System

Abstract

A core work of the science and technology management system is to support the integration and utilization of massive data from distributed systems using data warehouse technology. In this paper, we focus on this work. First, we introduce the background of science and technology management by illustrating the scheme of project management business flows. Then, to define the science and technology data structure, we propose a customized star model in which we add various dimensional tables to connect the different attributes with science and technology projects. Particularly, a 4-D data cube is introduced to satisfy complicated query conditions in science and technology domain. Furthermore, to integrate data from distributed systems, we propose an architecture of data warehouse of science and technology projects (STPDW)—a five layered system that gathers raw data from the science and technology management systems, and processes the data in a standard workflow by using Extract Transform and Load (ETL) tools with predefined rules. Finally, a prototype system has also been designed to achieve the functionality of the STPDW.