Bitemporal Data

Whether you're looking for info on bitemporal data, dynamic SQL, concurrency, error handling, or a handful of other topics, I also endorse Expert SQL Server 2005 Development (by not only Adam, but also Hugo Kornelis & Lara Rubbelke).

Their book is excellent--right up there at the top of the stack with Joe Sack's SQL Server 2008 Transact-SQL Recipes & Kalen et al's Internals--too bad the marketeers at Apress didn't do a better job.

I have to agreee with Jimmy May about the book thing. It really is great!

and if you haven't seen it yet tell Dejan to give his temporal SQL presentation. he presented it here in slovenia couple yeras back. pure awesome!

Thanks for the kind words!

I read that well written article. It discussed about central truth, which made me think whether we're dealing with BI project or not. When he delved in to the details, I started to ponder whether he's talking about Slowly Changing Dimension 3 or SCD3. Then again, the solution did not add the extra column on the table as one would expect, but an extra ledger table. This implementation feels a lot like SCD 4 but for OLTP system and not OLAP. Is my summation on BiTemporal data is like implementing SCD4 on a OLTP system? Feel free to educate me on this. Thanks and I appreciated the reading about it.

I would like to recommend the only technique that fully embraces bitemporal data, Anchor Modeling. Look at http://www.anchormodeling.com for more information. There's even a "fix" for dimensional modeling that alleviates the need for SCD:s altogether.