Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bi-temporal design Expand / Collapse
Author
Message
Posted Tuesday, August 12, 2008 2:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 20, 2010 8:08 PM
Points: 20, Visits: 100
can time dimension of Dimensional modeling provide all the benefit of BI-temporal design?
Post #551430
Posted Tuesday, August 12, 2008 8:02 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
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





Kind regards,
Gift Peddie
Post #551542
Posted Tuesday, August 12, 2008 8:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:57 PM
Points: 35,779, Visits: 32,451
Heh... only every other Tuesday. :P

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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #551544
Posted Wednesday, August 13, 2008 1:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 453, Visits: 3,485
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

Post #551647
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse