Difference between revisions of "WISE-PaaS/SRP Services"

From ESS-WIKI
Jump to: navigation, search
Line 52: Line 52:
  
 
=== Common Database Table Details ===
 
=== Common Database Table Details ===
Table Account
+
 
[[File:account tbl.png]]
+
Table Account  
 +
 
 +
[[File:Account tbl.png|RTENOTITLE]]
  
 
Table Role
 
Table Role
[[File:role tbl.png]]
+
 
 +
[[File:Role tbl.png|RTENOTITLE]]
  
 
Table Group
 
Table Group
[[File:group tbl.png]]
+
 
 +
[[File:Group tbl.png|RTENOTITLE]]
  
 
Table Device
 
Table Device
[[File:device tbl.png]]
+
 
 +
[[File:Device tbl.png|RTENOTITLE]]
  
 
== Document ==
 
== Document ==

Revision as of 07:42, 16 January 2017

Overview

RTENOTITLE

  • API Management

Adopt Azure API Management/Open-source (WSO2) to integrate various SRP services API.

  • Common Service APIs/Lib

Basic Account/Device/Group/Role operation APIs, including Add/Edit/Delete/Search/Advance Search WISE-PaaS administration information (Product Support, version, capability…etc.)

  • Custom/SRP Service

RMM/IMM/OTA/SCADA self-service APIs

  • Common Data Workers

Including device basic information and sensor data from broker. (Common MQTT Topic) For structure info (device Info) store into PostgreSQL For non-structure (sensor Info) store into MongoDB/DocumentDB/...etc.

  • Custom/SRP Data Workers

Process RMM/IMM/OTA/SCADA self-MQTT topic message and store into self-database (RMM/IMM/OTASCADA DB)

  • Message Broker (RabbitMQ)

Adopt RabbitMQ as default cluster broker, and plugin MQTT as communication protocol.

  • Device Agent

Define common MQTT topic handshake message and custom/SRP topic format.

  • Database (SQL/NoSQL)

PostgreSQL as default relation database and including Common/RMM /SCADA/IMM/etc. MongoDB/DoucmentDB for sensor information collect.

Common Database Scheme

Concept & Design Rules

  • Device belong to multi-groups or not to any group.
  • Each account have non or multi-groups.
  • Each group must belong to someone account.
  • Group of group (1-3 Levels)
  • Each account must belong to someone role.

RTENOTITLE

Common Database Scheme

RTENOTITLE

Common Database Table Details

Table Account

RTENOTITLE

Table Role

RTENOTITLE

Table Group

RTENOTITLE

Table Device

RTENOTITLE

Document