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 - Mueller, Ralph A1 - Großmann, Daniel A1 - Schmied, Sebastian A1 - Mathias, Selvine George T1 - Architecture of a model in the middle approach for virtual commissioning and integration of production entities T2 - Proceedings: 2021 26th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA45728.2021.9613619 KW - virtual commissioning KW - information model KW - information model management KW - cyber physical system KW - digital twin KW - machine communication KW - aggregation Y1 - 2021 UR - https://doi.org/10.1109/ETFA45728.2021.9613619 SN - 978-1-7281-2989-1 PB - IEEE CY - Piscataway ER - TY - CHAP A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Mathias, Selvine George A1 - Mueller, Ralph T1 - A concept towards the evolution and versioning of aggregated information models T2 - Proceedings: 2021 26th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA45728.2021.9613193 KW - information modelling KW - versioning KW - evolution of models Y1 - 2021 UR - https://doi.org/10.1109/ETFA45728.2021.9613193 SN - 978-1-7281-2989-1 PB - IEEE CY - Piscataway ER - TY - JOUR A1 - Schmied, Sebastian A1 - Mathias, Selvine George A1 - Großmann, Daniel A1 - Jumar, Ulrich T1 - Integration of existing cyber-physical manufacturing systems into a common information model JF - IFAC-PapersOnLine N2 - In order to be able to serve constantly new customer requirements, manufacturing systems must be able to adapt to frequent changes. In addition, repeatedly objects are removed or added to the network. To control and monitor such a constantly changing system a mapping of existing manufacturing systems into a common information model is necessary. This model describes information that is produced and stored in different entities of the complete system. To create a common address space and expose the relations between the devices an aggregation of every element in the system is needed. This paper describes a methodology for the creation of an information model for a complete manufacturing environment, followed by an approach for the aggregation of the singular system entities. The concept of this paper is illustrated with a demonstrator. The results of this approach have been discussed in the following sections along with the proposal for further directions. UR - https://doi.org/10.1016/j.ifacol.2020.12.2827 KW - Information Model KW - Aggregation KW - OPC UA KW - Cyber-physical manufacturing systems Y1 - 2021 UR - https://doi.org/10.1016/j.ifacol.2020.12.2827 UR - http://nbn-resolving.de/urn/resolver.pl?urn:nbn:de:bvb:573-13309 SN - 2405-8963 VL - 53 IS - 2 SP - 10905 EP - 10910 PB - Elsevier CY - Amsterdam ER - TY - CHAP A1 - Mathias, Selvine George A1 - Großmann, Daniel A1 - Schmied, Sebastian A1 - Mueller, Ralph T1 - Decentralized Integration Approach of Disjoint Modules in Factory Environments T2 - IEIM 2022: 2022 The 3rd International Conference on Industrial Engineering and Industrial Management UR - https://doi.org/10.1145/3524338.3524368 KW - Data Acquisition KW - OPC UA KW - Comunication KW - Instruments Y1 - 2022 UR - https://doi.org/10.1145/3524338.3524368 SN - 978-1-4503-9569-4 SP - 195 EP - 199 PB - ACM CY - New York ER - TY - CHAP A1 - Mueller, Ralph A1 - Großmann, Daniel A1 - Schmied, Sebastian T1 - Information model-based virtual commissioning for the testing and co-simulation of real production entities BT - Enabling of a logic for the virtual commissioning of information models using middleware technologies T2 - IEIM 2022: 2022 The 3rd International Conference on Industrial Engineering and Industrial Management UR - https://doi.org/10.1145/3524338.3524380 KW - Virtual Commissioning KW - Information Model KW - Co-Simulation KW - Cyber Physikal System KW - Machine Communication Y1 - 2022 UR - https://doi.org/10.1145/3524338.3524380 SN - 978-1-4503-9569-4 SP - 271 EP - 276 PB - Association for Computing Machinery CY - New York ER - TY - JOUR A1 - Nothdurft, Lars A1 - Epple, Ulrich A1 - Schröder, Tizian A1 - Diedrich, Christian A1 - Großmann, Daniel A1 - Banerjee, Suprateek A1 - Schmied, Sebastian A1 - Iatrou, Chris Paul A1 - Graube, Markus A1 - Urbas, Leon A1 - Henrichs, Tim Peter A1 - Erben, Stefan T1 - NOA Demonstratoren Special JF - atp magazin UR - https://doi.org/10.17560/atp.v60i01-02.2348 KW - Namur KW - Offene Architekturen KW - Automatisierung KW - IoT KW - OPC UA KW - Monitoring KW - Optimization Y1 - 2018 UR - https://doi.org/10.17560/atp.v60i01-02.2348 SN - 2190‑4111 VL - 60 IS - 1-2 SP - 44 EP - 69 PB - Vulkan CY - Essen ER - TY - CHAP A1 - Schmied, Sebastian A1 - Großmann, Daniel A1 - Denk, Bastian T1 - A systematic top-down information modelling approach for workshop-type manufacturing systems T2 - Proceedings 2019 24th IEEE International Conference on Emerging Technologies and Factory Automation (ETFA) UR - https://doi.org/10.1109/ETFA.2019.8869377 KW - OPC UA KW - information modelling Y1 - 2019 UR - https://doi.org/10.1109/ETFA.2019.8869377 SN - 978-1-7281-0303-7 SP - 1305 EP - 1308 PB - IEEE CY - Piscataway ER -