Seven common Data Modeling mistakes to watch out for{3}

by Kevin Q
The article briefly describes the benefits of data modeling and how it helps a company and its projects. It then immediately jumps into the seven common mistakes that occur. The First mistake is thinking that the data model is a final structure. This kind of thinking is incorrect, since the data model should be thought of more as a version that can be updated due to new changes. The second mistake is have data models invisible. Data models should be easy to access, be clear and understandable and organized so that it can be used. Having an invisible model defeats the whole purpose of data modeling. The third mistake is assuming business users can read data models. Whether it is assumed by the data model creators or the employees, all that is needed is training to be able to understand the models. It’s important that everyone be able to read and understand the models so that they can make business decisions with helpful information. The fourth mistake is thinking that data models are only used for databases. Data models can go beyond databases to explain and show physical procedures that take place in a company. This can be really helpful in showing the nature of a certain area within the company, so that a well-informed decision can be made. The fith mistake thinking of the data model only as an early deliverable. The data model should be thorough and used as a guide when entering the implementation phase and not just a early deliverable. The sixth mistake creating and overall bland data model. By creating a more colorful and somewhat exciting data model with plenty of comments and guides to help the users, you can keep people engaged and impressed. The seventh mistake think of the data model as your own and not the company’s. They should be available and shared to everyone within the company for viewing, otherwise they will not help the company if only you or a small group of people are the only ones allowed to view it.

As we went over data modeling in class we were taught how it helped companies. This article was a good insight into how everyone in the company can really benefit from being able to view and understand a data model. Company projects will go a lot smoother if the data model is overall well done, clear, and available to everyone so that the implementation phase doesn’t get too hectic. This article broke down seven common mistakes that occur related to the creation, interpretation and use of data models. It was overall a good and interesting read.

Source:  Lopez, Karen & Nixon, Kamille. Enterprise Data Modeling: 7 Mistakes You Can’t Afford to Make. Information May 2, 2011. “”