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

Mert Özcan; Serhat Peker

doi:10.35377/saucis.04.01.872729

EN

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

References

AFAD, “DDA Catalog,” 2020. https://deprem.afad.gov.tr/ddakatalogu?lang=en (accessed Nov. 30, 2020).
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.
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.
“OECD Health Statistics,” OECD, 2020. https://stats.oecd.org/viewhtml.aspx?datasetcode=HEALTH_REAC&lang=en# (accessed Dec. 11, 2020).
“Health Statistics Yearbook,” Ankara, 2018. [Online]. Available: https://dosyamerkez.saglik.gov.tr/Eklenti/39024,haber-bulteni-2019pdf.pdf?0.
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.
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.
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.

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.
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.
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.
I. Güratan, “The Design and Development of a Data Warehouse Using Sales Database and Requirements of a Retail Group,” Dokuz Eylul University, 2005.
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.
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.
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.
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.
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.
T. Panrungsri and E. Sangiamkul, “Business intelligence model for disaster management: A case study in Phuket, Thailand,” 2017.
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.
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.
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.
Riskli Yapıların Tespit Edi̇lmesi̇ne İli̇şki̇n Esaslar. Turkey, 2019, p. 55.
Y. Bassil, “A Data Warehouse Design for a Typical University Information System,” J. Comput. Sci. Res., vol. 1, no. 6, pp. 12–17, 2012.

Details

Primary Language

English

Subjects

Computer Software , Software Engineering (Other)

Journal Section

Research Article

Authors

Mert Özcan ^*
0000-0002-6083-1813
Türkiye

Serhat Peker
0000-0002-6876-3982
Türkiye

Publication Date

April 30, 2021

Submission Date

February 1, 2021

Acceptance Date

March 24, 2021

Published in Issue

Year 1970 Volume: 4 Number: 1

DOI

https://doi.org/10.35377/saucis.04.01.872729

IZ

https://izlik.org/JA93ZF42BM

Cite

RIS / Bibtex

APA

Özcan, M., & Peker, S. (2021). Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. Sakarya University Journal of Computer and Information Sciences, 4(1), 156-165. https://doi.org/10.35377/saucis.04.01.872729

AMA

1.Özcan M, Peker S. Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. SAUCIS. 2021;4(1):156-165. doi:10.35377/saucis.04.01.872729

Chicago

Özcan, Mert, and Serhat Peker. 2021. “Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities”. Sakarya University Journal of Computer and Information Sciences 4 (1): 156-65. https://doi.org/10.35377/saucis.04.01.872729.

EndNote

Özcan M, Peker S (April 1, 2021) Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. Sakarya University Journal of Computer and Information Sciences 4 1 156–165.

IEEE

[1]M. Özcan and S. Peker, “Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities”, SAUCIS, vol. 4, no. 1, pp. 156–165, Apr. 2021, doi: 10.35377/saucis.04.01.872729.

ISNAD

Özcan, Mert - Peker, Serhat. “Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities”. Sakarya University Journal of Computer and Information Sciences 4/1 (April 1, 2021): 156-165. https://doi.org/10.35377/saucis.04.01.872729.

JAMA

1.Özcan M, Peker S. Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. SAUCIS. 2021;4:156–165.

MLA

Özcan, Mert, and Serhat Peker. “Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities”. Sakarya University Journal of Computer and Information Sciences, vol. 4, no. 1, Apr. 2021, pp. 156-65, doi:10.35377/saucis.04.01.872729.

Vancouver

1.Mert Özcan, Serhat Peker. Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. SAUCIS. 2021 Apr. 1;4(1):156-65. doi:10.35377/saucis.04.01.872729

Cited By

Process Mining in Manufacturing: A Literature Review

Sakarya University Journal of Computer and Information Sciences

https://doi.org/10.35377/saucis...1134293

Worldwide Significant Earthquakes Data Analytics Using Business Intelligence Techniques

Sinop Üniversitesi Fen Bilimleri Dergisi

https://doi.org/10.33484/sinopfbd.1751220