CODEWITHSUNDEEP
sqlsql-server-2008
Alex Nolasco
Alex Nolasco

Reputation: 19466

Bitemporal solutions for Microsoft SQL

Do you recommend any pattern/strategy or product that can help with the development of a bitemporal database for Microsoft SQL 2008?

About bitemporal

Upvotes: 1

Views: 1585

Answers (4)

user2008201
user2008201

Reputation: 11

I see this company has a bi-temporal Framework developed for SQL Server. They call it the Asserted Versioning Framework - AVF. They have a video that shows how it is integrated into normal T_SQL. Looks cool.

http://www.assertedversioning.com/

Upvotes: 1

smv
smv

Reputation: 605

The book "Developing Time-Oriented Database Applications in SQL" and other papers are available here http://www.cs.arizona.edu/~rts/publications.html#books

Author Richard T. Snodgrass is professor of Computer Science at the University of Arizona. I'm currently reading this excellent book: it deals with bitemporal tables in the first chapters.

Upvotes: 1

A-K
A-K

Reputation: 17090

This might help: A Primer on Managing Data Bitemporally

Upvotes: 2

marc_s
marc_s

Reputation: 754868

Not a complete solution per se - but interesting articles on the topic:

Upvotes: 1

Related Questions