Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities

Abstract

Since earthquake is one of the most dangerous natural phenomena, it is necessary to be prepared for the negative consequences of the earthquake in advance. It is very important that healthcare facilities must continue to provide service during and after an earthquake. Therefore, this study focuses on designing a data warehouse model for the earthquake risk assessment of healthcare facilities which are needed much more than other public buildings physically. The proposed design utilizes a fact constellation schema model and take a public legislation containing principles regarding identification of risky buildings. This solution can provide a repository for data regarding earthquake risk assessment from different operational systems and play a key role in supporting critical decision-making process.