DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
chandra
Participant



Joined: 02 Apr 2006
Posts: 88
Location: India
Points: 580

Post Posted: Wed May 31, 2006 7:45 am Reply with quote    Back to top    

could any explain the basic difference between what is the basic difference between kimball and billinmon

_________________
chandra ,
Hyd
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Wed May 31, 2006 7:50 am Reply with quote    Back to top    

What's the basic difference between an orange and an apple? What do you want, color, taste, nutritional value, texture, method of consumption?

Kimball and Inmon both write books, give lectures, and teach about data integration. Their methods are complimentary in certain areas, conflicting in others. There's no one line answer. You're best served by reading their websites and books, attending webinars, and signing up for newsletters.

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
chandra
Participant



Joined: 02 Apr 2006
Posts: 88
Location: India
Points: 580

Post Posted: Wed May 31, 2006 11:42 am Reply with quote    Back to top    

The basic difference is :-
kimball :- DW is made of combination of DATAMARTS while INmon is DW is part if BI and DATAmarts are part of the DW.

_________________
chandra ,
Hyd
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Wed May 31, 2006 12:27 pm Reply with quote    Back to top    

Well, no, you've pretty much got it completely wrong. Kimball argues against stove pipe data marts and not "backing into" an architecture. Kimball and Inmon both believe in a well architected data integration environment for analytical processing.

Kimball espouses his "Bus" architecture, and Inmon has his "CIF" (corporate information factory). There's data acquisition, storage, and presentation layers in both. The methods for data modeling differ, and I believe Inmon has no pure ETL strategy or framework book while Kimball just recently published one.

You really need to read their materials.

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
kduke

Premium Poster


since February 2006

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Wed May 31, 2006 4:57 pm Reply with quote    Back to top    

Buzz, Buzz, Buzz. Lots of buzzwords. There is value in these books but why is it that the people who can quote from these books build terrible DataStage jobs? Simple solutions to complex problems are ...

_________________
Mamu Kim
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Wed May 31, 2006 6:14 pm Reply with quote    Back to top    

... and get the apostrophes correct!!! Slightly more seriously - not that I'm flippant about misuse of apostrophes - common sense ought to prevail in ETL design, and Kim has summed it up fairly ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Wed May 31, 2006 7:15 pm Reply with quote    Back to top    

kduke wrote: By the way Ken, can you explain "Bus" versus "CIF" without using buzzwords? I double dare you. No way. Both my responses said the same thing: read their books and figur ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
kduke

Premium Poster


since February 2006

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Thu Jun 01, 2006 6:47 am Reply with quote    Back to top    

I understand what you mean but I was not talking about dumbing down my solutions. I don't think my solutions are simplistic. I do think my solutions are streamlined and clean in their design. I don' ...

_________________
Mamu Kim
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Thu Jun 01, 2006 11:01 am Reply with quote    Back to top    

kduke wrote: I would like a clean defintion of the difference between Kimball and Inmon as it applies to ETL or delivering a solution. What do you think we DSX developers would benefit from knowi ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
kduke

Premium Poster


since February 2006

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Thu Jun 01, 2006 6:01 pm Reply with quote    Back to top    

Excellent, thank you.

_________________
Mamu Kim
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Thu Jun 01, 2006 6:40 pm Reply with quote    Back to top    

Take a peek here: http://www.inmoncif.com/library/cif/ This is my favorite diagram, because it shows the elements in a fully matured environment. I really like showing folks this diagram, beca ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours