Charlotte Foust
cfoust at infostatsystems.com
Wed Nov 22 09:53:43 CST 2006
I'm with you Arthur. The Kimball Group stuff is where I learned about data warehousing, and I have at least 3 of his books. Simple concept once you get your head wrapped around it. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Wednesday, November 22, 2006 6:11 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Temporal database (was: Stored Procedure notproducing 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com