DATA MODELS AND ARCHITECTURES IN DATA WAREHOUSING
Keywords:
Data warehousing, Two level architecture, Three level architecture, ETL processes, Data marts.Abstract
The separation between transactional computing and data analysis ensures that the transactional systems responsible for processing and recording business transactions can operate efficiently and without interruption. Meanwhile, data analysis systems can focus on processing and analyzing large amounts of data to extract valuable insights that can inform business decisions. By employing different data warehousing architectures and models, organizations can separate these two functions, preventing the resource-intensive data analysis processes from interfering with the smooth functioning of the transactional systems.
References
https://learndatamodeling.com/blog/category/data-modeling
https://blog.chromia.com/ai-meets-relational-blockchain-the-benefits-of-integrating-with-chromia
https://biztech.dev/deciphering-database-development-demystifying-the-data
https://serverlogic3.com/what-is-role-and-structure-of-the-data-warehousing
https://www.kingswaysoft.com/resources/industry-analysis/unlocking-the-power-of-etl
Aldoseri, Abdulaziz, and Khalifa Al-Khalifa. "Re-Thinking Data Strategy and Integration for Artificial Intelligence: Concepts, Opportunities, and Challenges." Applied Sciences, vol. 13, no. 12, 2023, p. 7082.
