Hospital clinical data warehouse construction method and system, electronic equipment and storage medium

Abstract

The embodiment of the invention provides a construction method and system of a hospital clinical data warehouse, electronic equipment and a storage medium, and belongs to the field of medical treatment. The method comprises the steps that all systems of a hospital are connected, data information is extracted, and basic information, doctor-seeing records, diagnosis information, doctor advice information, inspection result data, medical image data and clinical documents of a patient are integrated and stored by adopting a data warehouse technology and a data model; and establishing a data index mechanism to enable a user to retrieve and query required data information in the hospital clinical data warehouse, and encrypting the data information stored in the hospital clinical data warehouse by adopting a data encryption mode. Through the constructed hospital clinical data warehouse, clinical data resources are integrated and optimized and are continuously optimized along with the development of hospitals, so that the long-term development requirements of the hospitals are met. Powerful data support and technical guarantee are further provided for hospital operation decision making, and the operation efficiency and service quality of hospitals are remarkably improved.

Description

Technical Field

[0001] The present invention relates to the field of medical technology, and in particular to a method, system, electronic equipment and storage medium for constructing a hospital clinical data warehouse. Background Art

[0002] With the rapid development of medical informatization, hospital diagnosis and treatment data is growing rapidly. This massive amount of data holds immense value, but it also presents unprecedented challenges. Data is scattered across various business systems, such as HIS, LIS, and PACS, leading to inconsistent data standards and significant differences in statistical caliber, severely hindering data integration and efficient utilization. In daily operations, hospitals not only need to process complex clinical data but also cope with various data reporting and review tasks, which places higher demands on data consistency and accuracy.

[0003] Existing technologies use multiple data formats and communication protocols to obtain data from various business systems. Since different business systems may adopt different data formats and communication protocols, this increases the compatibility challenges. The complexity of multiple communication protocols may also lead to problems such as data transmission delays, data loss or data inconsistency. Summary of the Invention

[0004] The purpose of the embodiments of the present invention is to provide a method, system, electronic device and storage medium for constructing a hospital clinical data warehouse, which are used to fully or at least partially solve the technical problems existing in the above-mentioned prior art.

[0005] To achieve the above objectives, an embodiment of the present invention provides a method for constructing a hospital clinical data warehouse, comprising:

[0006] Connecting to the hospital information system, laboratory information system, image archiving and communication system, and electronic medical record system, and extracting data information from each system, wherein the hospital information system includes at least the patient's basic information, medical records, diagnosis information, and medical order information; the laboratory information system includes at least the patient's test result data; the image archiving and communication system includes at least the patient's medical image data; and the electronic medical record system includes at least the patient's clinical documents;

[0007] Using data warehouse technology and data models, the hospital information system includes at least the patient's basic information, medical records, diagnosis information, and medical order information; the laboratory information system includes at least the patient's test result data; the image archiving and communication system includes at least the patient's medical imaging data; and the electronic medical record system includes at least the patient's clinical documents. The data model includes the patient master index, clinical event, and observation indicator entities, as well as the relationship between the three.

[0008] A data indexing mechanism is established to enable users to retrieve and query the required data information in the hospital clinical data warehouse, and data encryption is used to encrypt the data information stored in the hospital clinical data warehouse.

[0009] Optionally, a process of integrating and storing, using data warehouse technology and data models, at least the patient's basic information, medical records, diagnosis information, and medical order information included in the hospital information system, at least the patient's test result data included in the laboratory information system, at least the patient's medical imaging data included in the image archiving and communication system, and at least the patient's clinical documents included in the electronic medical record system, includes:

[0010] Clean and convert the patient's basic information, medical records, diagnosis information, medical order information, test results, medical imaging data, and clinical documents to remove noise data and obtain a patient data set in a unified data format;

[0011] The patient data sets in the unified data format are stored in pre-planned subject areas in the hospital clinical data warehouse according to the preset logical and physical structures; wherein each subject area represents a different data type and contains related data tables and views.

[0012] Optionally, the process of encrypting the data information stored in the hospital clinical data warehouse using a data encryption method includes:

[0013] Use symmetric encryption to divide data information into multiple data blocks;

[0014] Use a predetermined key to perform multiple rounds of byte replacement, row shift, column confusion and round key addition operations on each data block, and then splice the encrypted data blocks to generate ciphertext.

[0015] Optionally, the method for constructing the hospital clinical data warehouse further includes: analyzing the data in the hospital clinical data warehouse through a data analysis method and a pre-constructed prediction model to provide clinical decision-making recommendations.

