The Design And Implementation Of Health Decision Support System Based On Data Warehouse

With the development of digital hospital,a large number of business system based on database technology and computer networks are being applied across the departments in hospital.These subsystem,which based on database technology and focus on the business flow,markedly enhances operational efficiency and management skills. However, it also brought some unexpected problems,the business system Generate a lot of background data,which covered the information of the whole medical process.which were not integrated use, caused great waste.No matter from the perspective of the scientific management of modern hospital, or the point of view of business needs,the data in business system of hospital need to be extracted, cleaned and effective integrated, restructured according to the theme, aim to set up a health industry characteristics, suitable for information comprehensive analysis data warehouse, and on this basis, develop the health management decision support system.Information decision support system which applied to big data environment should have the following features:(1)A large scale, high efficiency, high safety performance of data warehouse is needed as s support.(2)Have strong ability of OLTP and OLAP support.(3)All-weather work, absolutely safe and reliable;(4)The human-computer interaction interface simple and easy to use, meet the needs of different user groups;(5)Scalability, can according to different stages of development needs for function continues to expand;(6)Openness and portability, to meet the needs of different platforms.This topic is based on the hospital service subsystem back-end data comprehensive recycling problems,According to the health administrative departments at different levels of business requirements, the extraction and the relevant data collection subsystem of hospital business,with ETL tools.the data extracted from hospitals can be collected in the data center.The final step is to use BI develop decision support system.The paper has also elaborated the problems encountered in the process of development and deployment.