Towards Multidimensional Requirement Design

Abstract. Data warehouses (DW) main objective is to facilitating decisionmaking. Thus their development has to take into account DW project actor requirements. While much recent research has been focused on the design of multidimensional conceptual models, only few works were done to develop models and tools to analyze them. Despite specificities (OLAP, historicization, ...) of these requirements, most of the previous works used an E/R or UML schemas which do not allow designers to represent these specific principles. A main property of DW is that they are derived from existing data sources. Therefore, ExtractionTransformation-Loading (ETL) processes from these sources to the DW are very useful to define a reliable DW. In this paper, we fill this gap by showing how to systematically derive a conceptual schema of actors requirements using a rule-based mechanism. We provide a conceptual model which tries to be close to user vision of data by extending an object-oriented multidimensional ...

• Type: Conference
• Year: 2006
• Where: DAWAK
• Authors: Estella Annoni, Franck Ravat, Olivier Teste, Gilles Zurfluh
• Keywords: Account Dw Project, Conceptual Model, DAWAK 2006, Information Management, Multidimensional Conceptual Models