in

The ORM Foundation

Get the facts!

Modifying Relational View

Last post 09-18-2008 12:31 by Matthew Curland. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-18-2008 11:03

    Modifying Relational View

    Hi again,

    Will it be possible to work backwards, for example, modifying a Relational View (creating new entities, modifying existing entities, etc) and thus causing the Conceptual Model to be changed accordingly?

     Thanks,

     Ricardo Peres

    Filed under:
  • 09-18-2008 12:31 In reply to

    Re: Modifying Relational View

    Automatic reverse engineer is only possible for trivial cases. A single relational table can represent multiple ObjectTypes absorbed into that table for subtyping, 1-1 relationships, 1-many objectified relationship, objectified unaries, and a host of other reasons. Similarly, as clearly shown by the Verbalization Browser, a single relational column can map to multiple FactTypes. A process for adding a column to a table and reverse engineering to the conceptual model would require a long list of decision-tree style questions that the user would need to answer. Even then, there would be no guarantee that the column would actually end up in the table you were trying to put it in.

    The relational view (more importantly, the underlying relational model) is a mapped view of the conceptual model. The best thing to do is to navigate to the underlying conceptual ObjectType and add a FactType. The next NORMA drop should make it easier to do the navigation.

    -Matt

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