Business Alignment-Based Data Warehousing Physical Design Driven by Models

Jacques Simonin (1, 2) , Sébastien Bigaret (1, 2)

1 Lab-STICC_TB_CID_DECIDE
2 LUSSI - Département Logique des Usages, Sciences sociales et Sciences de l'Information

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.

Mots clés: Data warehouse; Physical design; Model driven engineering; Model transformation tooling

Domaines: Ordinateur et société [cs.CY]

Jacques Simonin, Sébastien Bigaret. Business Alignment-Based Data Warehousing Physical Design Driven by Models. RCIS 2013 : the 7th IEEE International Conference on Research Challenges in Information Science, May 2013, Paris, France. pp.167 - 178, ⟨10.1109/RCIS.2013.6577688⟩. ⟨hal-00856723⟩