The evolution of ETL architecture: From traditional data warehousing to real-time data integration
Independent Researcher, USA.
Review Article
World Journal of Advanced Research and Reviews, 2019, 01(03), 073–084
Publication history:
Received on 09 March 2019; revised on 23 April 2019; accepted on 26 April 2019
Abstract:
This paper explores the evolution of Extract, Transform, Load (ETL) architectures, tracing the shift from traditional, batch-oriented ETL processes in data warehousing to realtime data integration frameworks. ETL has been a fundamental component in enabling data warehousing and business intelligence for several decades. However, the demand for faster insights and real-time decision-making has driven ETL towards real-time data integration solutions. This paper discusses traditional ETL methods, examines the changes leading to real-time ETL, and explores architectural patterns and challenges associated with each paradigm.
Keywords:
ETL; Data Warehousing; Real-Time Integration; Data Transformation; Business Intelligence
Full text article in PDF:
Copyright information:
Copyright © 2019 Author(s) retain the copyright of this article. This article is published under the terms of the Creative Commons Attribution Liscense 4.0