Creation method and system for medical big data warehouse

Abstract

The invention discloses a creation method and system for a medical big data warehouse. The method comprises the following steps of (1), extracting shared data and non-shared data in a business database of each medical sanitation information system through an ETL tool, cleaning the shared data and the non-shared data, and converting the shared data and the non-shared data to a data buffer region of an ODS; (2), extracting the shared data of the data buffer region of the ODS through the ETL tool, cleaning the shared data, and converting the shared data to a shared data region of the ODS; and (3), extracting the non-shared data of the data buffer region of the ODS to the data warehouse, and extracting the shared data of the shared data region of the ODS to the data warehouse. The creation method and system has the beneficial effect that the pressure of accessing a hospital server is reduced by creating the data warehouse.

Description

technical field [0001] The invention relates to a method and system for creating a medical big data warehouse. Background technique [0002] With the intensification of competition in the medical industry, the introduction of new medical reform plans and other factors, new changes have taken place in the current environment of hospitals, and they are facing new challenges for their survival and development. At the same time, with the gradual change in the transformation of the medical model, the hospital's transformation model has changed from extensive to refined, terminal to link-based, and empirical to evidence-based management. Hospitals need comprehensive, multi-dimensional, and intelligent management. , The easy-to-operate intelligent analysis system provides hospitals with scientific and comprehensive data support, and promotes the transformation of hospital management from extensive management based on experience to refined management based on data. [0003] Althoug...

AI Technical Summary

Problems solved by technology

[0004] 1) With the continuous deepening of digitalization, application systems for different needs have been established, but because these systems come from different manufacturers, this has caused the problem that hospital information cannot be interconnected among various application systems, and the data is Rich, but poor knowledge, lack of effective means of information sharing among various systems, leading to the formation of information islands, hindering the process of hospital informatization

[0005] 2) After years of development and application of informatization, a large amount of data has been accumulated, but most of the data is placed on different servers in the hospital. When integrating applications, there are unclear data sources, low data quality, and heterogeneous systems. Difficulty in data integration, lack of unified standards, data information is generally shallow application, generally only analysis but not utilization, no effective closed-loop control of monitoring indicators, it is difficult to promote continuous improvement of hospital management

Images