Browse > Article
http://dx.doi.org/10.7315/CADCAM.2014.103

A Method for Engineering Change Analysis by Using OLAP  

Do, Namchul (Department of Industrial and Systems Engineering, Gyeongsang National University)
Publication Information
Korean Journal of Computational Design and Engineering / v.19, no.2, 2014 , pp. 103-110 More about this Journal
Abstract
Engineering changes are indispensable engineering and management activities for manufactures to develop competitive products and to maintain consistency of its product data. Analysis of engineering changes provides a core functionality to support decision makings for engineering change management. This study aims to develop a method for analysis of engineering changes based on On-Line Analytical Processing (OLAP), a proven database analysis technology that has been applied to various business areas. This approach automates data processing for engineering change analysis from product databases that follow an international standard for product data management (PDM), and enables analysts to analyze various aspects of engineering changes with its OLAP operations. The study consists of modeling a standard PDM database and a multidimensional data model for engineering change analysis, implementing the standard and multidimensional models with PDM and data cube systems and applying the implemented data cube to core functions of engineering change management, the evaluation and propagation of engineering changes.
Keywords
Engineering changes; Engineering change analysis; Multidimensional data model; On-Line Analytic Processing (OLAP); Product Data Management (PDM); The STEP PDM schema;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Loch, C.H. and Terwiesch, C., 1999, Accelerating the Process of Engineering Change Orders: Capacity and Congestion Effects, Journal of Product Innovation Management, 16(2), pp.145-159.   DOI   ScienceOn
2 Huang, G.Q., Yee, W.Y. and Mak, K.L., 2001, Development of a Web-based System for Engineering Change Management, Robotics and Computer-Integrated Manufacturing, 17(3), pp.255-267.   DOI   ScienceOn
3 Kocar, V. and Akgunduz, A., 2010, ADVICE: A Virtual Environment for Engineering Change Management, Computers in Industry, 61, pp.15-28.   DOI   ScienceOn
4 Hamraz, B., Caldwell, N.H.M. and Clarkson, P.J., 2013, A Matrix-Calculation-Based Algorithm for Numerical Change Propagation Analysis, IEEE Transactions on Engineering Management, 60(1), pp.186-198.   DOI   ScienceOn
5 PDM Implementer Forum, 2002, Usage Guide for the STEP PDM Schema V 1.2, PDM Implementer Forum.
6 Herden, O., 2000, A Design Methodology for Data Warehouses, Proceedings of Doctoral Workshop at CAiSE'00, edited by Hinze, A and Hommes, BJ, Stockholm.
7 Do, N., 2013, Developing an Introductory Training Course to PLM, Transactions of the Society of CAD/CAM Engineers, 18(1), pp.28-35.   과학기술학회마을   DOI   ScienceOn
8 MySQL, http://mysql.com, 2013.
9 Fei, G., Gao, J, Owodunni, O. and Tang, X., 2011, A Method for Engineering Design Change Analysis Using System Modeling and Knowledge Management Techniques, International Journal of Computer Integrated Manufacturing, 24(6), pp.535-551.   DOI   ScienceOn