Araştırma Makalesi
PDF Zotero Mendeley EndNote BibTex Kaynak Göster

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

Yıl 2021, Cilt 4, Sayı 1, 156 - 165, 30.04.2021
https://doi.org/10.35377/saucis.04.01.872729

Öz

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.

Kaynakça

  • 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.

Yıl 2021, Cilt 4, Sayı 1, 156 - 165, 30.04.2021
https://doi.org/10.35377/saucis.04.01.872729

Öz

Kaynakça

  • 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.

Ayrıntılar

Birincil Dil İngilizce
Konular Bilgisayar Bilimleri, Bilgi Sistemleri, Bilgisayar Bilimleri, Disiplinler Arası Uygulamalar
Bölüm Makaleler
Yazarlar

Mert ÖZCAN (Sorumlu Yazar)
IZMIR BAKIRCAY UNIVERSITY
0000-0002-6083-1813
Türkiye


Serhat PEKER
IZMIR BAKIRCAY UNIVERSITY
0000-0002-6876-3982
Türkiye

Yayımlanma Tarihi 30 Nisan 2021
Başvuru Tarihi 1 Şubat 2021
Kabul Tarihi 24 Mart 2021
Yayınlandığı Sayı Yıl 2021, Cilt 4, Sayı 1

Kaynak Göster

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