Research And Implementation Of Hospital Data Warehouse

Data warehouse technology is a subject-oriented, integrated, and relatively stable, reflecting the historical changes of the data sets used to support management decisions. Data warehouse technology has been in various industries at home and abroad has been widely applied, the market developed rapidly and achieved remarkable results. In recent years, Major hospital information construction made significant progress, information systems has developed from the stage of the cost information management to the stage of clinical information management. especially in the general medical record data have accumulated for a very long time, how to integrate the use of these data and analysis has become the contents of the scholars beginning to study. Furthermore, Medical staff also need to analyze a large number of treatment programs in order to summarize regularities in time, it will have a positive effect to The process of accelerating the research.The design of Hospital data warehouse begins from data warehouse model. Firstly analysising the data source and the need of the decision-making management,the article designs the hospital's data warehouse conceptual model, logical model, physical model,by the way of data-driven. Then, for examples of cost subject,the corresponding packet of information from maps, star model, and multi-dimensional model are given.as a data source, the hospital information system data and medical record data of a hospital in recent years, the article analyzies the relationship between the data source table, data structure, the meaning of the field, using Microsoft SQL Server 2005 Integration Services (SSIS) create, deploy and manage SSIS package step by step for implementation of the extract, transform and load data to the hospital's data warehouse. Business Intelligence Development Studio is used for development and deployment and Analysis Services is used for multi-demension data cube's design.Taking analysis of single disease for example, the cube's key indicators of the number of the diseases, constitute a cost, length of stay are designed and Drug proportion, the average length of stay, average hospital charges,three Computed column is added. By OLAP tools the analysis understand the changes and the trends and influencing factors of fee structure and characteristics of disease incidence, This provides a basis for scientific data for the decision-making of the Leadership for the hospital management and clinical departments, provides a good data analysis support for hospital scientific research.