[AccessD] Temporal database (was: Stored Procedure not producing results)

My personal fave in this category is the Kimball Group. Specifically, for MS SQL, I recommend "The Microsoft Data Warehouse Toolkit" by Joy Mundy and Warren Thornthwaite. There is extensive discussion therein about SCDs (slowly changing dimensions).

I will check out your sources, too.

A.

----- Original Message ----
From: Gustav Brock <Gustav at cactus.dk>
To: accessd at databaseadvisors.com
Sent: Wednesday, November 22, 2006 8:41:01 AM
Subject: [AccessD] Temporal database (was: Stored Procedure not producing results)

Hi Arthur

I don't recall you have written about PITA here, but what you describe
is generally known as a temporal database.
This is well-known and has been dealt with by some great capacities in
the database world, Michael Boehlen, Christian Jensen, Richard Snodgrass
and Andreas Steiner.

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

A brief explanation and introduction can be found here:

http://www.timeconsult.com/TemporalData/TemporalData.html 

Note the link to TimeDB, a Java implementing of "A Bitemporal
Relational DBMS" for Oracle 10g

Also, look up my previous post(ings) on these:

http://databaseadvisors.com/pipermail/accessd/2005-May/034503.html 
http://databaseadvisors.com/pipermail/accessd/2005-May/034455.html 

This is a very exciting area. For some applications it won't even
require that much more data storage (accounting). 
A simplified approach is a write-only database (which means write and
read but neither delete nor update) which both Caché and MySQL offers.

Now, wouldn't it be nice if only TSQL2 could be implemented in Access:

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

/gustav