Korean Journal of Computational Design and Engineering (한국CDE학회논문집)

Society for Computational Design and Engineering (한국CDE학회)
권호 표지
DOI QR코드

DOI QR Code

A Method for Engineering Change Analysis by Using OLAP

OLAP를 이용한 설계변경 분석 방법에 관한 연구

  • Do, Namchul (Department of Industrial and Systems Engineering, Gyeongsang National University)
  • 도남철 (경상대학교 산업시스템공학부, ERI)
  • Received : 2013.11.06
  • Accepted : 2014.03.17
  • Published : 2014.06.01
Download PDF
⟨ Previous Next ⟩

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

References

  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. https://doi.org/10.1016/S0737-6782(98)00042-3
  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. https://doi.org/10.1016/S0736-5845(00)00058-2
  3. Kocar, V. and Akgunduz, A., 2010, ADVICE: A Virtual Environment for Engineering Change Management, Computers in Industry, 61, pp.15-28. https://doi.org/10.1016/j.compind.2009.05.008
  4. 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. https://doi.org/10.1080/0951192X.2011.562544
  5. 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. https://doi.org/10.1109/TEM.2012.2203307
  6. PDM Implementer Forum, 2002, Usage Guide for the STEP PDM Schema V 1.2, PDM Implementer Forum.
  7. Herden, O., 2000, A Design Methodology for Data Warehouses, Proceedings of Doctoral Workshop at CAiSE'00, edited by Hinze, A and Hommes, BJ, Stockholm.
  8. Do, N., 2013, Developing an Introductory Training Course to PLM, Transactions of the Society of CAD/CAM Engineers, 18(1), pp.28-35. https://doi.org/10.7315/CADCAM.2013.28
  9. MySQL, http://mysql.com, 2013.