摘要
数据仓库技术对操作型数据转化成全面、集成的信息,以及对海量数据的查询和统计提供了有效的途径。本文在介绍数据仓库、联机分析处理概念和技术的基础上,分析了面向主题的多维数据库的建立和多维视图的展现等技术,针对中国科学院评估数据,基于Oracle 8i和Brio,提出在已有的各种业务数据的基础上,建立面向评估主题的数据仓库系统的基本构想。在中国科学院创新工程不断深化与推进的背景下,引入数据仓库技术可以对决策者进行更准确、更快捷的数据与决策支持服务。
The technology of data warehouse provides an effective way to convert data generated from practices into comprehensive,integrated information.The date warehouse also makes massive data inquiry and statistics possible.The data warehouse and OLAP concepts and technologies are introduced;the skills involving how to build the multi-dimension database and how to present the multi-dimension view of database are analyzed.Also based on the evaluation data generated from the evaluation practice in these years,the framework of evaluation-theme-oriented data warehouse in the evaluation research center of CAS is built using Oracle 8i and Brio.Under the background of promoting and deepening innovation project in CAS,the attempt to introduce the data warehouse technology into the storage and analysis of evaluation data would produce more accurate and efficient data and decision support service for decision makers.
出处
《科研管理》
CSSCI
北大核心
2007年第z1期114-120,共7页
Science Research Management