The ORM Foundation

Get the facts!

pdf P12 A closer look at the join-equality constraint

Downloads: 306 File Size: 804.6kB
Posted By: admin Views: 1,224
Date Added: Tue, Dec 2 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


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