Data Mart of Climate Changes: a Proposed Approach to Support Sustainable Decision-Making
DOI:
https://doi.org/10.34010/injiiscom.v7i1.14878Keywords:
Climate changes, Decision-making, data mart, ETL, Power BIAbstract
The growing focus on climate change requires effective data-driven decision-making to promote sustainability. This study proposes a data mart framework to manage and analyze climate datasets from a station in Basrah, Iraq. The model aims to support sustainable decisions by examining factors like temperature, solar radiation, rainfall, wind direction, humidity, and wind speeds at various altitudes. A star schema facilitates online analytical processing (OLAP) and future advanced analytics. Power BI is utilized for data visualization, providing actionable insights to stakeholders via real-time indicators and customizable dashboards. This framework aids short-term decision-making regarding climate impacts, with future work incorporating machine learning for predictive pattern forecasting.
References
Balti, H., Abbes, A. B., Mellouli, N., Farah, I. R., Sang, Y., & Lamolle, M. (2022). Multidimensional architecture using a massive and heterogeneous data: Application to drought monitoring. Future Generation Computer Systems, 136, 1-14.
Becker, L. T., & Gould, E. M. (2019). Microsoft power BI: extending excel to manipulate, analyze, and visualize diverse data. Serials Review, 45(3), 184-188.
Costa, C., Andrade, C., & Santos, M. Y. (2019). Big Data Warehouses for Smart Industries. 1-11.
da Cunha, L., Ferreira, M. S., Cerqueira, R., & Namen, A. A. (2023). The effect of long-term climatic variability on wild mammal populations in a tropical forest hotspot: A business intelligence framework. Ecological Informatics, 73, 101924-101935.
Dahr, J. M., Hamoud, A. K., Najm, I. A., & Ahmed, M. I. (2022). Implementing sales decision support system using data mart based on olap, kpi, and data mining approaches. Journal of engineering science and technology, 17(1), 275-293.
Dhingra, S. (2018). Measuring the service quality of automated teller machines: a study of banks of India. International Journal of Business Excellence, 15(4), 411-424.
Djiroun, R., Lachachi, L. Y., Azzouni, N. F. E., Guessoum, M. A., Boukhalfa, K., & hadj Benkhelifa, E. (2023, December). Search Approach for External Data Sources for Data Warehouse Enrichment in Business Intelligence Context. In 2023 20th ACS/IEEE International Conference on Computer Systems and Applications (AICCSA) (pp. 1-8). IEEE.
Gad, I., & Manjunatha, B. R. (2017, April). Hybrid data warehouse model for climate big data analysis. In 2017 International Conference on Circuit, Power and Computing Technologies (ICCPCT) (pp. 1-9). IEEE.
Doutreligne, M., Degremont, A., Jachiet, P. A., Lamer, A., & Tannier, X. (2023). Good practices for clinical data warehouse implementation: A case study in France. PLOS Digital Health, 2(7), e0000298.
El Mhouti, A., Fahim, M., Soufi, A., & El Alama, I. (2022). A Web Scraping Framework for Descriptive Analysis of Meteorological Big Data for Decision-Making Purposes. International Journal of Hybrid Innovation Technologies, 2(1), 47-64.
Farhan, M. S., Youssef, A., & Abdelhamid, L. (2024). A Model for Enhancing Unstructured Big Data Warehouse Execution Time. Big Data and Cognitive Computing, 8(2), 17-28.
Ferreira, P. J., de Almeida, A., & Bernardino, J. (2017). Data Warehousing in the Cloud: Amazon Redshift vs Microsoft Azure SQL. In KDIR (pp. 318-325).
Garani, G., Papadatos, D., Kotsiantis, S., & Verykios, V. S. (2022, October). Meteorological data warehousing and analysis for supporting air navigation. In Informatics (Vol. 9, No. 4, p. 78). MDPI.
Gopalkrishnan, V., Li, Q., & Karlapalem, K. (1999, August). Star/snow-flake schema driven object-relational data warehouse design and query processing strategies. In International Conference on Data Warehousing and Knowledge Discovery (pp. 11-22). Berlin, Heidelberg: Springer Berlin Heidelberg.
Hamoud, A. K., Abd Ulkareem, M., Hussain, H. N., Mohammed, Z. A., & Salih, G. M. (2020). Improve HR decision-making based on data mart and OLAP. Journal of Physics: Conference Series, 1530(1), 12058-12068.
Hamoud, A. K., Marwah, K. H., Alhilfi, Z., & Sabr, R. H. (2021). Implementing data-driven decision support system based on independent educational data mart. International Journal of Electrical and Computer Engineering, 11(6), 5301-5313.
Hashim, H. (2020). Hybrid warehouse model and solutions for climate data analysis. Journal of Computer and Communications, 8(10), 75-86.
Jain, H., Dhupper, R., Shrivastava, A., Kumar, D., & Kumari, M. (2023). AI-enabled strategies for climate change adaptation: protecting communities, infrastructure, and businesses from the impacts of climate change. Computational Urban Science, 3(1), 25.
Khan, B., Jan, S., Khan, W., & Chughtai, M. I. (2024). An Overview of ETL Techniques, Tools, Processes and Evaluations in Data Warehousing. Journal on Big Data, 6.
Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2008). The data warehouse lifecycle toolkit. John Wiley & Sons.
Metre, K. V., Mathur, A., Dahake, R. P., Bhapkar, Y., Ghadge, J., Jain, P., & Gore, S. (2024). An Introduction to Power BI for Data Analysis. International Journal of Intelligent Systems and Applications in Engineering, 12(1s), 142-147.
Najm, I. A., Dahr, J. M., Hamoud, A. K., Alasady, A. S., Awadh, W. A., Kamel, M. B. M., & Humadi, A. M. (2022). OLAP Mining with Educational Data Mart to Predict Students’ Performance. Informatica, 46(5), 378-391.
Namnual, T., Nilsook, P., & Wannapiroon, P. (2019). System architecture of data warehousing with ontologies to enhance digital entrepreneurs’ competencies for higher education. International Journal of Information and Education Technology, 9(6), 414-418.
Nwanakwaugwu, A. C., Matthew, U. O., Kazaure, A. A., & Haruna, K. (2023). Data Mining Business Intelligence Applications in Retail Services Using Artificial Neural Networks. In Handbook of Research on Cybersecurity Risk in Contemporary Business Systems (pp. 186-210). IGI Global.
Roy, S., Raj, S., Chakraborty, T., Chakrabarty, A., Cortesi, A., & Sen, S. (2024). Efficient OLAP query processing across cuboids in distributed data warehousing environment. Expert Systems with Applications, 239, 122481.
Sahama, T., & Croll, P. (2007). A data warehouse architecture for clinical data warehousing. In ACSW Frontiers 2007: Proceedings of 5th Australasian Symposium on Grid Computing and e-Research, 5th Australasian Information Security Workshop (Privacy Enhancing Technologies), and Australasian Workshop on Health Knowledge Management and Discovery (pp. 227-232). Australian Computer Society.
Reddy, G. S., Srinivasu, R., Rao, M. P. C., & Rikkula, S. R. (2010). Data Warehousing, Data Mining, OLAP and OLTP Technologies are essential elements to support decision-making process in industries. International Journal on Computer Science and Engineering, 2(9), 2865-2873.
Shah, I. H., Manzoor, M. A., Jinhui, W., Li, X., Hameed, M. K., Rehaman, A., ... & Chang, L. (2024). Comprehensive review: Effects of climate change and greenhouse gases emission relevance to environmental stress on horticultural crops and management. Journal of Environmental Management, 351, 119978-119987.
Shahin, D., Awad, M., & Fraihat, S. (2021). Meteorological data analytic system: Descriptive and predictive analysis. Journal of Theoretical and Applied Information Technology (JTAIT), 99(14).
Teixeira, J. W., Annibal, L. P., Felipe, J. C., Ciferri, R. R., & de Aguiar Ciferri, C. D. (2015). A similarity-based data warehousing environment for medical images. Computers in Biology and Medicine, 66, 190-208.
Ugonnia, J. C., Olaniyi, O. O., Olaniyi, F. G., Arigbabu, A. A., & Oladoyinbo, T. O. (2024). Towards sustainable it infrastructure: Integrating green computing with data warehouse and big data technologies to enhance efficiency and environmental responsibility. Journal of Engineering Research and Reports, 26(5), 247-261.
Von Lubitz, D., & Patricelli, F. (2007). Network-centric healthcare operations: data warehousing and the associated telecommunications platforms. International Journal of Services and Standards, 3(1), 97-119.
Zhang, H., Ren, S., Li, X., Baharin, H., Alghamdi, A., & Alghamdi, O. A. (2023). Developing scalable management information system with big financial data using data mart and mining architecture. Information Processing & Management, 60(3), 103326.
Zhu, Z. (2024). Data Warehousing, Data Lakes and Data Lakehouses. In Data Warehousing, Data Lakes and Data Lakehouses. https://doi.org/10.4135/9781071937471
