InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 13:42:45 GMT20http://www.sqlservercentral.com/Forums/Topic551430-374-1.aspxI 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/1558608559Wed, 13 Aug 2008 01:30:31 GMTsqlvogelhttp://www.sqlservercentral.com/Forums/Topic551430-374-1.aspxHeh... only every other Tuesday. :PWhat is the basis of your Bi-Temporal design?Tue, 12 Aug 2008 20:03:56 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic551430-374-1.aspxI 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.[url]http://www.cs.arizona.edu/people/rts/publications.html[/url]:Whistling:Tue, 12 Aug 2008 20:02:28 GMTGift Peddiehttp://www.sqlservercentral.com/Forums/Topic551430-374-1.aspxcan time dimension of Dimensional modeling provide all the benefit of BI-temporal design?Tue, 12 Aug 2008 14:31:48 GMTpravat