Author Topic: Data Modeling UML Profile -- Two (2) questions  (Read 1153 times)

benbovee

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Data Modeling UML Profile -- Two (2) questions
« on: September 13, 2016, 05:33:35 am »
Hello, Folks:

I am one of the early adopters of, and published contributors to, the UML.  I only say that to establish your understanding of my knowledge level. 

Your article regarding the Subject is well written; and finding any writing on this topic is difficult.  It does address Generalization, Composition and Aggregation. 

Your article does not present guidance for transforming:
1. All possible options for a class hierarchy (think combinations and permutations),
2. Multiple-level hierarchies (i.e., generalizations nested in a generalization),
3. Simple associations--unqualified or qualified,
4. Link associations,
5. Ternary associations, or
6. N-ary associations. 
~ ~ ~ ~ ~ ~
QUESTIONS:

1. Is your tool able to traverse a class hierarchy from a generalization not nested in another (i.e., base class), from top-to-bottom up on all branches, identifying all embedded generalizations, and bottom-to-top prompt users to select their transformation option for each generalization--ensuring this is done for all embedded generalizations at the same depth before iterating 'up' a level--until reach the base class?

2. Was the exclusion of transforming between temporal semantics of a Class-Class association (mandatory at any instant in time in existence for one instance) and an Entity-Relationship (may be for all time for all object instances) on purpose since it's ambiguous? 
Although this ambiguity is a pattern-observed fact, options should be provided to the modeler for EACH and EVERY relation--whether between Classes or Objects.
« Last Edit: September 13, 2016, 09:14:38 am by benbovee »

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2436
  • Karma: +29/-2
    • View Profile
Re: Data Modeling UML Profile -- Two (2) questions
« Reply #1 on: September 13, 2016, 01:54:03 pm »
Ben,

Just to be clear, are you referring to this article: http://www.sparxsystems.com/resources/uml_datamodel.html ?
The Sparx Team
support@sparxsystems.com

benbovee

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Data Modeling UML Profile -- Two (2) questions
« Reply #2 on: September 14, 2016, 11:05:28 am »
Yes, I should have mentioned that in my post.  It was implicit, I did not make it explicitly clear; and thank you for doing so.

Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 583
  • Karma: +6/-0
    • View Profile
Re: Data Modeling UML Profile -- Two (2) questions
« Reply #3 on: September 19, 2016, 12:49:25 pm »
There are number of resources on the Community site covering Database modeling and MDA transforms.
See:
Data modeling
http://community.sparxsystems.com/white-papers/669-data-modeling-from-conceptual-model-to-dbms
For Many to Many UML to DBMS table transform see page 10-11 of the Data modeling paper.

See the series of community site posts form Michael Blaha on:
http://community.sparxsystems.com/tutorials/594-66data-modeling-antipatterns-part-1-of-2

Database Builder:
http://community.sparxsystems.com/white-papers/933-introduction-to-the-database-builder

Regarding the Generalization with respect to MDA tramsforms - see the bottom of:
http://sparxsystems.com/enterprise_architect_user_guide/12.1/model_transformation/ddltransformation.html