Development of a templating program for data management automation
- Authors: Gareeva G.A.1, Faizullina A.G.2, Mirsaitova A.A.3, Aglyamova S.Z.3, Zakirova N.R.4
-
Affiliations:
- Kazan National Research Technical University named after A.N. Tupolev-KAI
- Kazan Federal University Naberezhnochelninsk Institute
- Kazan Innovation University named after V.G. Timiryasov
- Naberezhnochelninsk State Pedagogical University
- Issue: Vol 15, No 1 (2025)
- Pages: 111-131
- Section: Articles
- Published: 31.03.2025
- URL: https://journals.rcsi.science/2328-1391/article/view/298758
- DOI: https://doi.org/10.12731/2227-930X-2025-15-1-351
- EDN: https://elibrary.ru/HLPOVZ
- ID: 298758
Cite item
Full Text
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.
About the authors
Gulnara A. Gareeva
Kazan National Research Technical University named after A.N. Tupolev-KAI
Author for correspondence.
Email: gagareeva1977@mail.ru
ORCID iD: 0000-0002-8539-4541
SPIN-code: 3279-8465
Scopus Author ID: 36801593200
Candidate of Pedagogical sciences, Associate professor, Head of the Department of Information Systems
1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian FederationAigul G. Faizullina
Kazan Federal University Naberezhnochelninsk Institute
Email: dlya_pisem_t@mail.ru
Senior Lecturer of the Department of Business Informatics and Mathematical Methods in Economics
68/19 Prospekt Mira, Naberezhnye Chelny 423812, Russian FederationAsiya A. Mirsaitova
Kazan Innovation University named after V.G. Timiryasov
Email: a230864m@yandex.ru
Senior Lecturer, Department of Higher Mathematics and Information Technologies
67, Moskovsky Ave., Naberezhnye Chelny, 423822, Russian FederationSh. Zulfina Aglyamova
Kazan Innovation University named after V.G. Timiryasov
Email: aglamova@chl.ieml.ru
Candidate of Pedagogical Sciences, Associate Professor of the Department of Higher Mathematics, Modeling and Data Analysis
67, Moskovsky Ave., Naberezhnye Chelny, 423822, Russian FederationNuriya R. Zakirova
Naberezhnochelninsk State Pedagogical University
Email: smile-nuriya@yandex.ru
Candidate of Pedagogical Sciences, Associate Professor, Department of Informatics and Computational Mathematics
Im. Nizametdinov R.M. Str., 28, Naberezhnye Chelny, 423806, Russian FederationReferences
- 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
Supplementary files
