Integration of IT Systems Supporting Production Management
Purpose: The main purpose of this paper was to present the possibilities of integration of IT systems supporting the management of a production company on the strategic, tactical and operational level. Design/methodology/approach: The paper discusses the definition of the concept of systems integration and reviews the existing methods of integration at the level of data and processes. Activities that contribute to the ordering of data sets and increasing the effectiveness of infor- mation use are also presented. Findings: This paper presents a case of vertical integration of systems. The strategic level of management was represented by the ERP class system, the tactical level was supported by the MES system, while on the executive (operational) level the author used the SCADA system. Functional connections of ERP-MES-SCADA systems were discussed and conditions and requirements related to their integration were presented. Moreover, problems related to data exchange were described. Research limitations/implications: The author of the paper pointed out that the requirements related to the frequency and scope of data synchronization are an extremely important element of the process of designing communication systems integrating industrial automation devices with database IT systems. It is also necessary to grant access rights to the integration mechanisms in order to modify or audit them. Moreover, the effectiveness of the solution is affected by the changes introduced in the engines of the integrated databases, as they often cause the need to modify the integration mechanism, while the use of dedicated solutions is associated with the risk of high maintenance costs. Practical implications: The paper indicates that the integration of systems is particularly important for manufacturing companies. It provides a platform for cooperation between internal units, enabling ongoing monitoring of manufacturing processes, and predisposes the organization to engage in integrated supply chains, resulting in an increase in the scope of cooperation and the scope of the company's activity. Originality/value: Undoubtedly, an original element of the paper is the presentation of data exchange schemes between ERP-MES and MES-SCADA systems. (original abstract)
- 1. Alsene, E. (1999). The computer integration of the enterprise. IEEE Transaction on Engineering Management, 46(1), 26-35, doi: 10.1109/17.740033.
- 2. Batini, C., Lenzerini, M., Navathe, S.B. (1986). A comparative analysis of methodologies for database schema integration. ACM Computing Surveys, 18(4), 323-364, doi: 10.1145/27633.27634.
- 3. Giachetti, R.E. (2004). A framework to review the information integration of the enterprise. International Journal of Production Research, 42(6), 1147-1166, doi: 10.1080/ 00207540310001622430.
- 4. Godinez, M., Hechler, E., Koening, K., Lockwood, S., Oberhofer, M., Schroeck, M. (2010). The art of enterprise information architecture. A systems-based approach for unlocking business insight. New Jersey: IBM Press Pearson.
- 5. Greefhorst, D., Proper, E. (2011). Architecture principles, The cornerstones of enterprise architecture. Berlin: Springer-Verlag.
- 6. Henderson, J.C., Venkatraman, N. (1999). Strategic alignment: Leveraging information technology for transforming organizations. IBM Systems Journal, 38(2-3), 472-484, doi: 10.1147/SJ.1999.5387096.
- 7. Kosanke, K., Vernadat, F., Zelm, M. (1999). CIMOSA: enterprise engineering and integration. Computer and Industry, 40(2-3), 83-97, doi: 10.1016/S0166-3615(99)00016-0.
- 8. Lim, S.H., Juster, N., de Pennington, A. (1997). Enterprise modelling and integration. A taxonomy of seven key aspects. Computers and Industry, 34(3), 339-359, doi: 10.1016/S0166-3615(97)00069-9.
- 9. Luftman, J. (2003). Assessing IT-Business Alignment. Brown C.V., Topi H. (eds.) IS management handbook, 7-20. London: Auerbach Publications, doi: 10.1201/ 97814200313-93.ch1.
- 10. Mejabi, O.O., Singh, N. (1997). A framework for enterprise-wide integration. Computer Integrated Manufacturing, 10(1-4), 212-220, doi: 10.1080/095119297131318.
- 11. Milewska, E. (2016). Wdrożenie hybrydowej metody sterowania produkcją dyskretną. In: R. Knosala (ed.), Innowacje w zarządzaniu i inżynierii produkcji (pp. 759-767). Opole: Oficyna Polskiego Towarzystwa Zarządzania Produkcją.
- 12. Milewska, E. (2017). IT systems supporting the management of production capacity introduction. Management Systems in Production Engineering, 1(25), 60-67, doi: 10.1515/ mspe-2017-0009.
- 13. Nugent, E.J., Hamblin, D.J. (1996). Improved methodologies for vertical integration research. Integrated Manufacturing Systems, 7(1), 16-28, doi: 10.1108/ 09576069610108462.
- 14. Petrie, C.J. (1992). Enterprise integration modelling. Proceedings of the First International Conference on Enterprise Integration, Cambridge: MA.
- 15. Reich, B.H., Benbasat, I. (2000). Factors that influence the social dimension of alignment between business and information technology objective. MIS Quarterly, 24(1), 81-113, doi: 10.2307/3250980.
- 16. Salmans, B. (2010). EA maturity models. In: L. Kappelman (Ed.), The SIM Guide to Enterprise Architecture. Boca Raton: CRC Press, 89-96.
- 17. Truman, G.E. (1998). A discrepancy-based measurement approach for data integration. Journal of Organization Computing and Electronic Commerce, 8(3), 169-193, doi: 10.1207/s15327744joce0803_1.
- 18. Vernadat, F.D. (1996). Enterprise modelling and integration. London: Chapman and Hall.