Autor(es): Azevedo, Rolando ; Silva, Joaquim P. ; Lopes, Nuno ; Curado, António ; Nunes, Leonel J R ; Lopes, Sérgio I
Data: 2025
Identificador Persistente: http://hdl.handle.net/11110/3202
Origem: Politécnico do Cávado e do Ave
Assunto(s): IoT; Data Warehouse; ETL; OLAP
Recently we have seen an increase in the frequency of radon concentration measurement campaigns, largely driven by directives adopted at a European level, and by increased public awareness of the problem. Many of the conducted assessments are simple concentration averages over a time range, where passive sensors are mostly used. Other assessments use portable devices that measure radon in a continuous mode, which can later be downloaded for analysis. However, other types of systems emerged, which continuously measure indoor radon concentrations, and using wireless communications make these data available in real time. This is the case of the RnMonitor platform, designed for online indoor radon monitoring in public buildings in northern Portugal using IoT devices with LoRa communication. The project provides a time series database to collect raw data and a multidimensional data warehouse to store a large amount of these data in the long term, and to make possible the use of OLAP analytical query tools to explore the data in a multidimensional way. Thus, this article describes the development and implementation of a Data Analytical Processing Module of the RnMonitor platform. This module is composed by an ETL process, a multidimensional database and an OLAP server.
This research is a result of the project TECH - Technology, Environment, Creativity and Health, Norte-01-0145-FEDER-000043, supported by Norte Portugal Regional Operational Program (NORTE 2020), under the PORTUGAL 2020 Partnership Agreement, through the European Regional Development Fund (ERDF). L.J.R.N. was supported by proMetheus, Research Unit on Energy, Materials and Environment for Sustainability - UIDP/05975/2020, funded by national funds through FCT - Fundação para a Ciência e Tecnologia. António Curado co-authored this work within the scope of the project proMetheus–Research Unit on Materials, Energy and Environment for Sustainability, FCT Ref. UID/05975/2020, financed by national funds through the FCT/MCTES.
