Development of a templating program for data management automation
Abstract
Background. Integrated development environments, have limited ability to automate repetitive tasks, which leads to increased development time. Creating a software templating tool solves this problem by automating routine processes and reducing errors.
Purpose. Development of a program providing automation of creation and editing of template files, their integration with the database, as well as support for viewing the content of the files.
Method and methodology. Using Java programming language for program implementation and PostgreSQL for data storage. The approach was based on the use of universal tools to ensure compatibility and scalability.
Results. This paper details the development of a templateizer program that supports creating, editing, viewing, and updating template files. Templates are stored in PostgreSQL, which provides centralized data management. The program supports the principle of modularity, which ensures the expansion of the program functionality by adding the necessary flags. In this case, the program code will require minimal intervention due to the changes made.
Scope of the results. The solution can be used in industrial automation, educational testbeds and in the development of projects that require standardization of processes.
Conclusions. The developed program significantly reduces the development time and increases the accuracy of repetitive operations when creating programs in the integrated development environment for programmable logic controllers.
EDN: HLPOVZ
Downloads
References
Список литературы
Бондаренко, И. С. (2019). Базы данных: создание баз данных в среде SQL Server. Лабораторный практикум. Москва: Изд. Дом НИТУ «МИСиС». 39 с.
Линец, Г. И., & Братченко, Н. Ю. (2021). Базы данных. Учебник. Ставрополь: Изд-во СКФУ. 170 с.
Фиайли, К. (2023). SQL. Руководство для использования с любыми SQL СУБД. Учебное пособие (2-е изд.; пер. с англ. А. В. Хаванова). Москва: ДМК Пресс. 454 с.
Гайнанова, Р. Ш. (2019). Разработка приложений в Visual C для работы с базой данных MS SQL SERVER 2012. Учебно-методическое пособие. Казань: КНИТУ. 84 с.
Ёсу, М. (2021). Принципы организации распределенных баз данных. Учебник (пер. с англ. А. А. Слинкина). Москва: ДМК Пресс. 672 с.
Харрингтон, Д. (2023). Проектирование объектно-ориентированных баз данных. Практическое руководство (2-е изд.; пер. с англ. А. А. Слинкина). Москва: ДМК Пресс. 273 с.
Льюис, Д. (2023). Ядро Oracle. Внутреннее устройство для администраторов и разработчиков баз данных. Практическое руководство (2-е изд.; пер. с англ. А. Н. Киселева). Москва: ДМК Пресс. 373 с.
Мартишин, С. А., Симонов, В. Л., & Храпченко, М. В. (2024). Базы данных. Практическое применение СУБД SQL и NoSQL типа для проектирования информационных систем. Учебное пособие. Москва: ФОРУМ: ИНФРА-М. 368 с.
Мартишин, С. А., Симонов, В. Л., & Храпченко, М. В. (2022). Базы данных: проектирование и разработка информационных систем с использованием СУБД MySQL и языка Go. Учебное пособие. Москва: ИНФРА-М. 325 с. https://doi.org/10.12737/1830834
Митин, А. И. (2020). Работа с базами данных Microsoft SQL Server: сценарии практических занятий. Учебно-методическое пособие. Москва: Директ-Медиа. 143 с.
Amin Al Ka'bi. (2021). Management of energy consumption using programmable logic controllers (PLCs). Proceedings on Engineering Sciences, 3(3), 267–272. https://doi.org/10.24874/pes03.03.003
Walters III, E. G., & Bryla, E. J. (2016). The impact of PLC program architecture on production line efficiency: Case study of a control system rewrite. Machines, 4(2), 13. https://doi.org/10.3390/machines4020013
Martin A. Sehr et al. (2024). Programmable Logic Controllers in the context of industry 4.0. IEEE Journals & Magazine. Получено с https://ieeexplore.ieee.org/document/9134804
Tiago Cruz et al. (2024). Virtualizing Programmable Logic Controllers: toward a convergent approach. IEEE Journals & Magazine. Получено с https://ieeexplore.ieee.org/document/7564414
Zheng Yang et al. (2021). PLCrypto: A symmetric cryptographic library for programmable logic controllers. IACR Transactions on Symmetric Cryptology, 2021(3), 170–217. https://doi.org/10.46586/tosc.v2021.i3.170-217
References
Bondarenko, I. S. (2019). Databases: Creating databases in SQL Server environment. Laboratory manual. Moscow: MISiS Publishing House. 39 p.
Linec, G. I., & Bratchenko, N. Y. (2021). Databases. Stavropol: SKFU Publishing House. 170 pp.
Fiayli, K. (2023). SQL: User Guide for Any SQL DBMS (2nd ed.; translated by A. V. Khavanov). Moscow: DMK Press. 454 p.
Gainanova, R. Sh. (2019). Application Development in Visual C++ for Working with MS SQL Server 2012 Database. Tutorial. Kazan: KNITU. 84 p.
Yo, M. (2021). Principles of Distributed Database Organization (translated by A. A. Slinkin). Moscow: DMK Press. 672 p.
Harrington, D. (2023). Object-Oriented Database Design: Practical Guide (2nd ed.; translated by A. A. Slinkin). Moscow: DMK Press. 273 p.
Lewis, D. (2023). Oracle Kernel: Internal Workings for DBAs and Developers (2nd ed.; translated by A. N. Kiselev). Moscow: DMK Press. 373 p.
Martishin, S. A., Simonov, V. L., & Khrapchenko, M. V. (2024). Databases: Practical Application of SQL and NoSQL DBMS for Information Systems Design. Moscow: Forum INFRA-M. 368 p.
Martishin, S. A., Simonov, V. L., & Khrapchenko, M. V. (2022). Databases: Design and Development of Information Systems Using MySQL DBMS and Go Programming Language. Moscow: INFRA-M. 325 pp. https://doi.org/10.12737/1830834
Mitin, A. I. (2020). Working with Microsoft SQL Server Databases: Practical Exercise Scenarios. Moscow: Direct-Media. 143 p.
Amin Al Ka'bi. (2021). Management of energy consumption using programmable logic controllers (PLCs). Proceedings on Engineering Sciences, 3(3), 267–272. https://doi.org/10.24874/pes03.03.003
Walters III, E. G., & Bryla, E. J. (2016). The impact of PLC program architecture on production line efficiency: Case study of a control system rewrite. Machines, 4(2), 13. https://doi.org/10.3390/machines4020013
Martin A. Sehr et al. (2024). Programmable Logic Controllers in the context of Industry 4.0. IEEE Journals & Magazine. Retrieved from https://ieeexplore.ieee.org/document/9134804
Tiago Cruz et al. (2024). Virtualizing Programmable Logic Controllers: toward a convergent approach. IEEE Journals & Magazine. Retrieved from https://ieeexplore.ieee.org/document/7564414
Zheng Yang et al. (2021). PLCrypto: A symmetric cryptographic library for programmable logic controllers. IACR Transactions on Symmetric Cryptology, 2021(3), 170–217. https://doi.org/10.46586/tosc.v2021.i3.170-217
Abstract views: 52
Copyright (c) 2025 Gulnara A. Gareeva, Aigul G. Faizullina, Asiya A. Mirsaitova, Zulfina Sh. Aglyamova, Nuriya R. Zakirova
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
