DOI QR코드

DOI QR Code

Development of Collaborative Process Warehouse for Analyzing Performance of Manufacturing Collaboration

제조협업 성과분석을 위한 협업 프로세스 웨어하우스 개발

  • Kim, Kyu-Ri (Department of Industrial and Management Systems Engineering, Kyung Hee University) ;
  • Kim, Ae-Kyung (Department of Industrial and Management Systems Engineering, Kyung Hee University) ;
  • Kim, Sang-Kuk (Department of Industrial and Management Systems Engineering, Kyung Hee University) ;
  • Jung, Jae-Yoon (Department of Industrial and Management Systems Engineering, Kyung Hee University)
  • 김규리 (경희대학교 산업경영공학과) ;
  • 김애경 (경희대학교 산업경영공학과) ;
  • 김상국 (경희대학교 산업경영공학과) ;
  • 정재윤 (경희대학교 산업경영공학과)
  • Received : 2011.12.09
  • Accepted : 2012.02.06
  • Published : 2012.03.01

Abstract

Most manufacturing companies participate in various types of active collaboration to enhance competitive advantages in their arenas. In this paper, we introduce a data warehouse system that is designed for manufacturing collaboration. Just as enterprise information systems, collaboration support systems also need functions of performance measurement and monitoring. For this reason, we devise a new approach to measuring and evaluating performance of manufacturing collaboration. Specifically, we first present a concept of process warehouses for manufacturing collaboration. Next, we design a data schema of collaborative process warehouses to store and monitor collaboration performances. Finally, we implement a prototype system to support performance management of manufacturing collaboration. The proposed system can be used to effectively maintain and continuously improve collaboration in manufacturing industry.

Keywords

References

  1. Cao, M. and Zhang, Q. (2011), Supply chain collaboration : Impact on collaborative advantage and firm performance, Journal of Operations Management, 29(3), 163-180. https://doi.org/10.1016/j.jom.2010.12.008
  2. Dori, D., Feldman, R., and Strum, A. (2008), From conceptual models to schemata : An object-process-based data warehouse construction method, Information Systems, 33(6), 567-593 https://doi.org/10.1016/j.is.2008.02.002
  3. Fagerstrom, F. and Jackson, M. (2002), Efficient collaboration between main and sub-suppliers, Computers in Industry, 49(1), 25-35. https://doi.org/10.1016/S0166-3615(02)00056-8
  4. Forme, F. G., Genoulaz, V. B. and Campane, J. P. (2007), A framework to analyse collaborative performance, Computers in Industry, 58(7), 687-697. https://doi.org/10.1016/j.compind.2007.05.007
  5. Gopalkrishnan, G., Li, Q. and Karlapalem, K. (1999), Star/Snow-Flake Schema Driven Object-Relational Data Warehouse Design and Query Processing Strategies, Lecture Notes in Computer Science, 1676, 180-194.
  6. Huang, S.-M., Chou, T.-H., and Seng, J.-L. (2007), Data warehouse enhancement : A semantic cube model approach, Information Science, 177(1), 2238- 2254. https://doi.org/10.1016/j.ins.2006.12.022
  7. Mazon, J.-N. and Truillo, J. (2008), An MDA approach for the development of data warehouse, Decision Support Systems, 45(1), 41-58. https://doi.org/10.1016/j.dss.2006.12.003
  8. Ming, X. G., Yan, J. Q., Lu, W. F., and Ma, D. Z. (2011), Technology Solutions for Collaborative Product Lifecycle Management-Status Review and Future Trend, Current Engineering : Research and Applications, 13(4), 311-319.
  9. Mul. M., Alons, P., Velde, P., Konings, I., Bakker, J., and Hazelzet, J. (2012), Development of a clinical data warehouse from an intensive care clinical information system, Computer Methods and Programs in Biomedicine, 105(1), 22-30. https://doi.org/10.1016/j.cmpb.2010.07.002
  10. Panetto, H. and Molina, A. (2008), Enterprise integration and interoperability in manufacturing systems : Trends and issues, Computers in Industry, 59(7), 641- 646. https://doi.org/10.1016/j.compind.2007.12.010
  11. Pardillo, J. and Mazon J.-N. (2012), Model-driven development of OLAP metadata for relational data warehouse, Computer Standards and Interfaces, 34(1), 189-202. https://doi.org/10.1016/j.csi.2011.08.001
  12. Sanders, N. R. (2007), An empirical study of the impact of e-business technologies on organizational collaboration and performance, Journal of Operations Management, 25(6), 1332-1347. https://doi.org/10.1016/j.jom.2007.01.008
  13. Schneider, M. (2008), A general model for the design of data warehouses, International Journal of Production Economics, 112(1), 309-325. https://doi.org/10.1016/j.ijpe.2006.11.027
  14. Vachon, S. and Klassen R. D. (2008), Environmental management and manufacturing performance : The role of collaboration in the supply chain, International Journal of Production Economics, 111(2), 299-315. https://doi.org/10.1016/j.ijpe.2006.11.030