Architecture for Near Zero Latency in Datawarehouse

Data warehouse (DW) has been widely recognized as an effective solution for integrating diverse information systems. In addition, DW supplies a platform for business intelligence applications which aims to improve the process of decision making. At execution level, after the first load, DW is regularly populated with fresh data by Extraction, Transformation and Loading processes. In real setting, DW refreshment is an event managed by DW administrators. Still, non freshness of data is a drawback of classical DW system. In this article, the authors have suggested a solution for this issue, by presenting architecture of near real time DW. They visit DW system layers and they show how they should cooperate. Finally, the author have defined the scope and the challenge of each layer simultaneously with their suggestion to fill its mission