in

The ORM Foundation

Get the facts!

pdf P12 A closer look at the join-equality constraint

Downloads: 50 File Size: 804.6kB
Posted By: admin Views: 469
Date Added: 12-02-2008

 

Abstract. Assume an ORM-diagram where there exist two (or more) paths from one entity type to another through a sequence of many-to-one binary facts. Here we may have a join-equality constraint saying that if we follow the different paths from an instance of the first entity type, we should find the same instance of the second entity type. This constraint is inherent in most ticketing/reservation systems, where it may give rise to overlapping foreign keys in the relational database. Another interesting observation is that if a relation is in 3NF, but not in BCNF, there must be a join-equality constraint in the underlying model.

Authors: Gerhard Skagestein and Ragnar Normann
University of Oslo, Department of Informatics,
PO Box 1080 Blindern, NO-0316 Oslo, Norway

Comments

No comments exist for this file.
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service