J Korean Soc Med Inform.  2004 Sep;10(3):243-251.

Development of Decision-Support System for Patient Affairs Management and Building of Data Mart

Affiliations
  • 1Department of Computer Engineering, Chonnam National University, Korea. osmanna99@hanmail.net

Abstract


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.

Keyword

OLTP; OLAP; ROLAP; Data-mart; Decision-Support System

MeSH Terms

Consultants
Dataset
Humans
Marketing
Medical Records
Sensitivity and Specificity
Solar System
Full Text Links
  • JKSMI
Actions
Cited
CITED
export Copy
Close
Share
  • Twitter
  • Facebook
Similar articles
Copyright © 2024 by Korean Association of Medical Journal Editors. All rights reserved.     E-mail: koreamed@kamje.or.kr