Flexible & Adaptive ETL architecture

From Master Projects
Revision as of 19:38, 17 February 2009 by Ane800 (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

has title::Flexible & Adaptive ETL architecture
status: finished
Master: project within::Software Engineering
Student name: student name::Albert Nubé
number: student number::1143131
Start start date:=2008/07/10
End end date:=2009/01/31
Supervisor: Hans van Vliet
Second reader: has second reader::Steven Klusener
Poster: has poster::Media:Media:Posternaam.pdf

Signature supervisor



An important area in today’s Business Intelligence is the usage of Data warehousing technology to support decision making. A data warehouse provides structured (star, snowflake schemas) analytical data by integrating and transforming operational (OLTP) and external data from various systems. This data integration process is realized by ETL (Extraction Transformation and Loading). If the structure of the data warehouse is required to change (changed information demand) the ETL process will be required to change as well. This thesis proposes an architecture that can be implemented with current ETL tools, providing for a flexible ETL process able to cope with change.