Construction method and device of medical adverse reaction data warehouse, equipment and medium

Abstract

The embodiment of the invention provides a method for constructing a medical adverse reaction data warehouse, and the method is characterized in that the method comprises the steps: obtaining medical data including drug names and adverse reaction descriptions of drugs represented by the drug names; based on a preset medical expression dictionary, processing the content of the medical data into standard medical data to obtain a standard medical data layer; mapping the standard medical data of the standard medical data layer into standard data conforming to a standard expression form to obtain a standard data layer; wherein the standard expression form at least follows E2B R3; constructing a data warehouse comprising a dimension table and a fact table which are associated according to the standard data of the standard data layer; wherein the dimension table comprises dimension data used for representing the adverse drug reaction trend, and the fact table comprises measurement data used for data statistics of the dimension data. According to the embodiment of the invention, the pharmaceutical enterprise can carry out multidimensional OLAP analysis on adverse drug reactions.

Description

technical field [0001] This specification relates to the technical field of computer data processing, and specifically relates to a construction method, device, equipment and storage medium of a medical adverse reaction data warehouse. Background technique [0002] The medical adverse reaction data is huge and is constantly being updated. Obtaining the adverse reaction trend through the medical adverse reaction data is not only computationally intensive, but also time-sensitive. In order to obtain the trend results of adverse drug reactions, pharmaceutical companies need to conduct research on each drug and then perform repetitive and large-scale calculations, which is inefficient and time-consuming. Contents of the invention [0003] In view of this, multiple embodiments of this specification are dedicated to providing a construction method, device, equipment, and storage medium of a medical adverse reaction data warehouse, which can quickly obtain multidimensional online...

AI Technical Summary

Problems solved by technology

[0002] The medical adverse reaction data is huge and is constantly being updated. Obtaining the adverse reaction trend through the medical adverse reaction data is not only computationally intensive, but also time-sensitive

In order to obtain the trend results of adverse drug reactions, pharmaceutical companies need to conduct research on each drug, and then perform repetitive and large-scale calculations, which is inefficient and time-consuming.

Images