Abstract:
This paper introduces the characters, the framework and designing methods of data warehouse, and puts forward a practical project for the data warehouse using in the analysis of the charges of curing and being in hospital. And this project is on the basis of Oracle Warehouse Builder and Discoverer used for OLAP analysis. The data warehouse supports the mass data on the further handling and recycling. It also solves some technical problems such as the implementation of the data warehouse, data analysis, and client program designing. The system helps the hospital to make decisions positively.
Key words:
data warehouse,
hospital information system,
online analytical system,
multidimensional dataset
摘要: 介绍了数据仓库的特点和体系结构的同时,对数据仓库技术在医院信息系统中的应用进行了研究,以Oracle Warehouse Builder作为构建数据仓库的技术平台,用Discoverer作为对数据仓库进行联机分析的工具,给出了一个应用于医院住院病人费用分析的数据仓库实例。该实例支持海量数据的深加工和再利用,解决了数据仓库构建、数据分析、客户端程序设计等技术问题,为支持医院管理者的分析决策做出了积极探索。
关键词:
数据仓库,
医院信息系统,
联机分析系统,
多维数据集
CLC Number:
LIU Jia; LAN Shun-bi; ZHANG Xiao-xiang; WU Chao. Decision System for Charges of Patient in Hospital Based on Data Warehouse[J]. Computer Engineering, 2007, 33(19): 267-269.
刘 佳;兰顺碧;张晓祥;吴 超. 基于数据仓库的分析决策系统住院病人费用[J]. 计算机工程, 2007, 33(19): 267-269.