Bitemporal vs SCD

View previous topic View next topic Go down

Bitemporal vs SCD

Post  TheDarkKnight on Fri Mar 22, 2013 3:27 pm

can anyone really present the difference between Bitemporal architecture vs the SCD2.
why is the one better than the other?
avatar
TheDarkKnight

Posts : 10
Join date : 2013-03-22
Age : 34
Location : NJ

View user profile

Back to top Go down

RE: Bitemporal vs SCD

Post  rathjeevesh on Mon Mar 25, 2013 12:07 am

SCD type 2 is driven by surrogate key concept which is a primary key for the dimension table. Historical information about the dimension can be easily stored and retrieved using SCD 2 technique.

Bitemporal design approach will add lot of complexity while handling dimension to fact relationship. Either all queries need to have a restriction of which record you want to retrieve (current/history) or you need to have a multipart (composite) primary key foreign key relationship from dimension to fact. Else there is every possibility of having many to many relationships between dimension & fact.

Thus using SCD 2 technique in DW is effective and it is a key differentiator between Kimball & Inmon approach.

-JR

rathjeevesh

Posts : 15
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Bitemporal vs SCD

Post  BoxesAndLines on Mon Mar 25, 2013 8:24 pm

Sure, with bi-temporal you have two sets of dates. One set for the business effectivity. One set for dw effectivity.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Bitemporal vs SCD

Post  temporalcraig on Sat Mar 30, 2013 2:02 pm


temporalcraig

Posts : 10
Join date : 2010-07-19
Location : Princeton, NJ

View user profile http://www.bitemporaldata.com

Back to top Go down

Re: Bitemporal vs SCD

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum