Research Andimplementation Of Online Analysis System In Data Warehouse

With the development of hospital informationization construction,a large amount of medical business information has been collected.However,data sharing among different systems is the key problem of hospital informationization at present because of the different degrees of hospital informationization,different business systems,and the different degrees of preparation standards.At the same time,the data models,data specifications and data standards adopted are different because functions and business objects of each information system,such as On-Line Transaction Processing(OLTP)and On-Line Analytic Processing(OLAP),are different.Based on the mentioned above,the master data management,data warehouse,data organization,and data model of hospital data center are analysed and designed,and also applied into hospital practice.A multi-dimensional data model is established based on the OLAP of hospital information data according to the needs of hospitals in this paper.A practical generalized model is proposed for master data managing and data model designing of data warehouse.The generalizd model avoids the structure changes of data warehouse caused by data changes.According to the characteristics of medical data in hospital data center,star-shaped and extended snowflake models are used to establish a multi-dimensional data mart for various topics.In order to meet the decision-making and analysis personages in various business areas,data OLAP process research and design are carried out.Statistical analysis of the data can be carried out and the results can be presented in a variety of ways,which has certain decision support functions.The hospital information analysis and processing platform constructed through these ways basically satisfies the needs of the hospital work,and achieves the analysis of indicators which are commonly used in hospital operations.