Data transformation for production planning and control systems integration

• Autorzy: Krenczyk D.
• Języki publikacji: EN

Abstrakty

EN

In this paper the method of production planning and control systems (PROEDIMS and SWZ) integration is presented. Both systems are parts of a distributed system which is thought as a replacement of large MRP / ERP systems for SMEs. This idea derived from the needs of several small and medium enterprises. In these kind of enterprises the larger stress is applied rather on technical preparation of production than tackling business problems. Integration is achieved by methods of data transformation and data mapping. The proposed data transformation interface uses neutral data formats like XML, XML schema, Extensible Stylesheet Language Transformations XSLT and XML Path Language. The functional scheme of the module for data exchange which is necessary for the interaction between the production planning module of PROEDIMS system and production orders verification system for a multiassortment, concurrent production (SWZ) has been proposed and various stages of data transformation have been discussed.

Słowa kluczowe

EN

data transformation; data mapping; PPC systems integration

• Wydawca: Wydawnictwo Wrocławskiej Rady FSNT NOT
• Czasopismo: Journal of Machine Engineering
• Rocznik: 2011
• Tom: Vol. 11, No. 1-2
• Strony: 171--180
• Opis fizyczny: Bibliogr. 13 poz., rys.

Twórcy

autor

Krenczyk D.

• Silesian University of Technology, Faculty of Mechanical Engineering, Institute of Engineering Processes Automation and Integrated Manufacturing Systems, Poland

Bibliografia

• [1] BRAY T., PAOLI J., SPERBERG-MCQUEEN C. M., MALER E., YERGEAU F. eds, Extensible Markup Language (XML) 1.0 (Fifth Edition) W3C Recommendation, 2008 http://www.w3.org/TR/2008/REC-xml- 20081126/.
• [2] CHOLEWA M., CZAJKA J., KONOPA A., 2010, The concept model of the exchange of data between systems for preparation of production and production planning (in Polish), Automatyzacja Procesów Dyskretnych. Teoria i Zastosowania (eds. Świerniak A, Krystek J.). Gliwice. 25-34.
• [3] European Commission, Annual report on EU small and medium-sized enterprises 2009. http://ec.europa.eu/enterprise/policies/sme/facts-figures-analysis/performancereview/ pdf/dgentr_annual_report2010_100511.pdf.
• [4] GAO S., SPERBERG-MCQUEEN C. M., THOMPSON H. S., eds., 2008, XML Schema Definition Language (XSD) 1.1 Part 1: Structures, World Wide Web Consortium (W3C), http://www.w3.org/TR/xmlschema11-1/.
• [5] KALINOWSKI K., SKOŁUD B., GRABOWIK C., KRENCZYK D., 2007, Computer aided technological and organizational processes planning, Proceedings of the Contributions of 15th International Scientific Conference, CO-MAT-TECH 2007, Quality Assurance Of Products, Safety Of Production And Environment, 173-176, Trnava, Slovakia.
• [6] KAY M. eds., 2007, XSL Transformations (XSLT) Version 2.0, W3C Recommendation, http://www.w3.org/TR/xslt20/.
• [7] KRENCZYK D.: The Concept of Distributed Control Procedure in Multiassortment Repetitive Production Systems. Proceedings of the International Conference TOOLS 2002, Kocovce, Słowacja, 2002.
• [8] LEE J., 2003, E-manufacturing—fundamental, tools, and transformation. Robotics and Computer Integrated Manufacturing, 19, 501–507.
• [9] LEE C.K.M., HO G.T.S., LAU H.C.W., YU, K.M., 2006, A dynamic information schema for supporting product lifecycle management. Expert Systems With Applications, 3/11, 30-40.
• [10] SKOŁUD B., KRENCZYK D., 2001, Flow Synchronisation of the Production Systems – The Distributed Control Approach. Proceedings of the 6th IFAC Workshop on Intelligent Manufacturing Systems IMS 2001, Poznań, 127–132.
• [11] SKOŁUD B, KRENCZYK D. , KALINOWSKI K., GRABOWIK C., 2010, Exchange of data in production flow control systems SWZ and KBRS (in Polish), Automatyzacja Procesów Dyskretnych. Teoria i Zastosowania (eds. Świerniak A, Krystek J.). Gliwice, 207-214.
• [12] TAO Y., HONG T.; SUN S., 2004, An XML implementation process model for enterprise applications, Computers in Industry, Elsevier Science Publishers B. V., v. 55181–196.
• [13] WANG Ch., XU L., 2008, Parameter mapping and data transformation for engineering application integration, Information Systems Frontiers Information Systems Frontiers , 10/5, 589 – 600.