Data Integration Framework to Collect Data from OT/IT Systems

Balázs Szűcs

doi:10.14513/actatechjaur.00689

Authors

Balázs Szűcs Audi Hungaria Zrt, Audi Hungária út 1., 9027 Győr, Hungary

DOI:

https://doi.org/10.14513/actatechjaur.00689

Keywords:

data acquisition, data integration, industry 4.0, MQTT, operational technology

Abstract

Industry 4.0 and industrial data processing, due to its inherent possibilities, is gaining more and more emphasis in production companies these days. In a corporate environment, the age of equipment is extremely heterogeneous, in addition to state-of-the-art equipment, legacy systems can also be found in the machine park, which do not have appropriate communication protocols. Also, with the increase in the number of data sources, the management of data is becoming more and more challenging. Not only the operational technology, but also the connection of different IT systems and the extraction of data pose challenges. The different data processing use-cases using partly or entirely the same data sources, so it is necessary to extract and transmit the data to the target systems in a standard way, and avoiding an increase in the number of point-to-point interfaces. In this work we present a possible framework, to solve the above mentioned problems in industrial environment, with the introduction of standardized naming conventions, OT/IT gateways, data integration and distribution layers.

Downloads

Download data is not yet available.

References

Verma, N., Jain, M., & Agrawal, R. (2018). Wireless sensor networks for industrial automation: Challenges and solutions. Journal of Sensor and Actuator Networks, 7(3), 33. https://doi.org/10.1002/dac.4074

Shi, W. et al. (2016). Edge computing: Vision and challenges. IEEE Internet of Things Journal, 3(5), 637-646. https://doi.org/ 10.1109/JIOT.2016.2579198

Oussous, A. et al. (2018). Big data technologies: A survey. Journal of King Saud University - Computer and Information Sciences, 30(4), 431-448. https://doi.org/10.1016/j.jksuci.2017.06.001

Apache Kafka. (2021). Retrieved from https://kafka.apache.org/ [cited 2023-01-22]

RabbitMQ. (2021). Retrieved from https://www.rabbitmq.com/ [cited 2023-01-22]

Riedel, E. (2022). MQTT protocol for SME foundries: potential as an entry point into industry 4.0, process transparency and sustainability. Procedia CIRP. 105. https://doi.org/10.1016/j.procir.2022.02.100.

Li, Z., Li, B., & Li, J. (2019). Research on equipment coding and naming system for power plants based on the characteristics of the equipment. IOP Conference Series: Materials Science and Engineering, 664(1), 012138.

Das, A., & Akbar, R. (2019). A comprehensive naming convention for industrial components. In Advances in Manufacturing and Mechanical Engineering (pp. 281-289). Springer, Singapore.

Gómez, J. A., & Santana, R. (2020). Development of a descriptive naming convention for industrial equipment. Industrial Management & Data Systems.

Chung, T. W., Chen, C. M., & Yeh, C. T. (2015). Development of a rule-based naming convention for equipment in a semiconductor manufacturing fab. IEEE Transactions on Semiconductor Manufacturing, 28(3), 307-314.

Berners-Lee, Tim, RFC 3986: Uniform Resource Identifier (URI): Generic Syntax (2005) DOI:10.17487/RFC3986

Libes, D., Choosing a name for your computer, FYI 5, RFC 1178, (1990). https://www.rfc-editor.org/info/rfc1178

Bray, T., Ed., The JavaScript Object Notation (JSON) Data Interchange Format, STD 90, RFC 8259 (2017). https://www.rfc-editor.org/info/std90

K. Birman, T. Joseph, Exploiting virtual synchrony in distributed systems. In Proceedings of the eleventh ACM Symposium on Operating systems principles (SOSP '87). Association for Computing Machinery, New York, NY, USA, 123–138. (1987) https://doi.org/10.1145/41457.37515

Yusuf, S., Survey of publish subscribe communication system, Advanced Internet Application and System Design (2004)

Technical Documentation for SINUMERIK 840D sl, Version 4.92, Retrieved from https://support.industry.siemens.com/cs/document/109768584/technical-documentation-for-sinumerik-840d-sl-version-4-92?dti=0&lc=en-DE [cited 2023-01-22]

SIMATIC Industrial PC SIMATIC IPC427E Operating Instructions A5E37454814-AE, Siemens (2021)

.NET, Retrieved from https://dotnet.microsoft.com/en-us/ [cited 2023-01-22]

Sharp7 Library, Retrieved from https://snap7.sourceforge.net/sharp7.html [cited 2023-01-22]

S7 Protocol, Retrieved from https://wiki.wireshark.org/S7comm [cited 2023-01-22]

R. A. Light, "Mosquitto: server and client implementation of the MQTT protocol," The Journal of Open Source Software, vol. 2, no. (2017) https://doi.org/10.21105/joss.00265

Microsoft SQL Server 2019, Retrieved from https://www.microsoft.com/en-us/sql-server/sql-server-2019 [cited 2023-01-22]

SINUMERIK 840D sl/840Di sl, SINUMERIK 840D/840Di/810D List of System Variables, Parameter Manual (2006), Retrieved from

https://cache.industry.siemens.com/dl/files/272/28713272/att_92132/v1/PGA1_1106_en.pdf [cited 2023-01-22]

MQTTnet Library, Retrieved from https://github.com/dotnet/MQTTnet [cited 2023-01-22]

Entity Framework, Retrieved from https://learn.microsoft.com/en-us/ef/ [cited 2023-01-22]

Language Integrated Query (LINQ), Retrieved from https://learn.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/ [cited 2023-01-22]