Comparison of data aggregation from a wireless network of sensors using database sharding and foreign data wrappers
Vladimir Stanisavljević · 2019
In this work two built-in database technologies were compared and applied to aggregation of data from a network of sensor equipped data collection nodes in a real manufacturing environment. The methods investigated are: data sharding and foreign data wrappers. The availability and feature set differences of the methods on some popular database management systems was compared and then a detailed case study on PostgreSQL DBMS was performed. For testing the concept in more realistic environment the sensor network was implemented using a number of Raspberry Pi computers with local relational database and with wireless connectivity to main aggregation database running on a much powerful server computer. Both database methods were applied on all nodes and the server and performance was measured for different types of aggregation queries. The very same data aggregation concepts presented here could be applied to any sensor network or to any Internet of things network.