in

The ORM Foundation

Get the facts!

Controlling one-to-one absorption

Last post 05-20-2009 11:59 by Matthew Curland. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-18-2009 19:24

    • OrionB
    • Top 50 Contributor
      Male
    • Joined on 04-03-2008
    • Tualatin OR
    • Posts 18

    Controlling one-to-one absorption

     Recently, I added a one to one relationship between two entities, non-mandatory on both sides.  Fortunately for me, it maps out the way I want it to - absorbing the role with a rolename. But if it had not, and I wanted to change it, is there anything I could do? (beyond deleting the fact type and adding it again, hoping that things land my way next time.)

  • 05-20-2009 11:59 In reply to

    Re: Controlling one-to-one absorption

    Orion,

    You can't currently change this. The absorption direction decision is made based on heuristics including the smallest number of entities, mandatory constraints, independent settings, etc.

    The technical issue comes when there are multiple connected 1-1 FactTypes (including cycles), in which case a user setting specifying the direction can pull and entity in two directions, which can wreak havoc with the resulting mapping. This basically leaves us in a position where we would need to add validation errors to condradictory user settings, which is a major work item.

    We will also be adding a notion of 'key total' to object types at the conceptual level to complement the 'independent' notion. Independent cannot always be set due to mandatory constraint patterns, so there is no way to force a table to be generated in all cases.

    This is certainly something that would be a 'nice to have', but there are no immediate plans to put it in place due to the complications of unreliable user analysis of interconnected 1-1 model graphs.

    -Matt

Page 1 of 1 (2 items)
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service