bitemporal dimension design - is this something?
3 posters
Page 1 of 1
bitemporal dimension design - is this something?
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
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
Re: bitemporal dimension design - is this something?
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.
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.
Re: bitemporal dimension design - is this something?
Yep, just add another set of dates to your type 2 dimension and your bi-temporal.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» FACT Design Question - How to design FACT Table when computation is required on the degenerate dimension?
» Dimension Design with intermediate tables between fact and dimension
» Need help with dimension design
» Dimension Design
» Dimension design
» Dimension Design with intermediate tables between fact and dimension
» Need help with dimension design
» Dimension Design
» Dimension design
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum