Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment


KIPS Transactions on Software and Data Engineering, Vol. 11, No. 1, pp. 183-194, Jan. 2004
10.3745/KIPSTD.2004.11.1.183, Full Text:

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
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
C. S. Man, Y. C. Jung and J. O. Bae, "Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment," KIPS Journal D (2001 ~ 2012) , vol. 11, no. 1, pp. 183-194, 2004. DOI: 10.3745/KIPSTD.2004.11.1.183.

[ACM Style]
Choe Seong Man, Yu Cheol Jung, and Jang Og Bae. 2004. Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment. KIPS Journal D (2001 ~ 2012) , 11, 1, (2004), 183-194. DOI: 10.3745/KIPSTD.2004.11.1.183.