One more time: Do we still need Data Modeling?

Yes, we need still need to do data modeling, and yes, data modeling is a skill that developers need to learn and practice.

Kent’s points are important:
— To get business value out of the data, you need to understand the data
— Even if you don’t need a model to store the data, you DO need a model to understand the data and use it properly
— Know your data!

I see fewer and fewer data modeling session at conferences these days – dull and boring perhaps, but essential for efficient development and data retrieval based on your data.  I see data modeling as a fundamental skill for all IT professionals – at least those working with databases.

The Data Warrior

More specifically do we still need to worry about data modeling in the NoSQL, Hadoop, Big Data, Data Lake, world?

This keeps coming up. Today it was via email after a presentation I gave last week. This time the query was about the place of data modeling tools in this new world order.

Bottom line: YES, YES, YES! We still need to do data modeling and therefore need good data modeling tools and skills.

Snowflake with RI A picture can say so much!

In order to get any business value out of the data, regardless of where or how it is stored, you have to understand the data, right?

That means you have to understand the model of the data. Even if the model (or schema) is not needed upfront to store the data (schema-on-write), you must discern the model in order to use it (schema-on-read).


View original post 231 more words

3 thoughts on “One more time: Do we still need Data Modeling?

  1. Pingback: Do We Need Data Modeling Anymore? | SutoCom Solutions

  2. Is there a better application for modelling? SQL Modeller feels antiquated when compared to something like MySQL Workbench (obviously can’t use that for Oracle DB). I’ve tried Toad Modeller which is very similar to SQL Modeller.

    • Hello William, SQL Developer Data Modeler should of the trick for you. Depending on the extent of data modeling – what diagrams, where you are starting form, types of models and notations – there can be a bit of a learning curve. There are plenty of blogs out there to help you. I cannot comment on comparison to MySQL Workbench, as I have never used that. Good luck to you!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s