Email this article Development of a data exchange service between software systems
- Authors: Tandalov K.D.1, Pechenin V.A.1
-
Affiliations:
- Samara University
- Issue: Vol 10, No 3 (2024): 20.11.2024
- Pages: 50-57
- Section: Articles
- Published: 20.11.2024
- URL: https://dynvibro.ru/dynvibro/article/view/28008
- DOI: https://doi.org/10.18287/2409-4579-2024-10-3-50-57
- ID: 28008
Cite item
Full Text
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.
Keywords
About the authors
Kirill D. Tandalov
Samara University
Author for correspondence.
Email: tkd186@mail.ru
Student, Research Assistant at Scientific-Research Laboratory «Artificial Intelligence in Production Systems»
Russian Federation, SamaraVadim A. Pechenin
Samara University
Email: pechenin.va@ssau.ru
Candidate of Science (Engineering), Associate Professor, Head of Scientific-Research Laboratory «Artificial Intelligence in Production Systems»
Russian Federation, SamaraReferences
- The official site of Rosbalt (2007), “O razvitii stankoinstrumental'noy promyshlennosti : tezisy doklada zamestitelya Ministra pro-myshlennosti i energetiki Rossiyskoy Federatsii A. G. Reusa na zasedanii Pravitel'stvennoy komissii po razvitiyu promyshlennosti, transporta i tekhnologiy” [On the development of the machine tool industry : abstracts of the report by Deputy Minister of Industry and Energy of the Russian Federation A. G. Reus at the meeting of the Government Commission for the Development of Industry, Transport and Technologies] [Electronic resource], available at: URL: https://www.rosbalt.ru/news/2007-08-02/o-razvitii-stankoinstrumentalnoy-promyshlennosti-3476491 (access date: 03/02/2024). (In Russian).
- Zotova, E. A. (2019), “Integration of ERP and MES systems”, Young scientist, no. 4 (242), pp. 1-3. (In Rus-sian).
- Andreev, E. B., Kutsevich, I. V. and Kutsevich, N. A. (2015), MES-sistemy: vzglyad iznutri [MES systems: a view from the inside], RTSoft, Moscow, 240 p. (In Russian).
- Ginnyatulin, R. R., Pechenina, E. Yu. and Pechenin, V. A. (2023), “The concept of software system for identi-fication of objects in the production environment”, Prospects for the development of engine building: materials of the international scientific and technical conference named after N. D. Kuznetsova, Samara National Research Universi-ty, Samara, pp. 259-260. (In Russian).
- Redmon, J, Divvala, S., Girshick, R. and Farhadi, F. (2016), “You only look once: Unified, real-time object de-tection”, 2016 IEEE Conf on Computer Vision and Pattern Recognition (CVPR), pp. 779-788.
- Redmon, J. and Farhadi, A. (2018), “YOLOv3: An Incremental Improvement”, arXiv, vol. 1804.02767.
- Simonyan, K. and Zisserman, A. (2015), “Very Deep Convolutional Networks for Large-Scale Image Recog-nition”, 3rd International Conference on Learning Representations, vol. 1409, p. 1556.
Supplementary files
