Managing inheritance hierarchies in object/relational mapping tools

  • Authors:
  • Luca Cabibbo;Antonio Carosi

  • Affiliations:
  • Dipartimento di Informatica e Automazione, Università degli studi Roma Tre;Dipartimento di Informatica e Automazione, Università degli studi Roma Tre

  • Venue:
  • CAiSE'05 Proceedings of the 17th international conference on Advanced Information Systems Engineering
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

We study, in the context of object/relational mapping tools, the problem of describing mappings between inheritance hierarchies and relational schemas. To this end, we introduce a novel mapping model, called M2ORM2 + HIE, and investigate its mapping capabilities. We first show that M2ORM2 + HIE subsumes three well-know basic representation strategies for mapping a hierarchy to relations. We then show that M2ORM2 + HIE also allows expressing further mappings, e.g., where the three basic strategies are applied independently to different parts of a multi-level hierarchy. We describe the semantics of M2ORM2 + HIE in term of how CRUD (i.e., Create, Read, Update, and Delete) operations on objects (in a hierarchy) can be translated into operations over a corresponding relational database. We also investigate correctness conditions.