Data Modeling Trends 2017

Data Modeling Trends 2017

Every year at Data Modeling Zone before introducing the first keynote speaker I share observations on how the data modeling discipline has changed since our last conference. I am currently working on my list for this year, which I base upon my recent training and consulting experiences. Are there changes or trends you’ve noticed over the last year to how your organization approaches data modeling? Please share!

1 Comment

  1. Eric Mortensen 1 year ago

    Here are two things that I have observed in my work,

    1. Where I work, the developers are still the primary ones who design database tables. Unfortunately, most developers today have less knowledge about how databases work and are actively trying to use Object Relationship Mapping (ORM) tools so that they do not need to write SQL. Because of these factors, most developers also know about data normalization rules and will often design tables with data and relationship anomalies that data Normalization needs to solve. This often requires me as a data architect to educate developers on these types of rules and why they are important, and how now following those rules are effecting the applications they are building with those issues.

    2. I am finding as a data architect that as our company and others move more to cloud based applications, that there are specific data challenges. Some of these challenges are: how to migrate data from existing in house systems to the cloud based applications; how to cleans and reorganize the data to match the data structure of the cloud based application; and how to integrate the other applications (both in house and cloud based) that are currently tied to the existing application and need to be modified to tie to the new cloud based application. This type of work provides a lot of opportunities for Data Architects in helping with these integration efforts, especially when the data in the existing application is organized differently then the new cloud based application and staging and transformation areas need to be designed and vetted.

Leave a reply

Your email address will not be published. Required fields are marked *

*