Choe Seong Man , Yu Cheol Jung , Jang Og Bae

The KIPS Transactions:PartD, Vol. 11, No. 1, pp. 183-194, Feb. 2004
10.3745/KIPSTD.2004.11.1.183,   PDF Download:

Abstract

The existing management job for research expenses has been divided into three parts : budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step is requested. And another problem that it is difficult to tell what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transposts, tranforms and loads the data. Information Integration agent reduces a user´s efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user´s requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desiered analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

Statistics
Cite this article