Data Modeling a Necessity for Information Quality

by Willen L
In this article, the author talks about how conceptual data modeling is a necessity. That it is impossible to have good data quality without first understanding what the data is supposed to represent. He goes on saying that if you don’t understand what the relationship thoroughly. He even uses the analogy that it’s kind of like when children attempt to solve a puzzle game and try to force the piece by pushing into it to complete the puzzle but in the end you don’t get the right picture from the puzzle. It’s the same way in databases, it seems to fit but not exactly and that could compromise information quality. He says that the conceptual data model is the picture on the puzzle box that provides the vision of what the information puzzle should look like at the end of the day. We can definitely develop a database without a conceptual data model but it’s likely to have errors that you have missed it is best to plan with a data model and use cardinalities to describe the relationships as well as understand / analyze all the relationship for improved information quality.

This article relates to us because we are starting to design data models and I think that it’s important for us to know why we are doing this and what impact it can have if we don’t. I have learned how important data modeling is and also the comparison between conceptual, logical, and physical data models and that in order to design a healthy database that has “good quality information”.

Stiglich, P., Necessity of Conceptual Modeling for Information Quality. infoadvisors. Retrieved January 22, 2012, from http://www.infoadvisors.com/ArticlesVideos/ConceptualDataModelingforInformationQuality.aspx

5 thoughts on “Data Modeling a Necessity for Information Quality”

  1. Whenever I have worked on any project, I attempt to visualize the concepts involved and the predicted outcome. I think that database design should be no exception. The analogy of the picture on the puzzle box being similar to what a good database model should be was an interesting and clear way to explain the purpose that database models serve.

  2. I like the analogy of the puzzle game that you mentioned. The puzzle won’t be correct if you try to force in a piece that doesn’t belong at that location. It’s a good way to imagine how a database can be created. If the data doesn’t fit, then that means it doesn’t belong there.

  3. Great article. I agree that working with data is very important. In order to have good data quality, we need to have better understanding of data model. Thank you for posting this article.

  4. I totally agree with the whole idea about how data modeling is a necessity. It makes sense. Like you stated, yes you can create a database but in the long run, is the user really going to understand what the entire database represents. This article just reiterates the face that data modeling is very important for any database.

  5. Great writeup. As you have mentioned we need to know how the whole database will work before we start building and put data in places. If we are put the wrong piece in the wrong place then the end result would not work correctly or might not work at all.

Comments are closed.