Data Modeling Concepts Everyone Should Know

by Willen L
In this article, the author states that people that work with anything related to databases are often asked by their organization to take on the job of data modeling even though it does not specify it on their job description. With that said, he gives us some basic data modeling concepts everyone working with databases should know.  He states that data modeling begins with understanding the requirements and to use this knowledge as a blueprint to build a physical database. He states that it is important to understand and build a well-designed data model in order to increase value to the organization by minimizing redundancy, maximize data integrity, increase stability, enhanced data sharing, consistency, more timely access to data, and better usability. Without a good data model you will run the risk of missing some important data that can be a disadvantage for the business. He states that it is important to think of “what” is of interest instead of “how”. He leaves off with 3 basic tips that everyone should know. First think conceptual – focus on business issues and terms. Second, think structure, how something is done is not as important as processes being done to. Last, think relational, the way things are related to one another.

I think this article was helpful for me because it has been stated that if we get a job working with databases, usually the databases are already build and we start from there and there is no need for building the database from ground up but in this article it states that in the real world it is often not the case as people are asked to do tasks that are outside of their job descriptions. I also find it helpful because it helps me understand the “big picture” of how data modeling is and how important it is to the organization.

Mullins, C. (2002 November). Data Modeling Concepts Every DBA Should Know. Craigsmullins. Retrieved January 14, 2012, from http://www.craigsmullins.com/dbta_015.htm

4 thoughts on “Data Modeling Concepts Everyone Should Know”

  1. Nice article Willen. I like the part where you mentioned the three basic tips of data modeling. The way these steps are broken down makes it easier for us to focus when we start to work on our database. Just like with all things, it’s important to understand the information that we’re working with in order to be successful at our task.

  2. I liked this article. I also liked the fact that it broke down the data modeling into three separate focuses. I also never really thought about the fact that most businesses are already going to have a database in place and that we are basically going to be working off of a work in progress.

  3. I like the break down of the three data modeling Issues, Structure and Relation, great articles.

  4. I like the break down of the three data modeling Issues, Structure and Relation, great article.

Comments are closed.