Researching On And Application Of The Construction Of Data Warehouse And Data Mining Based On HIS

With the development of the hospital system and the reform of the social insurance system, a great many of hospitals have created their own hospital management information system (HIS). Hospital management information systems are increasingly important. However, with its applications and development, its database is growing inflation, the analysis of how to fully utilize the existing hospital valuable information resources for hospital management decision making services and in the medical market increasingly competitive environment maintaining their core competitiveness, continuous development, so, the technology of DataWarehouse and DataMining based on HIS come out.In this situation, through researching on HIS existing , thesis proposes the establishment of a Data Warehouse based on hospital information management system and data analysis of Data Mining to improve hospital management of the decision-making level. Through the technology of data warehouse, based on actual demand, to analysis, extraction, established themes, effective data organization from enormous hospital database, to build a data warehouse model. After Data Cleaning and Data Transforming, the Data Warehouse comes to Data Loading. Thus, the establishment of DataWarehouse can hold SQL Queries, statistical Reports, OLAP data analysis and Data Mining, to effectively serve the hospital management decision-making.The thesis makes use of Microsoft SQL Server 2000 technology of DataWarehouse and DataMining to put forward solutions. Microsoft SQL Server 2000 in the performance and expansion have established world-leading position,is a competitive database and data analysis solutions. Analysis Services provided OLAP and DataMining functions ,and made OLAP become the integration of Microsoft SQL Server, provided expansion of OLAP-based the Com interface. The thesis makes use of OLAP and DataMining techniques, analysis of data through the data warehouse to carry out a multidimensional datasets from the multi-level and multi-angle,and analysis of data warehouse of hospital out-patient department and in-patient departments of information by OLAP and DataMining analysis, and the results of the analysis available PiovitTable display. At the same time, the thesis puts forward an effective Association Rules mining method to make an improvement, and gives specific algorithms. This method enhances the practical application of efficiency of Association Rules. Specifically, this article has done the following jobs:Through a great deal of data analysis and pre data processing jobs from the Source database, put forward the theme of constructing the data warehouse and his made based on the data warehouse models.Made use of Microsoft SQL Server 2000 Analysis Services for OLAP and DataMining and the creation of multidimensional datasets by data warehouse,and used OLAP technology for multidimensional data analysis and DataMining.Researching and exploring the Association Rules mining algorithms and Apriori algorithm ,and its application to Data Mining of several ways to improve the efficiency of the algorithm operation. Apriori algorithms and the use of research, made an effective way to improve the existing rules related to the improvement and expansion of the Association Rules mining algorithms.The organizational structure of the article is as following...