Re: Way to design "history" in DBs
From: <joe_celko_at_my-deja.com>
Date: 2000/03/01
Message-ID: <89jl67$un2$1_at_nnrp1.deja.com>#1/1
Date: 2000/03/01
Message-ID: <89jl67$un2$1_at_nnrp1.deja.com>#1/1
>>... The user's requirement is now that not only the actual storage
position and state of each item can be queried, but also its "history".
That is, he wants to query when the item was received, when it was
dislocated, and when it was treated in which way by which employee. <<
You might want to get a book on temporal data in SQL by Rick Snodgrass (Morgan-Kaufmann Publishers).
--CELKO--
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 01 2000 - 00:00:00 CET