Title :
Online Slicing Analysis in Adverse Drug Reaction Data Warehouse
Author :
Xiuzhen Feng ; Xiaohong He ; Bianling Feng
Author_Institution :
Sch. of Econ. & Manage., Beijing Univ. of Technol., Beijing, China
Abstract :
To analyze large quantity of information in medication with scientific technique and to provide decision supports for doctors, we set up the research on Adverse Drug Reactions (ADRs) by constructing a multidimensional data warehouse. Adopted SQL Server 2005 business intelligence tools, we extracted, transformed and loaded the data from spontaneous reporting system (SRSs) of ADRs to the data warehouse, and realized online slice analysis. The result showed that in this way we could ADRs from different views, which provided a new way for analyzing and evaluating adverse drug reaction.
Keywords :
SQL; competitive intelligence; data warehouses; decision support systems; medical information systems; ADRs; SQL Server 2005 business intelligence tools; adverse drug reaction data warehouse; decision supports; medication information; multidimensional data warehouse; online slicing analysis; scientific technique; spontaneous reporting system; Business; Data mining; Data models; Data warehouses; Databases; Drugs; Educational institutions; adverse drug reactions (ADRs); data warehouse; multidimensional data model; slicing analysis;
Conference_Titel :
Network-Based Information Systems (NBiS), 2012 15th International Conference on
Conference_Location :
Melbourne, VIC
Print_ISBN :
978-1-4673-2331-4
DOI :
10.1109/NBiS.2012.22
