{"id":4045,"date":"2026-06-10T11:41:02","date_gmt":"2026-06-10T11:41:02","guid":{"rendered":"https:\/\/jita-au.com\/?p=4045"},"modified":"2026-06-10T13:13:50","modified_gmt":"2026-06-10T13:13:50","slug":"centralized-database-and-distributed-communication-in-a-software-system-for-high-precision-industrial-machine-control","status":"publish","type":"post","link":"https:\/\/jita-au.com\/index.php\/2026\/06\/10\/centralized-database-and-distributed-communication-in-a-software-system-for-high-precision-industrial-machine-control\/","title":{"rendered":"Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t

Vol. 16 No. 1 (2026): JITA - APEIRON<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Daniel Meni\u0107anin, Jelena Radanovi\u0107, Dra\u017een Marinkovi\u0107<\/b><\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Review paper
DOI: https:\/\/doi.org\/10.7251\/JIT2601020M<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tDownload Article PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Abstract<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Paper received:<\/b> 17.4.2026.
Paper accepted:<\/b> 5.5.2026.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\r\n\t\t\t\t<\/span> Post Views:<\/span> 12<\/span>\r\n\t\t\t<\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
Downloaded Article PDF: 0<\/span> times\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t

Vol. 16 No. 1 (2026): JITA - APEIRON6<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Daniel Meni\u0107anin, Jelena Radanovi\u0107, Dra\u017een Marinkovi\u0107<\/b><\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Review paper<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

DOI: https:\/\/doi.org\/10.7251\/JIT2601020M<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tDownload Article PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Abstract<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Paper received:<\/b> 17.4.2026.
Paper accepted:<\/b> 5.5.2026.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\r\n\t\t\t\t<\/span> Post Views:<\/span> 12<\/span>\r\n\t\t\t<\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
Downloaded Article PDF: 0<\/span> times\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t

Vol. 16 No. 1 (2026): JITA - APEIRON<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Daniel Meni\u0107anin, Jelena Radanovi\u0107, Dra\u017een Marinkovi\u0107<\/b><\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Review paper<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

DOI: https:\/\/doi.org\/10.7251\/JIT2601020M<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tDownload Article PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Abstract<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Paper received:<\/b> 17.4.2026.
Paper accepted:<\/b> 5.5.2026.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\r\n\t\t\t\t<\/span> Post Views:<\/span> 12<\/span>\r\n\t\t\t<\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
Downloaded Article PDF: 0<\/span> times\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Vol. 16 No. 1 (2026): JITA – APEIRON Daniel Meni\u0107anin, Jelena Radanovi\u0107, Dra\u017een Marinkovi\u0107 Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control Review paperDOI: https:\/\/doi.org\/10.7251\/JIT2601020M Download Article PDF Abstract High precision in industrial processes depends not only on the mechanical and control components of the system, but also on […]<\/p>\n","protected":false},"author":1,"featured_media":4019,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/posts\/4045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/comments?post=4045"}],"version-history":[{"count":7,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/posts\/4045\/revisions"}],"predecessor-version":[{"id":4117,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/posts\/4045\/revisions\/4117"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/media\/4019"}],"wp:attachment":[{"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/media?parent=4045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/categories?post=4045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jita-au.com\/index.php\/wp-json\/wp\/v2\/tags?post=4045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}