Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

bitemporal dimension design - is this something?

Go down

bitemporal dimension design - is this something? Empty bitemporal dimension design - is this something?

Post  JohnTesson Wed Oct 21, 2015 11:46 am

I notice there are a couple of articles in the Data Administration Newsletter website titled "The Case Against Slowly Changing Dimensions". They are written by Tom Johnston, President of Asserted Versioning, LLC, a company which offers bi-temporal data management technology and consulting services.
This is the link: http://tdan.com/?p=18505

I'd be interested in comments about it.

Thanks

JohnTesson

Posts : 1
Join date : 2015-10-21

Back to top Go down

bitemporal dimension design - is this something? Empty Re: bitemporal dimension design - is this something?

Post  ngalemmo Wed Oct 21, 2015 1:57 pm

It's a lot of todo about nothing.

All a type 2 dimension design lays out is a mechanism to store multiple versions of a dimension member. Supporting bi-temporal views is a matter of including the necessary timestamps in the design of the table (when it happened, when it was loaded, when it goes into effect). While Kimball does not provide an explicit template in the book, it doesn't mean an SCD cannot support bi-temporal concepts.

There is already a mechanism to locate the 'current' row in a type 2 dimension. Bi-temporal simply expands on that concept. It is a matter of applying an appropriate filter to locate the appropriate version of the row.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

bitemporal dimension design - is this something? Empty Re: bitemporal dimension design - is this something?

Post  BoxesAndLines Fri Oct 23, 2015 11:45 pm

Yep, just add another set of dates to your type 2 dimension and your bi-temporal.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

bitemporal dimension design - is this something? Empty Re: bitemporal dimension design - is this something?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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