EA Consultant/Coach with Data Model "Patterns" Exp

[lipmanc]

I'm struggling with getting from logical/essential data models to physical database implementation.  Part of the struggle is my lack of experience with both designing DM “patterns” and implementing physical databases.  (My primary exposure to DM patterns is David Hay's book on the topic.)

I would like to hire an EA coach with DM pattern experience.

Any interested parties can e-mail [email protected].

[«Midnight»]

Before you go too far on this, take a look at DDL | Transformation in the EA Help index.

David

PS: If you decide to create your own template to take this further, remember that you have to copy a template and edit the copy. This is a paradigm that EA uses elsewhere (scripting, RTF report templates). The first time you want to work on one of these it is easy to miss the requirement, and end up wondering why the rest of the directions don't seem to work. [At least it was for me...]

[Gary W.]

I'm struggling with getting from logical/essential data models to physical database implementation.

Join the club  

... especially if you're working *only* from David Hay's book.  We've built lots of Oracle DB's from generic data models, and what you really need is an experienced DBA as part of your team.

If you have any specific questions (e.g. resolving many-to-many relationships, supertype/subtype implementations, mutually exclusive arcs), then please post back here, and we'll answer (and share in the knowledge) here as best as we can.

Lastly, take special note of pages 6/7 in David's book:
"The models presented  in this book.. are more abstract than those typically used to develop real systems."

Out of curiosity, what technical architecture are you going to deploy on?  I ask because, if you're going Java/Web, then you have another hurdle to cross (even if you're happy with the physical implementation of the logical model).. and that is the object-relational impedence mismatch.

Good luck,
Gary