indoor exposure risk. The exposure to high radon
concentrations increases the risk of developing lung
cancer. This risk increases in areas with a specific
geological constitution and poorly ventilated
buildings. These two factors are prevalent in public
buildings in the center and northern Portugal. In this
context, the RnMonitor platform was created to
perform continuous indoor radon monitoring in
several public buildings in the North of Portugal. This
paper presents the development of a data warehouse
capable of storing all the measurements’ history and
some derived measures, which has been integrated as
an additional module with the RnMonitor platform.
The data are loaded to the data warehouse through the
execution of an ETL process created for this purpose.
An OLAP server has been coupled to the data
warehouse to support OLAP cubes and business
intelligence tools.
ACKNOWLEDGEMENTS
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.
REFERENCES
Apa. (2010). Qualidade do Ar em Espaços Interiores Um
Guia Técnico 2010.
Azevedo, R., Silva, J. P., Lopes, N., Curado, A., & Lopes,
S. I. (2020). Short-term indoor radon gas study in a
granitic school building: A comparative analysis of
occupation periods. Lecture Notes of the Institute for
Computer Sciences, Social-Informatics and
Telecommunications Engineering, LNICST, 323
LNICST, 80–89. https://doi.org/10.1007/978-3-030-
51005-3_9
Azevedo, R., Silva, J. P., Lopes, N., Curado, A., & Lopes,
S. I. (2021). Short-Term Indoor Radon Gas Assessment
in Granitic Public Buildings: A Multi-Parameter
Approach. Advances in Science, Technology and
Innovation, 3, 415–418. https://doi.org/10.1007/978-3-
030-35533-3_50
Curado, A., & Lopes, S. I. (2016). Impact of Human
Occupation on Indoor Radon Concentration : a Study
Based on in-Situ Measurements for a Set of Households
in Alto-Minho ,. 4th European Conference on
Behaviour and Energy Efficiency (Behave 2016),
September, 8–9.
Curado, A., Silva, J., Carvalho, L., & Lopes, S. I. (2017).
Indoor Radon concentration assessment in a set of
single family houses: Case study held in Barcelos,
North of Portugal. Energy Procedia, 136, 109–114.
https://doi.org/10.1016/j.egypro.2017.10.295
Curado, A., Silva, J. P., & Lopes, S. I. (2019). Radon risk
analysis in a set of public buildings in Minho region,
Portugal: from short-term monitoring to radon risk
assessment. Procedia Structural Integrity, 22(2019),
386–392. https://doi.org/10.1016/j.prostr.2020.01.048
Darby, S., Hill, D., Auvinen, A., Barros-Dios, J. M.,
Baysson, H., Bochicchio, F., Deo, H., Falk, R.,
Forastiere, F., Hakama, M., Heid, I., Kreienbrock, L.,
Kreuzer, M., Lagarde, F., Mäkeläinen, I., Muirhead, C.,
Oberaigner, W., Pershagen, G., Ruano-Ravina, A., …
Doll, R. (2005). Radon in homes and risk of lung
cancer: Collaborative analysis of individual data from
13 European case-control studies. British Medical
Journal, 330(7485), 223–226. https://doi.org/10.1136/
bmj.38308.477650.63
European Commission. (2014). Council Directive
2013/59/Euratom of 5 December 2013 laying down
basic safety standards for protection against the dangers
arising from exposure to ionising radiation, and
repealing Directives 89/618/Euratom, 90/641/Euratom,
96/29/Euratom, 97/43/Euratom a. Off J Eur Commun
L13, December 2003, 1–73.
García-Tobar, J. (2020). Study of Indoor Radon Using Data
Mining Models Based on OLAP Cubes. Physical
Science International Journal, December, 53–61.
https://doi.org/10.9734/psij/2020/v24i1030219
Gaskin, J., Coyle, D., Whyte, J., & Krewksi, D. (2018).
Global Estimate of Lung Cancer Mortality Attributable
to Residential Radon. Environmental Health
Perspectives, 126(May), 1–9. https://doi.org/10.12
89/EHP2503
George, A. C. (1984). Passive, integrated measurement of
indoor radon using activated carbon. Health Physics,
46(4), 867–872. https://doi.org/10.1097/00004032-
198404000-00012
Lopes, Sérgio I., Cruz, A. M., Moreira, P. M., Abreu, C.,
Silva, J. P., Lopes, N., Vieira, J. M. N., & Curado, A.
(2019). On the design of a Human-in-The-Loop Cyber-
Physical System for online monitoring and active
mitigation of indoor Radon gas concentration. 2018