[0016] Optionally, the process of analyzing the data in the hospital clinical data warehouse through data analysis methods and providing clinical decision-making recommendations includes:

[0017] Using the exponential smoothing method in time series analysis, the time series data in the hospital clinical data warehouse are weighted averaged, with recent data given a higher weight and distant data given a lower weight. The smoothing coefficient is determined based on the higher weight of recent data and the lower weight of distant data.

[0018] Based on the smoothing coefficient, the smoothing value of recent data, and the smoothing value of long-term data, the demand for medical services in a future time period is predicted to provide suggestions for the arrangement of medical resources.

[0019] Optionally, pre-built predictive models can be used to analyze data in the hospital's clinical data warehouse to provide clinical decision-making recommendations, including:

[0020] Use the decision tree algorithm model to analyze the data in the hospital clinical data warehouse:

[0021] Perform data cleaning on the data in the hospital clinical data warehouse to obtain the target data set;

[0022] Inputting the target data set into a decision tree algorithm model and outputting the classification results of each decision tree, wherein the decision tree algorithm model performs feature selection and classification based on the principle of minimizing the Gini index;

[0023] The classification results of each decision tree are integrated to obtain the prediction results based on the data in the hospital clinical data warehouse;

[0024] Based on the prediction results, clinical decision-making recommendations are provided.

[0025] Optionally, the Gini index formula is as follows:

[0026]

[0027] Where pk represents the probability of category k appearing in the hospital clinical data warehouse dataset D.

[0028] On the other hand, the present invention also provides a system for constructing a hospital clinical data warehouse, comprising:

[0029] A system docking unit, configured to connect to a hospital information system, a laboratory information system, an image archiving and communication system, and an electronic medical record system, and extract data information from each system, wherein the hospital information system includes at least the patient's basic information, medical records, diagnosis information, and medical order information; the laboratory information system includes at least the patient's test result data; the image archiving and communication system includes at least the patient's medical imaging data; and the electronic medical record system includes at least the patient's clinical documents;

[0030] An integrated storage unit is configured to integrate and store, using data warehouse technology and a data model, at least the patient's basic information, medical records, diagnosis information, and medical order information included in the hospital information system; at least the patient's test result data included in the laboratory information system; at least the patient's medical imaging data included in the image archiving and communication system; and at least the patient's clinical documents included in the electronic medical record system; wherein the data model includes a patient master index, clinical events, and observation indicator entities, and the relationships between the three;

[0031] The index encryption unit is used to establish a data index mechanism to enable users to retrieve and query the required data information in the hospital clinical data warehouse, and to encrypt the data information stored in the hospital clinical data warehouse using a data encryption method.

[0032] On the other hand, the present invention also provides an electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned method for constructing a hospital clinical data warehouse when executing the program.

[0033] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the above-mentioned method for constructing a hospital clinical data warehouse.

[0034] The hospital's clinical data warehouse, built through the aforementioned technical solution, integrates and optimizes clinical data resources, continuously optimizing with the hospital's growth and meeting its long-term development needs. This provides strong data and technical support for the hospital's operational decisions, significantly improving its operational efficiency and service quality.

[0035] Other features and advantages of the embodiments of the present invention will be described in detail in the subsequent detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] The accompanying drawings are used to provide a further understanding of the embodiments of the present invention and constitute a part of the specification. Together with the following detailed description, they are used to explain the embodiments of the present invention, but do not constitute a limitation of the embodiments of the present invention. In the accompanying drawings:

[0037] Figure 1 This is a flowchart of a method for constructing a hospital clinical data warehouse provided by an embodiment of the present invention;

[0038] Figure 2 This is a schematic diagram of a hospital clinical data warehouse formed after hospital clinical data integration provided by an embodiment of the present invention; Figure 3The diagram is a structural diagram of a system for constructing a hospital clinical data warehouse provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0039] The following describes the specific implementation of the embodiment of the present invention in detail with reference to the accompanying drawings. It should be understood that the specific implementation described herein is only used to illustrate and explain the embodiment of the present invention and is not used to limit the embodiment of the present invention.

[0040] See Figure 1 FIG. 1 is a flowchart of a method for constructing a hospital clinical data warehouse according to an embodiment of the present invention, which includes the following steps:

[0041] Step 100: Connect to the hospital information system, laboratory information system, image archiving and communication system, and electronic medical record system, and extract data information from each system.

[0042] Among them, the hospital information system includes at least the patient's basic information, medical records, diagnosis information and medical order information, the laboratory information system includes at least the patient's test result data, the image archiving and communication system includes at least the patient's medical imaging data, and the electronic medical record system includes at least the patient's clinical documents.

