A methodological framework for conceptual data warehouse design

  • Authors:
  • Leopoldo Zepeda;Matilde Celma;Ramón Zatarain

  • Affiliations:
  • Inst. Tecnológico de Culiacán, Cln. Sin., México;Universidad Politécnica de Valencía, Val. España;Inst. Tecnológico de Culiacán, Cln. Sin., México

  • Venue:
  • Proceedings of the 43rd annual Southeast regional conference - Volume 1
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.