Construction of OLAP system for secondary use of medical information

• Project/Area Number: 24790502
• Research Category: Grant-in-Aid for Young Scientists (B)
• Allocation Type: Multi-year Fund
• Research Field: Medical sociology
• Research Institution: The University of Tokushima
• Principal Investigator: TAMAKI Yuh 徳島大学, 大学病院, 助教 (40563987)
• Project Period (FY): 2012-04-01 – 2015-03-31
• Project Status: Completed (Fiscal Year 2014)
• Budget Amount: ¥4,680,000 (Direct Cost: ¥3,600,000、Indirect Cost: ¥1,080,000); Fiscal Year 2014: ¥650,000 (Direct Cost: ¥500,000、Indirect Cost: ¥150,000); Fiscal Year 2013: ¥1,040,000 (Direct Cost: ¥800,000、Indirect Cost: ¥240,000); Fiscal Year 2012: ¥2,990,000 (Direct Cost: ¥2,300,000、Indirect Cost: ¥690,000)
• Keywords: 二次利用 / OLAP / BI / 糖尿病 / KVS / EHR

Outline of Final Research Achievements

In this study, I built the On-Line Analysis Processing (OLAP) system which analyzed accumulated medical information into a hospital information system, an electronic health record system. The user interface of the OLAP system can understand operation visually and can operate it easily. Even the person who does not wear a programming skill enables data analysis easily.
Using a built OLAP system, I implemented the dashboard which classified cases in each treatment pattern and evaluated an episode of care and evaluated it. In this way, I realized the system infrastructure which made medical information analyzable easily.