Uclean: A Requirement Based Object-Oriented Etl Framework

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.