Data model and design of API
Device ID, measurement channels, units, timestamps and status codes are defined in the common data model. When the connection is interrupted, transfer of locally accumulated records, processing of duplicate messages and missing data situations are evaluated. Retention time and query needs affect database design; It is not enough to have a table structure that only works in the first example.
API endpoints are developed for devices and applications. Communication approaches such as HTTP or MQTT are assessed according to the project. Authentication, access permissions, input validation and connection security are part of the design. Where integration with existing enterprise software is needed, the other system's data format and authorisation requirements are examined together.
- Device ID, measurement and event data model
- API and database development
- Message validation and access control