作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2007, Vol. 33 ›› Issue (19): 267-269. doi: 10.3969/j.issn.1000-3428.2007.19.095

• 开发研究与设计技术 • 上一篇    下一篇

基于数据仓库的分析决策系统住院病人费用

刘 佳1,兰顺碧1,张晓祥2,吴 超2   

  1. (1. 华中科技大学网络与计算中心,武汉430074;2. 华中科技大学同济医院计算机中心,武汉 430030)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-10-05 发布日期:2007-10-05

Decision System for Charges of Patient in Hospital Based on Data Warehouse

LIU Jia1, LAN Shun-bi1, ZHANG Xiao-xiang2, WU Chao2   

  1. (1. Center of Network and Computer, Huazhong University of Science and Technology, Wuhan 430074; 2. Center of Computer, Tongji Hospital, Huazhong University of Science and Technology, Wuhan 430030)
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-10-05 Published:2007-10-05

摘要: 介绍了数据仓库的特点和体系结构的同时,对数据仓库技术在医院信息系统中的应用进行了研究,以Oracle Warehouse Builder作为构建数据仓库的技术平台,用Discoverer作为对数据仓库进行联机分析的工具,给出了一个应用于医院住院病人费用分析的数据仓库实例。该实例支持海量数据的深加工和再利用,解决了数据仓库构建、数据分析、客户端程序设计等技术问题,为支持医院管理者的分析决策做出了积极探索。

关键词: 数据仓库, 医院信息系统, 联机分析系统, 多维数据集

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

中图分类号: