When entities are types: effectively modeling type-instantiation relationships

  • Authors:
  • Faiz Currim;Sudha Ram

  • Affiliations:
  • Department of Management Sciences, University of Iowa, Iowa City, IA;Department of Management Information Systems, University of Arizona, Tucson, AZ

  • Venue:
  • ER'10 Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Type-instantiation relationships (TIRs) appear in many application domains including RFID-based inventory tracking, securities markets, health care, incident-response management, travel, advertising, and academia. For example an emergency response (type) is instantiated in the actual incident, or an advertisement (type) serves impressions on a website. This kind of relationship has received little attention in literature notwithstanding its ubiquity. Conventional modeling does not properly capture its underlying semantics. This can lead to data redundancy, denormalized relations and loss of knowledge about constraints during implementation. Our work formally defines and discusses the semantics of the type-instantiation relationship. We also present an analysis of how TIRs affect other relationships in a conceptual database schema, and the relational implications of our approach.