Business alignment-based data warehousing physical design driven by models

An assessment of a method that enabled to design a data warehouse logical model in accordance with the business viewpoint of an enterprise showed that not considering the physical viewpoint when designing the data warehouse was the major flaw of the method, and that a tool has to be proposed to generate the data warehouse data instances when business viewpoints or input databases are modified. Our contribution is hence the adaptation of the logical design method of the data warehouse to a physical design method. Moreover, a tooling of this new physical design method and a tooling of the data warehouse physical data instantiation are proposed in this paper. The tools are based on the model driven engineering approach and its associated environment such as a model transformation language.