Hospital Decision Support System Based On Data Warehouse

In this paper, establishment of a decision support system for the hospital which combines with the data mining technology, on-line analytical processing and data warehouse technology. The system is mainly based on the data warehouse to build hospital decision support system, which can meet different levels of management for multi-layered.The final decision system for:through the theme of Microsoft SQL server 2000 service component to build data warehouse, using the data mining technology and combined with the idea of on-line analytical processing to analysis and design the hospital decision support system. The comprehensive information, which is the data of the year 2006 to 2009, is offered by one of three level of first-class hospital in Jinan. And it includes the information of patient's medical data, related medical treatment cost and the data handbook.In this paper, I make the following job. The first, the medical quality is analysed when using hospital decision support system. The second, the hospital database is designed, including the logical model design and logistics structure design. The third, hospital cost analysis of database is set up, which has 14 dimensions and thirty metrics. The fourth, quality analysis database, with eight and ten metrics for hospital, is set up. The fifth, the factors, such as basic hospital situation, hospital charge, the composition of charge and medical quality, are online analyzing and processing. The sixth, I establish and analyzes hospital decision tree mining model, which is arming mainly to the impact of medical treatment cost in hospital.