Skip to main content
1-Visitor
September 6, 2018
Solved

Best practices for modelling Semantic DB Queries

  • September 6, 2018
  • 2 replies
  • 1342 views

Hi,

 

I have gone through the TWX data modelling and the concepts are pretty clear.
But, i could not find a clear solution when it comes to modelling external entities like Semantic DB in TWX data model.
I will try to phrase my question here;

1. I have 3 robots on the edge (with 3 different functionalities).

2. I have a Graph DB, where i store my data (like creating an order at Robot1, shutting down Robot2 etc.)

3. So, I have a set of Queries which handles basically the CRUD operations in my DB.

 

Now, the question is where to place these queries.

1. In a master Thing (central Thing), which handles all DB related activities.

OR

2. In a Thing Shape on individual Robot Thing Template layers (like getRobot2StatusFromDB() service).

 

Please provide your ideas on the best practices.

Thanks in advance

This topic has been closed for replies.
Best answer by PaiChung

Generally speaking I have the base queries in the DB Thing with the System user applied to it for Runtime security.

then i have a wrapper service in the shape/template of the Robot to invoke those queries with the proper validated input parameters.

2 replies

PaiChung22-Sapphire IAnswer
22-Sapphire I
September 6, 2018

Generally speaking I have the base queries in the DB Thing with the System user applied to it for Runtime security.

then i have a wrapper service in the shape/template of the Robot to invoke those queries with the proper validated input parameters.

Rahul_Raj1-VisitorAuthor
1-Visitor
September 7, 2018

Thanks a lot. Sounds to me the best approach.