Bi-temporal design

Question

Bi-temporal design

pravat

SSC-Addicted

Points: 410
More actions
August 12, 2008 at 2:31 pm

#211131

can time dimension of Dimensional modeling provide all the benefit of BI-temporal design?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

I am not sure the two are related because temporal data is time interval arithmetic while Time Series is relational calculus but I could be wrong so I have found the best Temporal book it is free download it and let us know.

http://www.cs.arizona.edu/people/rts/publications.html

:Whistling:

Kind regards,
Gift Peddie

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

Heh... only every other Tuesday. 😛

What is the basis of your Bi-Temporal design?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sqlvogel SSCrazy Eights Points: 9526 More actions · Answer 3

I expect you are referring to Kimball's "Dimensional Modeling" patterns. The concepts described by Kimball are fairly unsophisticated and limited in their application. There are much better sources on temporal modeling problems such as the Snodgrass book already mentioned or the Date, Darwen and Lorentzos' book:

http://www.amazon.com/Temporal-Relational-Kaufmann-Management-Systems/dp/1558608559