J Korean Soc Med Inform Search


Healthc Inform Res > Volume 10(3); 2004 > Article
Journal of Korean Society of Medical Informatics 2004;10(3):243-251.
DOI: https://doi.org/10.4258/jksmi.2004.10.3.243    Published online September 30, 2004.
Development of Decision-Support System for Patient Affairs Management and Building of Data Mart
Do Geyong Kim, Seong Mi Park, Young Ki Cheong, Bae Ho Lee
Department of Computer Engineering, Chonnam National University, Korea.

OBJECTIVE: A purpose of this study was developing the Decision-Support Patient affairs management and building of Data-mart for individually specified department. Because it had a OLTP system where we were researching the hospital. It can not be analyzied variously because the data for the management, accounts, patient affairs and medical record were changing monthly/annually in conditions. also it can not have the specificity of the hospital management information.

METHODS: The Data Set that used for analysis process was examined with the patient's Database for a year. They were in hospital where locates in Sun Cheon. For developing patient affairs management program, The Microsoft Visual Basic 6.0 was used. and A analysis method of ROLAP which is based on Oracle relation Database was used for general analysis of required works.

RESULTS: The patient affairs Data-mart and Decision-Support System was built with the main results of the study. Those took advantage of the analysis for the each department's revenue and doctor's actual results, it also can compare the patient's hospital using frequency. With the analyzied results, each department can have their own special marketing. They can offer to the resistants a lecture, consultant and free service for the health.

CONCLUSION: The management, the accounts, patient affairs and the medical record can have been analyzied various changing through the study. The host System had enormous volume, so it takes lots of times what they want to inquire. The host system usually took at night because of low transaction occurrence. The new system which was built with Data-mart had been improved the problem a lot.

Key Words: OLTP, OLAP, ROLAP, Data-mart, Decision-Support System


Browse all articles >

Editorial Office
1618 Kyungheegung Achim Bldg 3, 34, Sajik-ro 8-gil, Jongno-gu, Seoul 03174, Korea
Tel: +82-2-733-7637, +82-2-734-7637    E-mail: hir@kosmi.org                

Copyright © 2024 by Korean Society of Medical Informatics.

Developed in M2community

Close layer
prev next