Development of regional medical information system using hospital data warehouse

我们开发了医院数据仓库（DWH），用于高速搜索和统计数据的收集。我们将积累的医疗检查和治疗信息（患者基本信息/疾病/处方/注射/化验/生理/放射性射线/护理信息）与鹿儿岛大学医院信息系统（THINK）整合，设置医院DWH。本研究旨在分析变化对DPC社区医学的影响。根据DPC建立了该系统，估算了该地区大学医院住院人数占该地区病例数的比例，通过该系统可以掌握该地区大学医院卫生服务的供需关系。此外，我们的目标是增加真正的社区医疗合作，以实现数量质量。我们从病人的地址信息和邮政编码中计算出鹿儿岛的二级医疗区域类别，并将其添加到该系统中。并根据二级医疗区域，将二级医疗区域的人口构成、病床容量和老龄化率等信息加入到该系统中。本系统根据医疗行业的DPC进行成本分析。为了对该体系进行评价，我们考察了鹿儿岛在人口构成和医疗资源方面与全国的差异。此外，我们使用鹿儿岛二级保健区的人口和综合医院病床容量作为分析的修正值。通过该系统的深入分析，发现医疗资源短缺的二级保健区（寿区、熊马区）倾向于依赖鹿儿岛大学医院的MDC，而后者主要依赖MDC05循环器官、MDC06消化器官（肝癌）、MDC13血液异常、MDC14围产期。此外，鹿儿岛大学医院接收的病人比宫崎县更多，来自县的南津区和井宿区，能够描绘出提供严重医疗护理的数字，作为第三家急救医院。我们开发了医院信息系统的“可视化工具”，展示了鹿儿岛大学医院社区医学支持的实际情况。少

We developed the hospital data warehouse (DWH) which worked high-speed search and to collect the statistics. We integrated accumulated medical examination and treatment information (patient basic information / disease / prescription / injection / laboratory tests / physiology / radioactive rays / nursing information) with Kagoshima University Hospital information system (THINK) and set to hospital DWH. This study is aimed at analyzing influence of changing on community medicine in DPC. According to DPC, we build this system estimating the ratios that the inpatient of this university hospital in the number of cases in the area accounts for We can grasp the relations of the supply and demand of health care services of the university hospital in the area by this system. Furthermore, we are aimed at adding up real community medicine cooperation for quantitative quality. We added the secondary care area category of Kagoshima that we calculated from patient address information and a zip code … More to this system. and We added the information such as population composition in the secondary care area, the hospital bed capacity and aging rate according to the secondary care area to this system. We performed cost analysis according to the medical circle according to DPC with this system.For evaluation to this system, we inspected it about a difference with the whole country about population composition and medical resources of Kagoshima. Also, we used the population of the secondary care area of Kagoshima and general hospital bed capacity for a correction value of the analysis.As a result of drill down analysis by this system, it was recognized that a secondary care area (Soo district, Kumage district) where medical resources were short tended to depend on Kagoshima University hospital MDC which depended had much a MDC05 circulatory organ, a MDC06 digestive organ (liver cancer), MDC13 blood dyscrasias, MDC14 perinatal periods. Also, Kagoshima University hospital accepted the patients more than Miyazaki out of the prefecture from Nansatsu district, the Ibusuki district in the prefectures and was able to depict the figure which offered the medical care that was severe as the third emergency hospital.We developed the "visualization tool" for hospital information system, and it showed the actual situation of the community medicine support of the Kagoshima University hospital. Less