Design and Implementation of Data Processing Middleware and Management System for IoT based Services

Abstract

Sensor application systems for remote monitoring and control are required, such as the establishment of databases and IoT service servers, to process data being transmitted and received through radio communication modules, controllers and gateways. This paper designs and implements database server, IoT service server, data processing middleware and IoT management system for IoT based services based on the controllers, communication modules and gateway middleware platform developed. For this, we firstly define the specification of the data packet and control code for the information classification of the sensor application system, and also design and implement the database as a separate server for data protection and efficient management. In addition, we design and implement the IoT management system so that functions such as status information verification, control and modification of operating environment information of remote sensor application systems are carried out. The implemented system can lead to efficient operation and reduced management costs of sensor application systems through site status analysis, setting operational information, and remote control and management.

Fig. 1. Diagram of database relationship model

Fig. 2. Roles and features of data processing middleware

Fig. 3. Flow chart for data processing and store

Fig. 4. Class diagram of middleware for data processing

Fig. 5. Class diagram for application of IoT management system

Fig. 6. Contents saved in database server after data analysis

Fig. 7. Screen for data acquisition and controller control

Fig. 8. Screen of serial communication settings and controller data received

Table 1. Packet protocol for data transmission

Table 2. SDT and EDT code table

Table 3. Classification of the control code

Table 4. Database server implementation environment

Table 5. IoT service server implementation environment