ORE: an iterative approach to the design and evolution of multi-dimensional schemas

  • Authors:
  • Petar Jovanovic;Oscar Romero;Alkis Simitsis;Alberto Abelló

  • Affiliations:
  • Universitat Politècnica de Catalunya & BarcelonaTech, Barcelona, Spain;Universitat Politècnica de Catalunya & BarcelonaTech, Barcelona, Spain;HP Labs, Palo Alto, CA, USA;Universitat Politècnica de Catalunya & BarcelonaTech, Barcelona, Spain

  • Venue:
  • Proceedings of the fifteenth international workshop on Data warehousing and OLAP
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

Designing a data warehouse (DW) highly depends on the information requirements of its business users. However, tailoring a DW design that satisfies all business requirements is not an easy task. In addition, complex and evolving business environments result in a continuous emergence of new or changed business needs. Furthermore, for building a correct multidimensional (MD) schema for a DW, the designer should deal with the semantics and heterogeneity of the underlying data sources. To cope with such an inevitable complexity, both at the beginning of the design process and when a potential evolution event occurs, in this paper we present a semi-automatic method, named ORE, for constructing the MD schema in an iterative fashion based on the information requirements. In our approach, we consider each requirement separately and incrementally build the unified MD schema satisfying the entire set of requirements.