[0043] It should be understood that the system also includes surgical anesthesia systems, nursing systems, intensive care management and blood transfusion management systems, etc., patients' test results data, such as blood routine, biochemical indicators, microbial test results, etc., patients' medical imaging data, such as X-rays, CT scans, MRI images, etc., and clinical documents include patients' medical records, medical records, surgical records, nursing records, etc.

[0044] Step 101: Using data warehouse technology and data models, the hospital information system includes at least the patient's basic information, medical records, diagnosis information and medical order information, the laboratory information system includes at least the patient's test result data, the image archiving and communication system includes at least the patient's medical imaging data, and the electronic medical record system includes at least the patient's clinical documents. Integration and storage.

[0045] The data model includes the patient primary index, clinical events, and observation indicator entities, as well as the relationship between the three.

[0046] Specifically, when executing step 101, the following steps may be specifically performed:

[0047] S1010: Clean and convert the patient's basic information, medical records, diagnosis information and medical order information, the patient's test result data, the patient's medical imaging data and the patient's clinical documents to remove noise data and obtain a patient data set in a unified data format.

[0048] S1011: The patient data set in the unified data format is stored in pre-planned subject areas in the hospital clinical data warehouse according to the preset logical and physical structure; wherein each subject area represents a different data type and contains related data tables and views.

[0049] Step 102: Establish a data index mechanism to enable users to retrieve and query required data information in the hospital clinical data warehouse, and use data encryption to encrypt the data information stored in the hospital clinical data warehouse.

[0050] Specifically, the process of encrypting the data information stored in the hospital clinical data warehouse using a data encryption method in step 102 includes the following steps:

[0051] S1020: Divide the data information into multiple data blocks using a symmetric encryption method.

[0052] S1021: Use a predetermined key to perform multiple rounds of byte replacement, row shift, column confusion, and round key addition operations on each data block, and concatenate the encrypted data blocks to generate ciphertext.

[0053] In some embodiments, the implementation process of the method for constructing the hospital clinical data warehouse further includes: analyzing the data in the hospital clinical data warehouse through data analysis methods and pre-built prediction models to provide clinical decision-making recommendations.

[0054] To illustrate clinical decision recommendations, when a doctor prescribes a medicine, the system can remind the doctor to avoid using drugs that may cause adverse reactions based on the patient's allergy history, liver and kidney function, and other information.

[0055] Specifically, the process of analyzing the data in the hospital clinical data warehouse through data analysis methods and providing clinical decision-making recommendations includes:

[0056] Using the exponential smoothing method in time series analysis, the time series data in the hospital clinical data warehouse are weighted averaged, with recent data given a higher weight and distant data given a lower weight. The smoothing coefficient is determined based on the higher weight of recent data and the lower weight of distant data.

[0057] Based on the smoothing coefficient, the smoothing value of recent data, and the smoothing value of long-term data, the demand for medical services in a future time period is predicted to provide suggestions for the arrangement of medical resources.

[0058] Specifically, pre-built predictive models are used to analyze data in the hospital's clinical data warehouse to provide clinical decision-making recommendations, including:

[0059] Use the decision tree algorithm model to analyze the data in the hospital clinical data warehouse:

[0060] Perform data cleaning on the data in the hospital clinical data warehouse to obtain the target data set;

[0061] Inputting the target data set into a decision tree algorithm model and outputting the classification results of each decision tree, wherein the decision tree algorithm model performs feature selection and classification based on the principle of minimizing the Gini index;

[0062] The classification results of each decision tree are integrated to obtain the prediction results based on the data in the hospital clinical data warehouse;

[0063] Based on the prediction results, clinical decision-making recommendations are provided.

[0064] More specifically, the Gini index formula is as follows:

[0065]

[0066] Where pk represents the probability of category k appearing in the hospital clinical data warehouse dataset D.

[0067] In some embodiments, data in the clinical data warehouse (CDR) can also be used to monitor and evaluate medical quality, such as statistical analysis of indicators such as the incidence of surgical complications, average length of stay, and antibiotic usage rate. For example, hospital management can use the CDR system to understand the medical quality of each department, identify problems in a timely manner, and take improvement measures. To provide data support for medical research and teaching, researchers can extract the required data from the CDR for clinical research, and students can use the CDR system to learn real clinical cases. For example, researchers can use the large amount of case data in the CDR to establish and verify disease prediction models. Through channels such as patient portals, patients are provided with query and download services for some clinical data, such as examination and test results, medical record summaries, etc., to improve patient participation and satisfaction. For example, patients can view their own examination and test reports on their mobile phones to understand their health status.

