TY - JOUR A1 - Mathias, Selvine George A1 - Schmied, Sebastian A1 - Großmann, Daniel T1 - A framework for monitoring multiple databases in industries using OPC UA JF - Journal of Ambient Intelligence and Humanized Computing N2 - Database management and monitoring is an inseparable part of any industry. A uniform scheme of monitoring relational databases without explicit user access to database servers is not much explored outside the database environment. In this paper, we present an information distribution scheme related to databases using Open Platform Communication Unified Architecture (OPC UA) servers to clients when multiple databases are involved in a factory. The aim is for external, but relevant clients, to be able to monitor this information mesh independent of explicit access to user schemas. A methodology to dispense data from, as well as check changes in databases using SQL queries and events is outlined and implemented using OPC UA servers. The structure can be used as a remote viewing application for multiple databases in one address space of an OPC UA server. UR - https://doi.org/10.1007/s12652-020-02850-x KW - OPC UA KW - Relational databases KW - Servers KW - Clients KW - Monitoring KW - Aggregation KW - SQL Y1 - 2020 UR - https://doi.org/10.1007/s12652-020-02850-x UR - http://nbn-resolving.de/urn/resolver.pl?urn:nbn:de:bvb:573-9464 SN - 1868-5145 VL - 12 IS - 1 SP - 47 EP - 56 PB - Springer CY - Berlin ER - TY - JOUR A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mathias, Selvine George A1 - Mueller, Ralph T1 - Integration of manufacturing information via dynamic information model aggregation JF - Vietnam Journal of Computer Science N2 - An important part of the industry 4.0 concept is the horizontal and vertical integration of manufacturing systems. Information exchange in traditional production environments happens through interfaces that are connections between strictly defined senders and receivers. This limits the possibility for changing and extending the manufacturing system. A possible approach to enable the information exchange between all system entities uniformly are information models. Such models are semantic descriptions of the available data. The creation of these models needs to follow the manufacturing process, but also requires certain standardization to improve efficiency. Another challenge is the actual technical integration of the information into a common address space. This paper connects an approach for information modeling with a concept for dynamic aggregation. The approach is described with the help of a continuous example that uses OPC UA as a middleware technology. UR - https://doi.org/10.1142/S219688882150010X KW - Integration KW - OPC UA KW - interoperability KW - aggregation Y1 - 2020 UR - https://doi.org/10.1142/S219688882150010X UR - http://nbn-resolving.de/urn/resolver.pl?urn:nbn:de:bvb:573-9495 SN - 2196-8896 VL - 8 IS - 2 SP - 245 EP - 262 PB - Singapore CY - World Scientific ER - TY - JOUR A1 - Mathias, Selvine George A1 - Schmied, Sebastian A1 - Großmann, Daniel T1 - An investigation on database connections in OPC UA applications JF - Procedia Computer Science N2 - Open Platform Communications - Unified Architecture (OPC UA) as a communication protocol has been one of the front running IoT enablers in recent years. Many use cases in manufacturing domains demonstrate the vast inter-operability and cross-platform connectivity strengths of OPC UA. However, to consolidate its position in the IoT world, OPC UA needs to be able to bridge certain gaps, like interconnections across multiple database engines over different networks. This paper aims to investigate aggregation dynamics of OPC UA consisting of multiple database servers from a specific environment such as manufacturing. Prevailing databases over restricted networks such as production floors cannot be accessed by respective clients outside the system. In these cases, OPC UA services can provide an a selective but imperative view of data from these databases to the clients. The investigations in this paper are demonstrated with two different implementations of databases related to manufacturing with OPC UA. These applications show that using OPC UA as a means of connection and distribution of information from databases can be an effective solution to a common data view of all connections not necessarily of factory floor network. UR - https://doi.org/10.1016/j.procs.2020.03.132 KW - OPC UA KW - databases KW - implementations KW - SQL server KW - clients Y1 - 2020 UR - https://doi.org/10.1016/j.procs.2020.03.132 UR - http://nbn-resolving.de/urn/resolver.pl?urn:nbn:de:bvb:573-12349 SN - 1877-0509 VL - 2020 IS - 170 SP - 602 EP - 609 PB - Elsevier CY - Amsterdam ER - TY - CHAP A1 - Mathias, Selvine George A1 - Schmied, Sebastian A1 - Großmann, Daniel T1 - Monitoring of discrete electrical signals from welding processes using data mining and IIoT approaches T2 - Proceedings, IEEE 32nd International Conference on Tools with Artificial Intelligence, (ICTAI 2020) UR - https://doi.org/10.1109/ICTAI50040.2020.00142 KW - electrical signals KW - clustering KW - kmeans KW - hierarchical KW - time series KW - OPC UA KW - multi-label classification KW - metrics Y1 - 2020 UR - https://doi.org/10.1109/ICTAI50040.2020.00142 SN - 978-1-7281-9228-4 SP - 911 EP - 916 PB - IEEE CY - Piscataway ER - TY - CHAP A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mathias, Selvine George A1 - Mueller, Ralph T1 - An approach for aggregation and historicization of production entities in the graph T2 - Proceedings 2020 25th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA46521.2020.9211907 KW - information modelling KW - aggregation KW - graph database Y1 - 2020 UR - https://doi.org/10.1109/ETFA46521.2020.9211907 SN - 978-1-7281-8956-7 SP - 1107 EP - 1110 PB - IEEE CY - Piscataway ER - TY - CHAP A1 - Mueller, Ralph A1 - Großmann, Daniel A1 - Schmied, Sebastian A1 - Mathias, Selvine George T1 - Validation of dynamic interoperability and virtual commissioning of production equipment in early development stages T2 - Proceedings 2020 25th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA46521.2020.9211988 KW - virtual commissioning KW - information model KW - cyber physical system KW - digital twin KW - machine communication KW - design engineering process Y1 - 2020 UR - https://doi.org/10.1109/ETFA46521.2020.9211988 SN - 978-1-7281-8956-7 SP - 1159 EP - 1162 PB - IEEE CY - Piscataway ER - TY - CHAP A1 - Mathias, Selvine George A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mueller, Ralph A1 - Mroß, Björn T1 - A Compliance Testing Structure for Implementation of Industry Standards through OPC UA T2 - Proceedings 2020 25th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA46521.2020.9212119 KW - OPC UA KW - compliance testing KW - information models KW - servers KW - clients Y1 - 2020 UR - https://doi.org/10.1109/ETFA46521.2020.9212119 SN - 978-1-7281-8956-7 SP - 1091 EP - 1094 PB - IEEE CY - Piscataway ER - TY - CHAP A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mathias, Selvine George A1 - Banerjee, Suprateek T1 - Vertical integration via dynamic aggregation of information in OPC UA T2 - Intelligent Information and Database Systems UR - https://doi.org/10.1007/978-981-15-3380-8_18 KW - OPC UA KW - interoperability KW - aggregation Y1 - 2020 UR - https://doi.org/10.1007/978-981-15-3380-8_18 SN - 978-981-15-3379-2 SN - 978-981-15-3380-8 SN - 1865-0929 SN - 1865-0937 N1 - Access to this content is enabled by Nationallizenz Ebooks Medicine SP - 204 EP - 215 PB - Springer CY - Singapur ER - TY - CHAP A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mathias, Selvine George A1 - Mueller, Ralph T1 - An approach for an industrial information model management T2 - Proceedings, 2020 IEEE Conference on Industrial Cyberphysical Systems (ICPS) UR - https://doi.org/10.1109/ICPS48405.2020.9274751 KW - information modelling KW - cyber physical system KW - OPC UA Y1 - 2020 UR - https://doi.org/10.1109/ICPS48405.2020.9274751 SN - 978-1-7281-6389-5 SP - 402 EP - 405 PB - IEEE CY - Piscataway ER - TY - JOUR A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mueller, Ralph A1 - Mathias, Selvine George A1 - Jumar, Ulrich T1 - Erstellung und Management von Informationsmodellen für bestehende Produktionssysteme T1 - Creation and management of Information Models for existing production systems JF - at - Automatisierungstechnik UR - https://doi.org/10.1515/auto-2020-0021 KW - OPC UA KW - Informationsmodellierung KW - Produktionssystem KW - Prozessdaten-Management KW - OPC UA KW - Information Modeling KW - production system KW - process data management Y1 - 2020 UR - https://doi.org/10.1515/auto-2020-0021 SN - 2196-677X VL - 68 IS - 5 SP - 325 EP - 336 PB - De Gruyter CY - Berlin ER -