Data Architecture for Sensor Network

Jan Ježek


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.


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


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.


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.