Leveraging Relational Database for Fast Construction of OPC UA Information Model

Rongkai Wang, Shibo He, Yang Liu, Chengwei Zhou, Zhiguo Shi, Jiming Chen
{"title":"Leveraging Relational Database for Fast Construction of OPC UA Information Model","authors":"Rongkai Wang, Shibo He, Yang Liu, Chengwei Zhou, Zhiguo Shi, Jiming Chen","doi":"10.1109/ICITES53477.2021.9637064","DOIUrl":null,"url":null,"abstract":"With the development of manufacturing factory, massive devices are being deployed in production lines for performance monitoring and optimization, which raises the challenge of interconnectivity and interoperability among devices. OPC UA is widely recognized as one of the effective technologies to address such an issue. Traditional ways of constructing OPC UA information model need to manually add and define different nodes describing the devices and their attributes (e.g., names, ID, data types, etc.), which is costly and time-consuming when a huge number of devices is involved. Some works defined mapping rules between existing data model/structure/exchange format and OPC UA information model to reduce the workloads. However, they ignored the construction process of OPC UA information model and assumed that the existing referenced data structure/exchange format was created before the transformation of information model. Also, the mapping rules do not provide detailed implementation of mapping method. In this paper, we take the first attempt on the fast construction process of OPC UA information model. The raw data of field devices represented as structured data in rational database is fully utilized to extract the information, even though there are no existing data model for reference. The challenge of transforming structured data in database to OPC UA address space is discussed, based on which we propose a specific fast construction method for OPC UA information model. The method is deployed in the built industrial discrete manufacturing production line platform to evaluate the applicability of fast information model construction.","PeriodicalId":370828,"journal":{"name":"2021 International Conference on Intelligent Technology and Embedded Systems (ICITES)","volume":"74 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-10-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 International Conference on Intelligent Technology and Embedded Systems (ICITES)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICITES53477.2021.9637064","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1

Abstract

With the development of manufacturing factory, massive devices are being deployed in production lines for performance monitoring and optimization, which raises the challenge of interconnectivity and interoperability among devices. OPC UA is widely recognized as one of the effective technologies to address such an issue. Traditional ways of constructing OPC UA information model need to manually add and define different nodes describing the devices and their attributes (e.g., names, ID, data types, etc.), which is costly and time-consuming when a huge number of devices is involved. Some works defined mapping rules between existing data model/structure/exchange format and OPC UA information model to reduce the workloads. However, they ignored the construction process of OPC UA information model and assumed that the existing referenced data structure/exchange format was created before the transformation of information model. Also, the mapping rules do not provide detailed implementation of mapping method. In this paper, we take the first attempt on the fast construction process of OPC UA information model. The raw data of field devices represented as structured data in rational database is fully utilized to extract the information, even though there are no existing data model for reference. The challenge of transforming structured data in database to OPC UA address space is discussed, based on which we propose a specific fast construction method for OPC UA information model. The method is deployed in the built industrial discrete manufacturing production line platform to evaluate the applicability of fast information model construction.
利用关系数据库快速构建OPC UA信息模型
随着制造工厂的发展,大量设备被部署在生产线上进行性能监控和优化,这对设备之间的互连和互操作性提出了挑战。OPC UA被广泛认为是解决这一问题的有效技术之一。传统的构建OPC UA信息模型的方法需要手动添加和定义描述设备及其属性(如名称、ID、数据类型等)的不同节点,当涉及大量设备时,这种方法成本高,耗时长。一些工作定义了现有数据模型/结构/交换格式与OPC UA信息模型之间的映射规则,以减少工作负载。然而,他们忽略了OPC UA信息模型的构建过程,并假设在信息模型转换之前已经创建了现有的参考数据结构/交换格式。此外,映射规则没有提供映射方法的详细实现。本文首次尝试了OPC UA信息模型的快速构建过程。充分利用现场设备的原始数据在rational数据库中表示为结构化数据来提取信息,即使没有现有的数据模型可供参考。讨论了将数据库中的结构化数据转换为OPC UA地址空间所面临的挑战,在此基础上提出了一种特定的OPC UA信息模型快速构建方法。将该方法应用于已建成的工业离散制造生产线平台,以评估快速信息模型构建的适用性。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信