Implement And Research Of Medical Expenses Of Decision-making Based On Data Warehouse Technique

It is not only enterprises' desire but also our crucial problem to face that how to extract valuable knowledge from mass business of hospital management system in force which helps decision level of enterprise to make manage decision. It has been a new trend to develop hospital information systems by adopting data warehouse, data mining technique and On-Line Analytical Processing technique.From the perspective of data warehouse and data mining technique, the 3 years (2004—2006) patient costs data which from the HIS of X hospital in Changsha has treated in this paper by using data mining and on-Line analytical processing technique. In the text, the analytical theme and dimensions of medical costs have also established, moreover a logical model of data warehouse and data mining model have designed. At the same time, of the medical cost data have established. in order to realize the data showing from many angle, the multi-dimensional sets ,MDX and pivot table have been adopted in this text. Using ID3 algorithm to analyze the influence factors of in hospital fee, and it has been improved specific to the defect of choosing the more properties. The result of experiment shows that the accuracy rate and efficiency of the improved algorithm have been gone up. To improve the K-means algorithm by symmetrical sampling about how to choose initial value, and the experiment results shows the accuracy rate of clustering results has been improved.This study shows that, by use of On-Line Analytical Processing and data mining technique to excavate hospital medical expenses, it can lead to efficient management and decision-making. Also the solution can be applied to medical institutions of various levels with HIS system and becomes the effective decision-making tools for the leadership level of medical institutions.