Research Article
BibTex RIS Cite
Year 2021, Volume: 4 Issue: 1, 156 - 165, 30.04.2021
https://doi.org/10.35377/saucis.04.01.872729

Abstract

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

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

Year 2021, Volume: 4 Issue: 1, 156 - 165, 30.04.2021
https://doi.org/10.35377/saucis.04.01.872729

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.

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 İ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.
There are 23 citations in total.

Details

Primary Language English
Subjects Computer Software, Software Engineering (Other)
Journal Section Articles
Authors

Mert Özcan 0000-0002-6083-1813

Serhat Peker 0000-0002-6876-3982

Publication Date April 30, 2021
Submission Date February 1, 2021
Acceptance Date March 24, 2021
Published in Issue Year 2021Volume: 4 Issue: 1

Cite

IEEE 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, 2021, 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

Sakarya University Journal of Computer and Information Sciences in Applied Sciences and Engineering: An interdisciplinary journal of information science      28938