Flexible & Adaptive ETL architecture

From Master Projects
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
Dates
Start start date:=2008/07/10
End end date:=2009/01/31
Supervision
Supervisor: Hans van Vliet
Second reader: has second reader::Steven Klusener
Poster: has poster::Media:Media:Posternaam.pdf

Signature supervisor



..................................

Abstract

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.