Conceptual Data Modeling

Description or Design: Which is Better for Data Modeling? {Comments Off on Description or Design: Which is Better for Data Modeling?}

by Katheryn T
The article I read about was focusing on the question of how data modeling is characterized. Specifically, is it design or is it description?  In the article, there were hundreds of people surveyed to find out what they thought. Questions spanned from asking what data modelers believe is the scope of the design process to will different data modelers produce different conceptional data models for the same scenario (Simsion, Milton, & Shanks, 2012)? Over the course of the surveys, the researchers discovered that many data modelers view database modeling as design, and other subjects, such as the business problem, were more descriptive than creative. The contributors that felt problems can be handled with design found that businesses don’t really knowing what they want. This was an opportunity for creative and new perspectives to be introduced. Over all, the researchers discovered that challenging business requirements where split between design and descriptive, data modeling was considered a creative activity, and that data modeling does not have one single right answer (Simsion, Milton, & Shanks, 2012). read more...

Data Modeling is too subjective. {3}

by Shigom H
Data modeling is a lengthy process for designers that involves a thorough analysis of the business requirements, and entity relationships. Most of this is done during the conceptual data modeling phase, in which a simple diagram(Entity Relationship Diagram) illustrates the relationships between the main entities of the business. In the “Necessity of Conceptual Data Modeling for Information Quality“ Pete Stiglich points out some typical problems that occur in conceptual data modeling and the approach that designers must take to create a more realistic model. The author describes a conceptual data model as the “picture on the puzzle box” that outlines what the “information puzzle” (Logical, Physical Model) should look like. Therefore, a lot of thought must go into the conceptual data model to avoid potential problems when developing the final product. read more...