[0068] In some implementations, a user interface and interaction method may also be designed to provide user-friendly data visualization and query functions.

[0069] In some embodiments, to ensure efficient and consistent medical data management, a comprehensive set of metadata standards has been developed, covering multiple aspects. Metadata is divided into several major categories, including descriptive metadata (such as dataset titles, keywords, etc.), structural metadata (such as data models, data elements), administrative metadata (such as data creators and creation times), and technical metadata (such as data formats and transmission protocols). In terms of naming rules, the principles of consistency and readability are adopted to ensure that field names are concise and clear, and camel case naming is used to facilitate development and subsequent maintenance. In terms of data format, multiple data types such as strings, numbers, and dates and times are defined to ensure data accuracy. For example, dates use the ISO 8601 format (YYYY-MM-DD). Each metadata field is accompanied by a clear definition and description, detailing the field's purpose and data source for user understanding. In addition, coding rules will use a standardized coding system. For example, the coding of test items will be represented by the internationally unified LONIC code. This ensures data consistency while also facilitating the mutual recognition of regional test results. Constraints include required fields, value ranges, and uniqueness to maintain data integrity and accuracy.

[0070] In some embodiments, see Figure 2 As shown, a schematic diagram of a hospital clinical data warehouse formed after the integration of hospital clinical data provided by an embodiment of the present invention is provided. The data in the hospital information system (HIS) / Oracle database, laboratory information system (LIS) / SQLServer database, picture archiving and communication system (PACS) / MYSQL database, electronic medical record system (EMR) / DB2 database and other business / databases are integrated and stored in the hospital clinical data warehouse (CDR), building a unified data standard, and then providing operational decision-making, data reporting, 360-degree views, expert libraries and other applications.

[0071] See Figure 3 FIG. 1 is a schematic diagram of a system for constructing a hospital clinical data warehouse according to an embodiment of the present invention, comprising:

[0072] The system docking unit 30 is used to connect to the hospital information system, laboratory information system, image archiving and communication system, and electronic medical record system, and extract data information from each system, wherein the hospital information system includes at least the patient's basic information, medical records, diagnosis information, and medical order information; the laboratory information system includes at least the patient's test result data; the image archiving and communication system includes at least the patient's medical image data; and the electronic medical record system includes at least the patient's clinical documents;

[0073] The integrated storage unit 31 is configured to integrate and store, using data warehouse technology and a data model, at least the patient's basic information, medical records, diagnosis information, and medical order information included in the hospital information system; at least the patient's test result data included in the laboratory information system; at least the patient's medical imaging data included in the image archiving and communication system; and at least the patient's clinical documents included in the electronic medical record system; wherein the data model includes the patient master index, clinical event, and observation indicator entities, and the relationship between the three;

[0074] The index encryption unit 32 is used to establish a data index mechanism to enable users to retrieve and query required data information in the hospital clinical data warehouse, and to encrypt the data information stored in the hospital clinical data warehouse using a data encryption method.

[0075] On the other hand, the present invention also provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the steps of the method for constructing a hospital clinical data warehouse as described in any one of the above embodiments are implemented.

[0076] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the method for constructing a hospital clinical data warehouse as described in any of the above embodiments.

[0077] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0078] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the steps in the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0079] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0080] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0081] In a typical configuration, a computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0082] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0083] Computer-readable media includes permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable media does not include transitory computer-readable media (transitory media), such as modulated data signals and carrier waves.

[0084] It should also be noted that the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, commodity, or apparatus that includes a series of elements includes not only those elements but also other elements not explicitly listed, or includes elements inherent to such process, method, commodity, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, commodity, or apparatus that includes the element.

[0085] The above are merely embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present application should all be included within the scope of the claims of the present application.

Claims

1. A method for constructing a hospital clinical data warehouse, characterized in that: include: Connecting to the hospital information system, laboratory information system, image archiving and communication system and electronic medical record system, and extracting data information from each system, wherein the hospital information system at least includes the patient's basic information, medical records, diagnosis information and medical advice information, the laboratory information system at least includes the patient's test result data, the image archiving and communication system at least includes the patient's medical image data, and the electronic medical record system at least includes the patient's clinical documents; Adopting data warehouse technology and data model, the basic information, medical records, diagnosis information and medical advice information of patients included in the hospital information system, the test result data of patients included in the laboratory information system, the medical image data of patients included in the image archiving and communication system, and the clinical documents of patients included in the electronic medical record system are integrated and stored; wherein the data model includes the patient master index, clinical events and observation indicator entities and the relationship between the three; A data indexing mechanism is established to enable users to retrieve and query the required data information in the hospital clinical data warehouse, and data encryption is used to encrypt the data information stored in the hospital clinical data warehouse.

