Development of a templating program for data management automation

  • Gulnara A. Gareeva Kazan National Research Technical University named after A.N. Tupolev-KAI https://orcid.org/0000-0002-8539-4541
  • Aigul G. Faizullina Kazan Federal University Naberezhnochelninsk Institute
  • Asiya A. Mirsaitova Kazan Innovation University named after V.G. Timiryasov
  • Zulfina Sh. Aglyamova Kazan Innovation University named after V.G. Timiryasov
  • Nuriya R. Zakirova Naberezhnochelninsk State Pedagogical University
Keywords: automation, template, KincoBuilder, Java, PostgreSQL, programmable logic controllers, industrial 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

Download data is not yet available.

Author Biographies

Gulnara A. Gareeva, Kazan National Research Technical University named after A.N. Tupolev-KAI

Candidate of Pedagogical sciences, Associate professor, Head of the Department of Information Systems

Aigul G. Faizullina, Kazan Federal University Naberezhnochelninsk Institute

Senior Lecturer of the Department of Business Informatics and Mathematical Methods in Economics

Asiya A. Mirsaitova, Kazan Innovation University named after V.G. Timiryasov

Senior Lecturer, Department of Higher Mathematics and Information Technologies

Zulfina Sh. Aglyamova, Kazan Innovation University named after V.G. Timiryasov

Candidate of Pedagogical Sciences, Associate Professor of the Department of Higher Mathematics, Modeling and Data Analysis

Nuriya R. Zakirova, Naberezhnochelninsk State Pedagogical University

Candidate of Pedagogical Sciences, Associate Professor, Department of Informatics and Computational Mathematics

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: 46
PDF Downloads: 22

Published
2025-03-31
How to Cite
Gareeva, G., Faizullina, A., Mirsaitova, A., Aglyamova, Z., & Zakirova, N. (2025). Development of a templating program for data management automation. Transportation and Information Technologies in Russia, 15(1), 111-131. https://doi.org/10.12731/2227-930X-2025-15-1-351
Section
Original Articles