Browse > Article

Development of Data Warehouse Systems to Support Cost Analysis in the Ship Production  

Hwang, Sung-Ryong (Research Institute, Shinhan Machinery)
Kim, Jae-Gyun (School of Industrial Engineering, University of Ulsan)
Jang, Gil-Sang (Department of Imformation Systems, University of Dongguk)
Publication Information
IE interfaces / v.15, no.2, 2002 , pp. 159-171 More about this Journal
Abstract
Data Warehouses integrate data from multiple heterogeneous information sources and transform them into a multidimensional representation for decision support applications. Data warehousing has emerged as one of the most powerful tools in delivering information to users. Most previous researches have focused on marketing, customer service, financing, and insurance industry. Further, relatively less research has been done on data warehouse systems in the complex manufacturing industry such as ship production, which is characterized complex product structures and production processes. In the ship production, data warehouse systems is a requisite for effective cost analysis because collecting and analysis of diverse and large of cost-related(material/production cost, productivity) data in its operational systems, was becoming increasingly cumbersome and time consuming. This paper proposes architecture of the data warehouse systems to support cost analysis in the ship production. Also, in order to illustrate the usefulness of the proposed architecture, the prototype system is designed and implemented with the object of the enterprise of producing a large-scale ship.
Keywords
data warehouse; data mart; decision support systems; cost analysis; ship industry;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Brodda, J.(1991), Shipyard Modeling-An Approach to a Comprehensive Understanding of Functions and Activities, Journal of Ship Production, 7(2), 79-93
2 Hatchuel, A., Saidi-Kabeche, D. and Sardas, J. C.(1997), Towards a New Planning and Scheduling Approach for Multistage Production Systems, International Journal of Production Research, 35(3), 867-886
3 Hwang, S. R.(1999), Unification of BOM and Routings for ClM systems in Hybrid MTO/ETO Environments, Ph.D. Dissertation, University of Ulsan
4 Oracle (1997), Data Warehouse Concept Paper, Oracle Korea
5 Kimball, R.(1996), Data Warehouse Toolkit, John Willy & Sons
6 Peng, T. K. and Trappey, A.J.C.(1998), Step Toward STEP- Compatible Engineering Data Management : The Data Models of Product Structure and Engineering Change, Robotics and Computer-Integrated Manufacturing, 14(2), 89-109
7 Park, D.J.and Hwang, I. K.(1999), A Study on the Design of Data Mart for Manufacturing Decision Making, journal of Korean Institute of Plant Engineering, 4(1),35-47,March
8 Ju, H.J. and Han,G.J.(1999), A Study on the Implementation Method of Data Warehouse using CASE Tool, journal of Korean Institute of office Automation, 1(1), 119-130
9 Inman, W. H. (1996), Building the Data Warehouse, 2nd Edition, John Willy and Sons
10 Huang,G. Q. and Mak,K I. (1997), The DFX Shell: A Generic Framework for Developing Design for XTools, Robotics & Computer-Integrated Manufacturing, 13(3), 271-280
11 Yankee Group(1998), Data Marts for Users of ERP Solutions, Enterprise Application Report, 3(1), Feb
12 Wade, M., Koenig, P.C.and Karaszewski, Z.J. etal.(1997), Mid-Term Seallift Technology Development Profram: Design for Production R&D for Seallift Ship Applications, journal Ship Production, 13(1), 57-73