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.

Keywords

• Data warehouse
• data management
• multidimensional data model
• data mining
• decision support systems
• business intelligence and analytics

References

1. AFAD, “DDA Catalog,” 2020. https://deprem.afad.gov.tr/ddakatalogu?lang=en (accessed Nov. 30, 2020).
2. M. M. Önal and S. Çellek, “A Study To Determine The Quality Of Building Stock And Earthquake Risk In Kirsehir,” Int. J. Sci. Technol. Res., vol. 6, no. 4, pp. 105–111, 2017.
3. A. Ketsap, C. Hansapinyo, N. Kronprasert, and S. Limkatanyu, “Uncertainty and Fuzzy Decisions in Earthquake Risk Evaluation of Buildings,” Eng. J., vol. 23, no. 5, pp. 89–105, 2019, doi: 10.4186/ej.2019.23.5.89.
4. “OECD Health Statistics,” OECD, 2020. https://stats.oecd.org/viewhtml.aspx?datasetcode=HEALTH_REAC&lang=en# (accessed Dec. 11, 2020).
5. “Health Statistics Yearbook,” Ankara, 2018. [Online]. Available: https://dosyamerkez.saglik.gov.tr/Eklenti/39024,haber-bulteni-2019pdf.pdf?0.
6. G. Garani, A. V. Chernov, I. K. Savvas, and M. A. Butakova, “A Data Warehouse Approach for Business Intelligence,” in 28th International Conference on Enabling Technologies: Infrastructure for Collaborative Enterprises, 2019, pp. 70–75, doi: 10.1109/WETICE.2019.00022.
7. S. H. A. El-Sappagh, A. M. A. Hendawi, and A. H. El Bastawissy, “A proposed model for data warehouse ETL processes,” J. King Saud Univ. - Comput. Inf. Sci., vol. 23, no. 2, pp. 91–104, 2011, doi: 10.1016/j.jksuci.2011.05.005.
8. A. G. P. Kujur and A. Oraon, “A Data Warehouse Design and Usage,” vol. 3, no. 11, pp. 335–337, 2016, Accessed: Nov. 29, 2020. [Online]. Available: https://www.academia.edu/34467981/A_Data_Warehouse_Design_and_Usage.

9. M. Y. Santos, B. Martinho, and C. Costa, “Modelling and implementing big data warehouses for decision support,” J. Manag. Anal., vol. 4, no. 2, pp. 111–129, 2017, doi: 10.1080/23270012.2017.1304292.
10. B. A. Devlin and P. T. Murphy, “An architecture for a Information, business and System,” IBM Syst. J., vol. 27, no. 1, pp. 60–80, 1988, doi: 10.1007/978-3-319-77703-0_114.
11. J. M. Abraham Navamani, A. Kannammal, and P. R. Jeba Thangaiah, “Building multi-dimensional cube to analyze public examination results: A business intelligence approach,” Appl. Mech. Mater., vol. 622, pp. 11–22, 2014, doi: 10.4028/www.scientific.net/AMM.622.11.
12. I. Güratan, “The Design and Development of a Data Warehouse Using Sales Database and Requirements of a Retail Group,” Dokuz Eylul University, 2005.
13. D. Moody and M. A. . Kortink, “From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design,” in Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW’2000), 2000, pp. 1–12.
14. D. Moody and M. A. . Kortink, “From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design,” in International Workshop on Design and Management of Data Warehouses (DMDW’2000), 2000, vol. 28, pp. 1–12.
15. E. Demir and C. Eren Atay, “Akciğer Kanseri Verilerinin Karar Destek Sistemleri için Veri Ambarında Saklanması,” DEU Muhendis. Fak. Fen ve Muhendis., vol. 19, no. 57, pp. 987–997, 2017, doi: 10.21205/deufmd.2017195785.
16. G. N. A. Dharma, K. O. Saputra, and N. P. Sastra, “Data Warehouse Design for Hospital Executive information using the Facts Constellation Method (Case Study: Bali Mandara Eye Hospital),” vol. 5, no. 2, pp. 6–10, 2020.
17. S. Asghar, S. Fong, and T. Hussain, “Business intelligence modeling: A case study of disaster management organization in Pakistan,” in ICCIT 2009 - 4th International Conference on Computer Sciences and Convergence Information Technology, 2009, pp. 673–678, doi: 10.1109/ICCIT.2009.318.
18. T. Panrungsri and E. Sangiamkul, “Business intelligence model for disaster management: A case study in Phuket, Thailand,” 2017.
19. K. A. B. Permana, D. A. P. Wulandari, and P. A. Mertasana, “Online Analytical Processing ( OLAP ) for Disaster Report,” Int. J. Eng. Emerg. Technol., vol. 3, no. 1, pp. 26–29, 2018.
20. E. Işık, M. F. Işık, and M. A. Bülbül, “BetonarmeBi̇nalarin Web Tabanli HizDeğerlendi̇ri̇lmesi̇,” Uludağ Univ. J. Fac. Eng., vol. 23, no. 1, pp. 225–234, 2018, doi: 10.17482/uumfd.417978.
21. S. Sarı and T. Türk, “Depremde Meydana Gelebilecek Bina Hasarlarının Coğrafi Bilgi Sistemleri ile İncelenmesi,” Türkiye Coğrafi Bilgi Sist. Derg., vol. 2, no. 1, pp. 17–25, 2020, Accessed: Nov. 28, 2020. [Online]. Available: https://dergipark.org.tr/tr/pub/tucbis.
22. Riskli Yapıların Tespit Edi̇lmesi̇ne İli̇şki̇n Esaslar. Turkey, 2019, p. 55.
23. Y. Bassil, “A Data Warehouse Design for a Typical University Information System,” J. Comput. Sci. Res., vol. 1, no. 6, pp. 12–17, 2012.