Year: 2024
Type: article
Abstract: This article presents the development of a service information model for data exchange between ERP and MES systems used for planning and control of production processes. The purpose of the service is the efficient transfer and structuring of information between databases in the production process, as well as control of operations through the user interface. This approach allows for the integration of various external software systems, which is an urgent task in the field of automation and control of production processes. The service was implemented in Python using SQLAlchemy to work with PostgreSQL databases. The graphical interface of the service allows you to edit the required JSON template, used for working with databases. Testing was carried out on two databases for a system for monitoring the movement of parts during the production process, confirming the functionality and reliability of the service.
Authors: Kirill D. Tandalov, Vadim A. Pechenin
Institutions: Samara National Research University, Samara University
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: diamond
OpenAlex ID: W4404595224