Skip to content

Research at St Andrews

A reference architecture and model for sensor data warehousing

Research output: Contribution to journalArticle


Simon Andrew Dobson, Matteo Golfarelli, Simone Graziani, Stefano Rizzi

School/Research organisations


Sensor data is becoming far more available thanks to the growth in both sensor systems and Internet of Things devices. Much of the value of sensor data comes from examining trends that occur over long timescales, ranging from hours to years. However, making use of data a long time after it has been collected has significant implications for the data-handling systems used to manage it. In particular, the data must be contextualised into the environment in which it was collected to avoid misleading (and potentially dangerous) mis-interpretation. We apply data warehousing techniques to develop an extensible model to capture contextual metadata alongside sensor datasets, and show how this can be used to support the analysis of datasets long after collection. We present our baseline reference framework for sensor context and derive multidimensional schemata representing different modelling and analysis scenarios. Finally, we exercise the model with two case studies.


Original languageEnglish
Pages (from-to)7659-7670
Number of pages12
JournalIEEE Sensors Journal
Issue number18
Early online date31 Jul 2018
Publication statusPublished - 15 Sep 2018

    Research areas

  • Data warehouse, Multidimensional modelling, Sensor networks, Data analytics

Discover related content
Find related publications, people, projects and more using interactive charts.

View graph of relations

Related by author

  1. Self-organization and resilience for networked systems: design principles and open research issues

    Dobson, S. A., Hutchison, D., Mauthe, A., Schaefer-Filho, A., Smith, P. & Sterbenz, J., Apr 2019, In : Proceedings of the IEEE. 107, 4, p. 819 - 834

    Research output: Contribution to journalArticle

  2. Making sense of the world: framing models for trustworthy sensor-driven systems

    Calder, M., Dobson, S., Fisher, M. & McCann, J., 15 Nov 2018, In : Computers. 7, 4, 13 p., 62.

    Research output: Contribution to journalArticle

  3. Self-stabilising target counting in wireless sensor networks using Euler integration

    Pianini, D., Dobson, S. A. & Viroli, M., 12 Oct 2017, 2017 IEEE 11th International Conference on Self-Adaptive and Self-Organizing Systems (SASO). IEEE Computer Society, p. 11-20 8063636

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

Related by journal

  1. Simple electrical modulation scheme for laser feedback imaging

    Bertling, K., Taimre, T., Agnew, G., Lim, Y., Dean, P., Indjin, D., Höfling, S., Weih, R., Kamp, M., von Edlinger, M., Koeth, J. & Rakic, A., 1 Apr 2016, In : IEEE Sensors Journal. 16, 7

    Research output: Contribution to journalArticle

ID: 255030293