Autor(es): Azevedo, Rolando ; Silva, Joaquim P. ; Lopes, Nuno ; Curado, António ; Nunes, Leonel J R ; Lopes, Sérgio Ivan
Data: 2025
Identificador Persistente: http://hdl.handle.net/11110/3200
Origem: Politécnico do Cávado e do Ave
Assunto(s): Data Warehouse; ETL; Indoor Radon; Iot; OLAP; Data Analytics
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 foster even better models.
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). R.A. was supported by operation NORTE-06-3559-FSE-000226, funded by Norte Portugal Regional Operational Program (NORTE 2020), under the PORTUGAL 2020 Partnership Agreement, through the European Social Fund (ESF). 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.
