Saving and Storage OPC UA data | Miscellaneous | Forum

Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Lost password?
sp_Feed sp_PrintTopic sp_TopicIcon
Saving and Storage OPC UA data
Avatar
rwbm
Member
Members
Forum Posts: 10
Member Since:
12/01/2019
sp_UserOfflineSmall Offline
1
05/24/2020 - 05:16
sp_Permalink sp_Print

Hi everyone,

OPC UAs generic information model is a USP and differentiates it from other standards and protocols. While it is great for live-data discovery, streaming and analysis, I have not yet found a "proper" architecture to save and store UA-data. While I know that Historical Access is specified, I have not yet seen anyone use it in production. I also figure that historizising OPC UA servers would not scale well as NoSQL databases. Also the whole design of historizising nodes would probably be new to developers due to its inherent unique properties. On the other hand, storing OPC UA data in relational databases would nullify the advantages from the data model since RDBMs are unfit to model complex relations.

Is there an alternative between these two approaches that I am not seeing? How do you guys preserve semantic structures in databases?

Cheers

rwbm

Avatar
Randy Armstrong
Admin
Forum Posts: 779
Member Since:
05/30/2017
sp_UserOfflineSmall Offline
2
05/24/2020 - 16:11
sp_Permalink sp_Print

It is not clear what your issues are.

A few thoughts:

1) How you store the information model is not related to how you store the historical data. You could use different databases.

2) SQL DBs can and do store the complex relations represented in an UA information model

3) NoSQL DB is a generic term that captures many different types of storage. Some of them (ordered key-value stores) should be very suitable for accessing via the OPC UA History APIs.

4) The UA information model should be well suited for a NoSQL graph database. It is not clear what the issue is.

Avatar
rwbm
Member
Members
Forum Posts: 10
Member Since:
12/01/2019
sp_UserOfflineSmall Offline
3
05/25/2020 - 03:58
sp_Permalink sp_Print

I just wanted to learn what approaches you could take. Thanks for the input!

Forum Timezone: America/Phoenix
Most Users Ever Online: 202
Currently Online:
Guest(s) 6
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 9
Topics: 950
Posts: 2968