Data Architecture for Sensor Network


  • Jan Ježek Faculty of Applied Sciences, Department of Mathematics, University of West Bohemia in Pilsen, Univerzitní 22, Plzeň 306 14, Czech Republic



sensor network, data architecture, NoSQL, PostgreSQL, PostGIS, Apache Cassandra


Fast development of hardware in recent years leads to the high availability of simple sensing devices at minimal cost. As a consequence, there is many of sensor networks nowadays. These networks can continuously produce a large amount of observed data including the location of measurement. Optimal data architecture for such propose is a challenging issue due to its large scale and spatio-temporal nature.  The aim of this paper is to describe data architecture that was used in a particular solution for storage of sensor data. This solution is based on relation data model – concretely PostgreSQL and PostGIS. We will mention out experience from real world projects focused on car monitoring and project targeted on agriculture sensor networks. We will also shortly demonstrate the possibilities of client side API and the potential of other open source libraries that can be used for cartographic visualization (e.g. GeoServer). The main objective is to describe the strength and weakness of usage of relation database system for such propose and to introduce also alternative approaches based on NoSQL concept.


Brewer, E.: Principles of Distributed Computing (PODC 2000): "Towards robust distributed systems." Portland, OR., July 2000.USA. ISBN 978-0-7695-3858-7 (2009)

Eben, H.: Cassandra The definitive Guide. O’Reilly, 2010, ISBN 978-1-449-19041-9

Lakshman, A.; Malik, P.: Cassandra — A Decentralized Structured Storage System. Cornell University. Retrieved 13 November 2009.

Samuel R. Madden, Michael J. Franklin, Joseph M. Hellerstein, Wei Hong: "TinyDB: an acquisitional query processing system for sensor networks", ACM Trans. Database Syst., Vol. 30, No. 1. (March 2005), pp. 122-173.

Philippe Bonnet, J. E. Gehrke, and Praveen Seshadri: Querying the Physical World. IEEE Personal Communications, Vol. 7, No. 5, October 2000, pages 10-15. Special Issue on Smart Spaces and Environments.