Metadata Driven Data Transformation

13 years 7 months ago
Metadata Driven Data Transformation
The bottleneck of a data warehouse implementation is the ETL (extraction, transformation, and load) process, which carries out the initial population of the data warehouse and its further (usually periodical) updates. There is a number of software products supporting the OLAP analysis. However, the ETL process implementation is not repeatable in a significant way. This paper reports on a research of a model-based data transformation applicable to data warehouse population and updates. The ETL process is based on a metadata repository, which contains data models of the data sources, the target data warehouse model, and the correspondence among them.
Petr Aubrecht, Zdenek Kouba
Added 31 Oct 2010
Updated 31 Oct 2010
Type Conference
Year 2001
Authors Petr Aubrecht, Zdenek Kouba
Comments (0)