An ETL strategy for real-time data warehouse

Abstract

Real-time data warehouse as an extension of traditional data warehouse, it is effectively shortening the delay of information and providing timely and accurate decision support to decision makers. The ETL processing is the core technology of data warehouse, especially in real-time data warehouse. This paper is analyzing the current mainstream technology for real-time ETL. We propose a way to capture changed data which is based on log analysis and log listening. This method provides an effective solution for the huge amount of data, which greatly improve system performance. © 2011 Springer-Verlag Berlin Heidelberg.