Podcasts

Three Types of Data Models


 

Originally published May 6, 2010


Overview

Bill Inmon discusses operational data models, data warehouse (or analytical) data models and global data models.

Bill Inmon
Bill Inmon

 
 

Comments

Want to post a comment? Login or become a member today!

Posted May 17, 2010 by Anonymous

I came across this article in search of a definition for 'Data Intgeration Model'.  I've been in the Industry since Pine Cone's ETL tool PRISM and I still have my Tech Topics.  Point is, it does seem more often then not we see new terms applied to old problems.  To me, when working with a case tool like PowerDesigner, where source models 'intgrate/link' with a target 'integrated' model, then essentialy you have a data integrated model.  You know, so the case tool reports data lineage.  Anyhow, maybe that's too simplistic?  Bill, can you provide a defintion for a 'Data Integration Model'?

Is this comment inappropriate? Click here to flag this comment.

Posted May 6, 2010 by

This is a nice summary of the different types of model.  However, I think Bill misses a point when he says that "data warehouse data models contain only information useful for analytical processing".  Once the analysis is done, you need to be able to take action.  (Or else why did you bother with the analysis?)  To take action, you need some indication of the entities that affected a particular analytical conclusion.  For example, if toothpaste is selling poorly, you need to know what region or perhaps even which stores need more marketing attention.  If telephone expenses are too high, you need to know who is making the excessive calls, and perhaps what numbers they are calling.  Region names, store names, telephone numbers - none of these is used directly for analytical processing.

Is this comment inappropriate? Click here to flag this comment.

Posted May 6, 2010 by

This is absolutely our experience here Bill. We model top down by subject area and bottom up by data needed by the business. In every case it gets down to dollars and numbers as measures and Things (parties, locations, products etc) as they pertain to organisational business units (Sales, Marketing Finance etc). Phil

Is this comment inappropriate? Click here to flag this comment.