Construction And Application Of Electronic Medical Record Data Warehouse

With the continuous development of medical and health reform, computer information technology has been widely used in all aspects of medical and health fields. Hospital as the main body of health, but also become the main battlefield of medical information revolution. All kinds of information system has covered the hospital outpatient, hospital, logistics, management, and other business segments. At present, the information of the hospital has realized the automatic management of the patient’s medical information. In order to make these data better, it is necessary to use computer technology to integrate these data resources. Provide reasonable and reliable data support for hospital administrators, so as to improve hospital management level.First, according to the hospital management decision makers and other relevant management departments of data information needs and the actual situation of the hospital information system, the feasibility of the project, and the related technologies involved in the research, for the establishment of electronic medical records data warehouse.Secondly, the research object of data warehouse and the construction of data warehouse are determined. The Analysis, Services DTS in Server SQL 2000 is used as the software development tool, and the data source view, data extraction and data warehouse model are analyzed.Thirdly, the design of the electronic medical record data warehouse based on the demand analysis, and the use of DTS tools to complete the data extraction, cleaning, consistency verification, integration and other tasks from the HIS and EMR system. Using Services Analysis tool, the data warehouse is set up, and the whole electronic medical record data warehouse is built up.Finally, the data of the electronic medical records from three aspects of the capacity, medical quality, medical income were statistically analyzed. Using Execl 2003 Office as a tool for the analysis of data from the front display.