A study about development of an agent risk evaluation system using a data warehouse for pharmacoepidemiology

点击翻译按钮获取中文摘要

By this study, we developed a pharmacoepidemiology data warehouse system as a support system to evaluate a effect and risk of agent after marketing. This system integrated information of patient, diagnosis, prescription, injection, clinical laboratory, nursing and operation system in Kagoshima University hospital information system, and we could do analysis of medication history and a test result by this system quickly and easily. To evaluated efficiency of evaluation support features of effect and a risk of agent of this system, we extracted data of the patient who received prescription of medicine that was written as not prescribing it for a person of advanced age in a Merck manual. We extracted data from a pharmacoepidemiology data warehouse with an OLAP (On Line Analytical Processing) tool called BusinessObjects by a client PC.As a result, we were able to detect several prescription examples which fitted combination warning to a person of advanced age. The extract time of data was around 2 minutes for about 30 seconds or more. Because we did not interrupt business system even if we processed it with a pharmacoepidemiology data warehouse, we were able to execute data extraction in business time. These results seemed that the pharmacoepidemiology data warehouse was extremely superior in easy operability and a performance in data extract in comparison with business system. This system was useful as an evaluation support tool of effect and a risk of agent.