Academic Journals Database
Disseminating quality controlled scientific knowledge

Uclean: A Requirement Based Object-Oriented Etl Framework

Author(s): Payal Pahwa | Shweta Taneja | Garima Thakur

Journal: International Journal of Computer Science and Engineering Survey
ISSN 0976-3252

Volume: 2;
Issue: 4;
Start page: 45;
Date: 2011;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: Data warehouse | ETL | Data cleaning & UML

Data warehouse is used to provide effective results from multidimensional data analysis. The accuracyand correctness of these results depend on the quality of the data. To improve data quality, data must beproperly extracted, transformed and loaded into the data warehouse. This ETL process is the key to thesuccess of a data warehouse. In this paper we propose a conceptual ETL framework for an objectoriented data warehouse design, the framework is called UCLEAN. This framework takes into accountthe concept of requirements of the users .The data is extracted from different UML sources and isconverted into a multidimensional model. It is then cleaned and loaded in the data warehouse. Wevalidate the effectiveness of the framework through a case study.

Tango Jona
Tangokurs Rapperswil-Jona

     Save time & money - Smart Internet Solutions