Anchor Modeling

  • Authors:
  • Olle Regardt;Lars Rönnbäck;Maria Bergholtz;Paul Johannesson;Petia Wohed

  • Affiliations:
  • Affecto, Sweden;Affecto, Sweden;DSV, SU/KTH, Stockholm, Sweden;DSV, SU/KTH, Stockholm, Sweden;DSV, SU/KTH, Stockholm, Sweden

  • Venue:
  • ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Maintaining and evolving data warehouses is a complex, error prone, and time consuming activity. The main reason for this state of affairs is that the environment of a data warehouse is in constant change, while the warehouse itself needs to provide a stable and consistent interface to information spanning extended periods of time. In this paper, we propose a modeling technique for data warehousing, called anchor modeling, that offers non-destructive extensibility mechanisms, thereby enabling robust and flexible management of changes in source systems. A key benefit of anchor modeling is that changes in a data warehouse environment only require extensions, not modifications, to the data warehouse. This ensures that existing data warehouse applications will remain unaffected by the evolution of the data warehouse, i.e. existing views and functions will not have to be modified as a result of changes in the warehouse model.