Yıl 2021, Cilt 4 , Sayı 1, Sayfalar 156 - 165 2021-04-30

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

Mert ÖZCAN [1] , Serhat PEKER [2]


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.
Data warehouse, data management, multidimensional data model, data mining, decision support systems, business intelligence and analytics
  • 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 İ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.
Birincil Dil en
Konular Bilgisayar Bilimleri, Bilgi Sistemleri, Bilgisayar Bilimleri, Disiplinler Arası Uygulamalar
Bölüm Makaleler
Yazarlar

Orcid: 0000-0002-6083-1813
Yazar: Mert ÖZCAN (Sorumlu Yazar)
Kurum: IZMIR BAKIRCAY UNIVERSITY
Ülke: Turkey


Orcid: 0000-0002-6876-3982
Yazar: Serhat PEKER
Kurum: IZMIR BAKIRCAY UNIVERSITY
Ülke: Turkey


Tarihler

Başvuru Tarihi : 1 Şubat 2021
Kabul Tarihi : 24 Mart 2021
Yayımlanma Tarihi : 30 Nisan 2021

Bibtex @araştırma makalesi { saucis872729, journal = {Sakarya University Journal of Computer and Information Sciences}, issn = {}, eissn = {2636-8129}, address = {}, publisher = {Sakarya Üniversitesi}, year = {2021}, volume = {4}, pages = {156 - 165}, doi = {10.35377/saucis.04.01.872729}, title = {Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities}, key = {cite}, author = {Özcan, Mert and Peker, Serhat} }
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 . DOI: 10.35377/saucis.04.01.872729
MLA Özcan, M , Peker, S . "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 (2021 ): 156-165 <http://saucis.sakarya.edu.tr/tr/pub/issue/59732/872729>
Chicago Özcan, M , Peker, S . "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 (2021 ): 156-165
RIS TY - JOUR T1 - Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities AU - Mert Özcan , Serhat Peker Y1 - 2021 PY - 2021 N1 - doi: 10.35377/saucis.04.01.872729 DO - 10.35377/saucis.04.01.872729 T2 - Sakarya University Journal of Computer and Information Sciences JF - Journal JO - JOR SP - 156 EP - 165 VL - 4 IS - 1 SN - -2636-8129 M3 - doi: 10.35377/saucis.04.01.872729 UR - https://doi.org/10.35377/saucis.04.01.872729 Y2 - 2021 ER -
EndNote %0 Sakarya University Journal of Computer and Information Sciences Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities %A Mert Özcan , Serhat Peker %T Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities %D 2021 %J Sakarya University Journal of Computer and Information Sciences %P -2636-8129 %V 4 %N 1 %R doi: 10.35377/saucis.04.01.872729 %U 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 (Nisan 2021): 156-165 . https://doi.org/10.35377/saucis.04.01.872729
AMA Ö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.
Vancouver Özcan M , Peker S . Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. Sakarya University Journal of Computer and Information Sciences. 2021; 4(1): 156-165.
IEEE M. Özcan ve S. 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, c. 4, sayı. 1, ss. 156-165, Nis. 2021, doi:10.35377/saucis.04.01.872729