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 decisionmaking process.

Process Mining in Manufacturing: A Literature Review

“…Information systems containing many open process models, such as supply chain management systems (SCM), financial systems (FS), and customer relationship management systems (CRM), can be given as examples. The processing and analysis of data obtained through business processes in information systems are manually performed [6,9,11]. With this workload in information systems, flexibility and definition have not received enough attention, as well as the developed open process concepts [1].…”