WISE-PaaS/SRP Services

Overview

• 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.

Common Database Scheme

Common Database Table Details

Table Account

Table Role

Table Group

Table Device