Andyblg's Blog

May 4, 2011

Thoughts about “Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make”

Filed under: Data management — andyblg @ 22:23
Tags: ,

My notes about interesting article “Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make

About “Mistake 1: Forgetting that an enterprise architecture is a living framework”
An enterprise architecture is a living framework but it is not 100%-true.
“Living framework” in the projection to complement and minimal changes in the main part of schema (model).
If you have an application using the schema (er-schema) will be very expensive (time, cost) to change the application.
Talk about the life of the model (logical) is not correct in my view, correct to speak of the complement – the development of the model.
In my opinion development of the schema (in particular logical) is very important and requires the most expensive in the design phase, as further changes are overhead.
I think we should not talk about “an enterprise architecture”, we need to talk about data models and management of these models within the enterprise.

About “Mistake 2: Keeping data models invisible”
Not entirely clear what is meant by the term “definitions”.
“A model without definitions is just a diagram that could be interpreted in many ways…”. It’s not true.
If you have application which use er-model (for example HR) – how it will be interpreted in many ways? Not entirely clear =/
What is “invisible”? Invisible from whom? from the members of project? It isn’t true. Then he will not be able to develop applications =/

About “Mistake 3: Assuming that business users can’t understand or review models”
Who is “business users”?
Suppose we have a person(1) who develops an application and the person(2) who develops the database schema. Who’s Who?
If it’s =) person(1) then how he will develop an application if he does not understand what are some objects in the database (all the objects are not important to him).
If it’s =) person(2) then how he will develop the database schema? :-0

About “Mistake 4: Thinking that data models are only about databases”
Data models are not only a databases. It’s true.
Let’s see definitions of “Data model” on wiki.

About “Mistake 5: Throwing models “over the wall””
“A data modeler is the mediator between business requirements and physical implementations.”
Nice remark.

About “Mistake 6: Forgetting about the sizzle”
Not entirely clear.
In my opinion it is not as important (color, guides for nonmodeler) as the completeness and rationality of model.

About “Mistake 7: Thinking of them as “your” models”
Correct note.
“That means sharing them openly, providing access to those who want it,”.
Totally agree.

Thanks Karen Lopez, Kamille Nixon



  1. Hey there! Great stuff, please keep me posted when you post something just
    like this!

    Comment by Cindy — July 22, 2015 @ 07:33 | Reply

  2. Simply wish to say your article is as amazing.
    The clarity on your post is just nice and that i can assume you’re an expert in this subject.
    Well together with your permission let me to grasp your RSS feed to stay updated
    with impending post. Thanks 1,000,000 and please continue the rewarding work.

    Comment by telecharger le jeu titanfall gratuit — July 21, 2015 @ 11:50 | Reply

  3. Simply want to say your article is as surprising. The clearness in your post is simply spectacular and
    i could assume you are an expert on this subject.
    Well with your permission allow me to grab your feed to keep up to date with forthcoming post.

    Thanks a million and please carry on the gratifying work.

    Comment by Financial Rescue Testimonial - Rodolfo Mercado — July 18, 2015 @ 02:40 | Reply

  4. I used to be recommended this web site through my cousin. I’m not certain whether or not this submit
    is written by him as nobody else recognize such exact approximately
    my problem. You are incredible! Thanks!

    Comment by this contact form — January 30, 2015 @ 10:25 | Reply

  5. Incredible story there. What occurred after? Thanks!

    Comment by — December 3, 2014 @ 18:27 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at

%d bloggers like this: