Authors:
Rolando Azevedo
1
;
2
;
Joaquim P. Silva
1
;
Nuno Lopes
1
;
António Curado
3
;
Leonel J. R. Nunes
3
and
Sérgio Ivan Lopes
4
;
2
Affiliations:
1
2Ai – School of Technology, IPCA, 4750-810 Barcelos, Portugal
;
2
CiTin – Centro de Interface Tecnológico Industrial, 4970-786 Arcos de Valdevez, Portugal
;
3
proMetheus, Instituto Politécnico de Viana do Castelo, Rua Escola Industrial e Comercial Nun’ Álvares, 4900-347 Viana do Castelo, Portugal
;
4
ADiT-Lab – Instituto Politécnico de Viana do Castelo, 4900-347 Viana do Castelo, Portugal
Keyword(s):
Data Warehouse, ETL, Indoor Radon, IoT, OLAP, Data Analytics.
Abstract:
Indoor radon represents a known hazard to public health, namely, its relationship with lung cancer. The adoption of data analytics tools for indoor radon human exposure risk assessment is crucial for building management decision-making and is a fundamental requirement for the implementation of remediation measures. This work presents the implementation of a data warehouse and an OLAP cube as components of a more comprehensive IoT-based system, which has been developed for continuous indoor radon gas management in public buildings. The proposed data warehouse consists of a three-tier data storage structure to store historical measurements. Although the adopted approach has been tested with a small number of IoT sensors, the operation of the data warehouse and OLAP server assures that the system is viable and highly scalable. The increase in the number of active IoT sensors deployed in new buildings, cities, and districts will increase the richness of the data, which will help to foste
r even better models.
(More)