2. The method for constructing a hospital clinical data warehouse according to claim 1, characterized in that: The process of integrating and storing at least the basic information, medical records, diagnosis information and medical advice information of patients included in the hospital information system, at least the test result data of patients included in the laboratory information system, at least the medical image data of patients included in the image archiving and communication system, and at least the clinical documents of patients included in the electronic medical record system by using data warehouse technology and data models, includes: Clean and convert the patient's basic information, medical records, diagnosis information, doctor's order information, test result data, medical imaging data, and clinical documents to remove noise data and obtain a patient data set in a unified data format; The patient data sets in the unified data format are stored in pre-planned subject areas in the hospital clinical data warehouse according to preset logical and physical structures; wherein each subject area represents a different data type and contains related data tables and views.

3. The method for constructing a hospital clinical data warehouse according to claim 1, characterized in that: The process of encrypting the data information stored in the hospital clinical data warehouse by using data encryption includes: The data information is divided into multiple data blocks using symmetric encryption; Use a predetermined key to perform multiple rounds of byte replacement, row shift, column confusion and round key addition operations on each data block, and concatenate the encrypted data blocks to generate ciphertext.

4. The method for constructing a hospital clinical data warehouse according to claim 1, characterized in that: The method for constructing the hospital clinical data warehouse also includes: analyzing the data in the hospital clinical data warehouse through a data analysis method and a pre-constructed prediction model to provide clinical decision-making suggestions.

5. The method for constructing a hospital clinical data warehouse according to claim 4, characterized in that: The process of analyzing the data in the hospital clinical data warehouse through data analysis methods and providing clinical decision-making recommendations includes: Using the exponential smoothing method in time series analysis, the time series data in the hospital clinical data warehouse are weighted averaged, high weight values ​​are given to recent data, low weight values ​​are given to long-term data, and the smoothing coefficient is determined based on the high weight value of recent data and the low weight value of long-term data; Based on the smoothing coefficient, the smoothing value of recent data and the smoothing value of long-term data, the demand for medical services in a future time period is predicted to provide suggestions for the arrangement of medical resources.

6. The method for constructing a hospital clinical data warehouse according to claim 4, characterized in that: The pre-built predictive models are used to analyze the data in the hospital clinical data warehouse and provide clinical decision-making recommendations, including: Use decision tree algorithm model to analyze data in hospital clinical data warehouse: Clean the data in the hospital's clinical data warehouse to obtain the target data set; Inputting the target data set into a decision tree algorithm model, and outputting the classification results of each decision tree, wherein the decision tree algorithm model performs feature selection and division according to the principle of minimizing the Gini index; The classification results of each decision tree are integrated to obtain the prediction results based on the data in the hospital clinical data warehouse; Based on the prediction results, clinical decision recommendations are provided.

7. The method for constructing a hospital clinical data warehouse according to claim 6, characterized in that: The Gini index formula is as follows: Where pk represents the probability of category k appearing in the hospital clinical data warehouse dataset D.

8. A system for constructing a hospital clinical data warehouse, characterized in that: include: A system docking unit, used to dock with a hospital information system, a laboratory information system, an image archiving and communication system, and an electronic medical record system, and extract data information from each system, wherein the hospital information system at least includes the patient's basic information, medical records, diagnosis information, and medical advice information, the laboratory information system at least includes the patient's test result data, the image archiving and communication system at least includes the patient's medical image data, and the electronic medical record system at least includes the patient's clinical documents; An integrated storage unit is used to integrate and store at least the basic information, medical records, diagnosis information and medical advice information of patients included in the hospital information system, at least the test result data of patients included in the laboratory information system, at least the medical image data of patients included in the image archiving and communication system, and at least the clinical documents of patients included in the electronic medical record system by using data warehouse technology and data models; wherein the data model includes the patient master index, clinical events and observation indicator entities and the relationship between the three; The index encryption unit is used to establish a data index mechanism so that users can retrieve and query the required data information in the hospital clinical data warehouse, and encrypt the data information stored in the hospital clinical data warehouse using data encryption.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the steps of the method for constructing a hospital clinical data warehouse as described in any one of claims 1-5 are implemented.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method for constructing a hospital clinical data warehouse as described in any one of claims 1 to 5 are implemented.

Images