Data Modeling & Architecture

Integrating Data from Multiple Sources: Making Sense of Conformable Data - by David Loshin, Knowledge Integrity This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about data sources to be ingested into the enterprise for which there is little (or no) provided metadata. Yet the topic of our discussion is not purely ingestion of data into the enterprise, but integration of that data. So presuming that we were able to assemble a comprehensive view of the metadata for the data sets to be brought into the organization, w...
10 Physical Data Modeling Blunders - Are You Making Them? Karen Lopez 10 Physical Data Modeling Blunders from Karen Lopez One of my favourite presentation themes is talking about gotchas, blunders and mistakes.  Not because I like to focus on the negative, but because there are some wonderful resources out there telling modelers how to model, and so few out there telling us what NOT to do based on lessons learned. In this slide deck, I focus on physical modeling gotchas based on my reviews of hundreds of great data models that just missed the...
Why Do Data Modelers Experience So Much Conflict on Agile Projects? I spoke about agile methods, including Scrum, and data modeling in my Heart of Data Modeling webinar this month. One of the topics I touched upon was the concept of conflict and hostility between Data Modelers and Agile Developers.  We modelers have always experienced a bit of conflict with development teams due to the fact that our roles are measured and rewarded for conflicting outcomes.  Modelers are typically rewarded for ensuring data quality, for building models that are highly r...
The Future of ER/Studio: A Roadmap Outlook Customers often ask us what we plan to do for future releases of ER/Studio. Many times we hold that information close, and only provide information under a non-disclosure agreement (NDA). However, we want to show you that we are listening to your requests and responding to your needs. With that in mind, we would like to share the outlook for our 2015 plans for ER/Studio with a short slide deck. This is a high-level summary of some of the planned additions, and we'd be happy to provide you w...
Integrating Data from Multiple Sources: Inferring Source Metadata - by David Loshin, Knowledge Integrity This is the second post in this series. Read the previous post and the next post. In my last post, we began to review the data element conformance challenges associated with integrating data from a variety of original sources. The biggest issues have to do with the ability to conform data sets, or determine whether they can be blended together in a cohesive and semantically consistent way. The challenge is that in some, if not many, of the cases, there is little or no metadata, leaving you...