Multidimensional normal forms for data warehouse design

  • Authors:
  • Jens Lechtenbörger;Gottfried Vossen

  • Affiliations:
  • Department of Information Systems, University of Muenster, Leonardo-Campus 3, D-48149 Muenster, Germany;Department of Information Systems, University of Muenster, Leonardo-Campus 3, D-48149 Muenster, Germany

  • Venue:
  • Information Systems
  • Year:
  • 2003

Quantified Score

Hi-index 0.00

Visualization

Abstract

A data warehouse is an integrated and time-varying collection of data derived from operational data and primarily used in strategic decision making by means of OLAP techniques. Although it is generally agreed that warehouse design is a non-trivial problem and that multidimensional data models as well as star or snowflake schemata are relevant in this context, there exist neither methods for deriving such a schema from an operational database nor measures for evaluating a warehouse schema. In this paper, a sequence of multidimensional normal forms is established that allow reasoning about the quality of conceptual data warehouse schemata in a rigorous manner. These normal forms address traditional database design objectives such as faithfulness, completeness, and freedom of redundancies as well as the notion of summarizability, which is specific to multidimensional database schemata.