Citation:

Prem Tamanam, 2023. "The Evolution of Smart Data Warehousing: How AI Is Taking Business Intelligence to Unimaginable Heights" ESP Journal of Engineering & Technology Advancements 3(3): 133-143.

Abstract:

It was established that Smart Data Warehousing (SDW) augments data warehousing with AI to advance business intelligence. This paper examines how new data warehousing solutions powered by AI technologies have transformed these raw data. The main focus areas are AI-enhanced SDW’s advantages, new automation trends, self-ranking analytics, and real-time decision-making. A science introduces methods and assesses frameworks with reference to examples. The resultant shows a tripling of capability and a refinement of data processing time and accuracy performances. Finally, this research brings outs the future prospects and potential issues with a focus on the factors that prompt the necessity of AI in data warehousing.

References:

[1] Bharadiya, J. P. (2023). Machine learning and AI in business intelligence: Trends and opportunities. International Journal of Computer (IJC), 48(1), 123-134.

[2] Eboigbe, E. O., Farayola, O. A., Olatoye, F. O., Nnabugwu, O. C., & Daraojimba, C. (2023). Business intelligence transformation through AI and data analytics. Engineering Science & Technology Journal, 4(5), 285-307.

[3] Zohuri, B., & Moghaddam, M. (2020). From business intelligence to artificial intelligence. Journal of Material Sciences & Manufacturing Research, 1(1), 1-10.

[4] Ahmed, P. K., Loh, A. Y., & Zairi, M. (1999). Cultures for continuous improvement and learning. Total Quality Management, 10(4-5), 426-434.

[5] Ahmadi, S. (2023). Security And Privacy Challenges in Cloud-Based Data Warehousing: A Comprehensive Review. International Journal of Computer Science Trends and Technology (IJCST)–Volume, 11.

[6] Kunnathuvalappil Hariharan, N. (2019). Trends in Data Warehousing Techniques. Naveen Kunnathuvalappil Hariharan.(2019). Trends in Data Warehousing Techniques. International Journal of Innovations in Engineering Research and Technology, 6(8), 7-14.

[7] Bouaziz, S., Nabli, A., & Gargouri, F. (2017). From traditional data warehouse to real time data warehouse. In Intelligent Systems Design and Applications: 16th International Conference on Intelligent Systems Design and Applications (ISDA 2016) held in Porto, Portugal, December 16-18, 2016 (pp. 467-477). Springer International Publishing.

[8] van Geest, M., Tekinerdogan, B., & Catal, C. (2021). Smart warehouses: Rationale, challenges and solution directions. Applied sciences, 12(1), 219.

[9] Jayanna Hallur, “Social Determinants of Health: Importance, Benifits to communites, and Best practices for data collection and utilzation,” International Journal of science and Research (IJSR). Volume 13, Issue 10, October 2024, pp, 846-852, https://www.ijsr.net/getabstract.php?paperid=SR241009065652

[10] Athalye, S. S., & Athalye, S. S. (2023, December). Review of Role of AI in Data Warehousing and Mining. In 2023 6th International Conference on Advances in Science and Technology (ICAST) (pp. 271-275). IEEE.

[11] Arrassen, I., Laaroussi, K., Rabhi, O., Erramdani, M., & Hassas, M. (2024, April). Impact of Artificial Intelligence on the Generation Process of the Data Warehouse Model. In International Conference on Smart Medical, IoT & Artificial Intelligence (pp. 59-67). Cham: Springer Nature Switzerland.

[12] Saxena, A., Celaya, J., Balaban, E., Goebel, K., Saha, B., Saha, S., & Schwabacher, M. (2008, October). Metrics for evaluating performance of prognostic techniques. In 2008 international conference on prognostics and health management (pp. 1-17). IEEE.

[13] Kulkarni, R. H., & Padmanabham, P. (2017). Integration of artificial intelligence activities in software development processes and measuring effectiveness of integration. Iet Software, 11(1), 18-26.

[14] Sasmal, S. (2024). Data Warehousing Revolution: AI-driven Solutions. International Research Journal of Engineering & Applied Sciences (IRJEAS), 12(1), 01-06.

[15] Panwar, V. AI-Driven Query Optimization: Revolutionizing Database Performance and Efficiency.

[16] Ajila, S. A., Lung, C. H., & Das, A. (2022). Analysis of error-based machine learning algorithms in network anomaly detection and categorization. Annals of Telecommunications, 77(5), 359-370.

[17] Gadde, H. (2020). AI-Enhanced Data Warehousing: Optimizing ETL Processes for Real-Time Analytics. Revista de Inteligencia Artificial en Medicina, 11(1), 300-327.

[18] Abrahiem, R. (2007, May). A new generation of middleware solutions for a near-real-time data warehousing architecture. In 2007 IEEE International Conference on Electro/Information Technology (pp. 192-197). IEEE.

[19] Sawadogo, P., & Darmont, J. (2021). On data lake architectures and metadata management. Journal of Intelligent Information Systems, 56(1), 97-120.

[20] Jacquin, S., Pawlewitz, J., & Doyle, A. (2020, May). Democratizing Data with Self-Service Analytics. In Offshore Technology Conference (p. D041S055R007). OTC.

Keywords:

Smart Data Warehousing, Artificial Intelligence, Business Intelligence, Data Processing, Automation.