A methodological framework for conceptual data warehouse design
Leopoldo Zepeda, Matilde Celma, Ramón Zataraín Cabada · 2005
A Data Warehouse (DW) has been an approach adopted for giving support to the process of taking decisions in an organization. This paper is concerned with the data warehouse conceptual schema design starting from the conceptual operational schemas and user requirements. We propose and illustrate an algorithm for automatic conceptual schema development. Our algorithm uses an enterprise schema represented with UML as a starting point for source driven data warehouse schema design and produces a set of multidimensional candidates schemas. The candidates schemas are created using an UML profile for data warehouse. Next the automatic generation of multidimensional schemas we use user requirements to guide the selection of the candidates schemas most likely to meet users needs.