Difference between Bill Inmon and Ralph Kimball Data warehouse model

Difference between Bill Inmon and Ralph Kimball Data warehouse model

Bill Inmon is first author to introduce Data warehouse design and Kimball has introduced new, relatively simpler Dimensional model design, with Star and snowflake schema.

Here are some differences between Inmon and Kimball’s model.

Bill Inmon Model	Ralph Kimball Model
Inmon Model is little complex to design, and can have lot of customization based on your own style.	Kimball Model relatively easier to develop, time saving and fixed Star or Snowflake schema designs we can use.
Supports Huge industry needs.	Perfectly matches to medium and small company needs.
Time talking and long projects.	Comparatively less time taking.
Require Expertise engineers thought project.	Once developed, little experienced engineers can work.
Design Supports Enterprise applications and wide range of data.	Design supports individual and medium cap clients business area.
After development modification and customization is easier and can be done faster.	After Development modification and customization is time taking process.
Inmon Design uses ER model in Data warehouse.	Kimball Model uses Star and Snowflake Schema.
In Inmon’s design Data Marts are physically separated from Data warehouse.	Whereas in Kimball’s model it’s not necessary to separate Data marts from Dimensional Data warehouse.
Inmon Design suggests First developing Central repository and then developing Data marts from Central repository.	Whereas Kimball’s design suggest developing first critical Data Mart’s which can supports all reporting and analytical needs.

Please leave your comments, suggestions.  

Thank you!