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.

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.

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.

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.