It’s Always a Data Modeling Question…
When you have been a data modeler for [redacted] decades, you learn to see the world through data modeler eyes. Everything seems to be a data modeling question.
I was with a client for lunch one day and we asked the server “What do you have on tap?” She was gone quite a long time, but came back and said “Beer.” It turned out she was right. But her answer was not that helpful.
Why is an Expert Asking Us What a Data Model Is?
One of the odd parts of every new project I have to deal with is getting everyone to understand that the question “Can you help us with a data model” results in me asking. “What do you mean by data model?” That’s right, I have to ask team members what a data model is. You’d think experts would know better.
I have to do this because it seems like everyone has a different definition. For most DBAs, they want a reverse-engineered image of a production database. For a business user, data modeling that results in documentation about all the questions, answers and decisions were made. For a developer a specification of something they can build upon. An executive wants a high-level view of the data concepts a specific project will be addressing so she can approve scope and budgets. A data scientist wants a consolidated view of both the physical data objects available to him and a logical definition of what they are. Finally, a data modeler wants a list of previously modeled entities so that she doesn’t have start from scratch on every project.
It’s likely that every role in the organization wants a different data model with a different set of metadata. It’s also why we need to have a discussion about conceptual, logical and physical data models. Even that set of terms has differing definitions. That’s nearly unforgivable given that we data modelers preach that we should use consistent definitions. (Note from author: this one bit led to one of the longer threads on LinkedIn that has ever been discussed about one of my posts. Some of the comments are not fit for work.) Then to make this even more complex, we need to discuss the primitives in the Zachman Framework as well.
Simple Tools Don’t Work Well For Complex Data Model Questions
This is why using native database tools aren’t good enough to solve all those needs. This is why a simple drawing tool isn’t enough. What an enterprise needs are tools that can author, design, and present all those types of data models without creating duplicate copies of those data concepts. It’s also why a data modeler needs to ask the question: What do *you* mean by data model? You need to ask your team members what they are expecting before you start working. You may need to negotiate priorities or formats. You may need to create separate views of your models. That’s wonderful, though, to deliver what they need from your data models. It’s all good.
It’s not that we modelers don’t know the 100+ possible answers to that question. It’s that we know there are 100+ answers.
It’s not that we modelers don’t know the 100+ possible answers to that question. It’s that we know there are 100+ answers. That’s what data modeling is after all: getting to the right answer for this requirement.
Note: This post is an updated version of one posted to community.embarcadero.com in 2015
Leave a comment
Subscribe via E-mail
Recent Comments
Categories
Downloads
- favicon
- 476275616.jpg
- favicon
- Refactoring Computer Engineer Barbie
- 10 Things I Hate About Interviewing with You
- EDW 2013 Karen Lopez Get Blogging
- Karen Lopez presentation DAMA PS 2012
- Data Modeling Contentious Issues - DAMA Nebraska
- Karen Lopez - 10 Physical Blunders - DAMA
- Career Success In Data Profession - DAMA
- The Straw Poll
- You've Just Inherited a Data Model CheckList
- KarenLopez - 5 Physical Blunders - 24HOP-2011
- Handouts for OEMUG / CA Global Modeling User Group Why Be Normal Webcast
- Handouts Database Design Contentious Issues - New York 2010
- Handouts Database Design Contentious Issues - DC 2010
Archive
Recent Posts
Archives
- October 2019
- November 2018
- May 2018
- April 2018
- December 2017
- August 2017
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- September 2010
- August 2010
- July 2010
- February 2009