Automating Data warehouse design using ontology

Requirement Analysis is a crucial and arduous task in data warehouse design process. We provide a solution to support data warehouse design, which combines need driven and data driven design approaches. Our solution is based on ontology representation language and work results on ontology alignment. Our design method occurs in two steps. The first one, which is interactive and semi-automatic, transforms user requirements into ontologies, the second step that is fully automatic, aligns the resulting ontologies from the first step and produces an ontology associated to the Multidimensional Data model. The waste management field will be our guideline to illustrate our approach.