bitemporal dimension design - is this something?

View previous topic View next topic Go down

bitemporal dimension design - is this something?

Post  JohnTesson on 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

View user profile

Back to top Go down

Re: bitemporal dimension design - is this something?

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: bitemporal dimension design - is this something?

Post  BoxesAndLines on Fri Oct 23, 2015 11:45 pm

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

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

View user profile

Back to top Go down

Re: bitemporal dimension design - is this something?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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