Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2010
    Location
    London, England
    Posts
    24

    What does an Enterprise Data Model look like ?

    Hi

    When I started designing Enterprise Data Models about 10 years ago they had lots and lots of Entities, (usually around 50 or more) and were understandable only by other Data Modellers and with great difficulty.

    Over the last 5 years, I have favoured an approach that has a Top-Level Model with a number of Subject Areas - not more than ten.
    The objective of the Top-Level Model is to establish communication with senior management.

    This Top-Level EDM is then the starting-point for creation of an EDM for each Subject Area.

    Here is an example for Investment Banking on my Database Answers Web Site :-
    Enterprise Data Model for Investment Banks

    I wonder what Best Practice suggests about what an EDM looks like ?

    I look forward to hearing what other people think ;-0)

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by BarryWilliams View Post
    The objective of the Top-Level Model is to establish communication with senior management.
    in that case there shouldn't be any crows feet or cirles on the lines, and really, the lines shouldn't be there either

    so you have just the boxes

    then you could remove the boxes and put a bullet in front of each entity name

    and vwalah!! senior management powerpoint slide!!

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Quote Originally Posted by r937 View Post
    and vwalah!! ...
    You're Canadian, so I'm sure you must know that should be "voilà" - are you dumbing down for others?!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by andrewst View Post
    You're Canadian, so I'm sure you must know that should be "voilà" - are you dumbing down for others?!
    whoa, nice job on the accent, eh

    i do realize that french has that word, but mine is the anglicized version

    english has that habit, you know, of borrowing/stealing words from other languages

    so when you apply for that data architect job, you'd better have data modelling on your rezoom

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    I wouldn't normally bother with the accent, but thought as I was being pedantic I should (copied and pasted from a Google result).

    Oh well, "say lavy" as they say(?)

  6. #6
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by BarryWilliams View Post
    What does an Enterprise Data Model look like ?
    Hopefully it doesn't look like an ER model. In my personal experience, over-reliance on ER diagrams and related techniques is largely to blame for the failure of many (possibly even most?) data models. By "failure" I mean models that satisfy the data architects but are incomprehensible to business customers and irrelevant or too late for the developers.

    I much prefer ORM (NOTE: never to be confused with O/RM)

    Here is an example for Investment Banking on my Database Answers Web Site
    Accounts have "account_id" but not an account number? What are the business keys in the other tables? If the business owner / domain expert can't work out what identifies each fact in the business process then she can't honestly tell you whether the model is correct or not. Neither can anyone else.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by dportas View Post
    ... incomprehensible to business customers
    and i have the scars to prove it

    Quote Originally Posted by dportas View Post
    ... and irrelevant or too late for the developers.
    i've fought that battle, too (and even won it once)

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •