Difference between revisions of "WISE-PaaS/SRP Services"
Line 52: | Line 52: | ||
=== Common Database Table Details === | === Common Database Table Details === | ||
− | Table Account | + | |
− | [[File: | + | Table Account |
+ | |||
+ | [[File:Account tbl.png|RTENOTITLE]] | ||
Table Role | Table Role | ||
− | [[File: | + | |
+ | [[File:Role tbl.png|RTENOTITLE]] | ||
Table Group | Table Group | ||
− | [[File: | + | |
+ | [[File:Group tbl.png|RTENOTITLE]] | ||
Table Device | Table Device | ||
− | [[File: | + | |
+ | [[File:Device tbl.png|RTENOTITLE]] | ||
== Document == | == Document == |
Revision as of 07:42, 16 January 2017
Contents
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