Re: [SQL] Still struggling with history tables

2006-01-18 Thread Michael Glaesemann
On Jan 18, 2006, at 19:23 , Achilleus Mantzios wrote: Generally it is very hard to distinguish between two kind of UPDATES: a) UPDATEs that mean real data updates and they should be recorded to the history system. b) UPDATEs that are just false data entry, and they should mean just plain corre

Re: [SQL] Still struggling with history tables

2006-01-18 Thread Achilleus Mantzios
O Ken Winter έγραψε στις Jan 17, 2006 : > Friends ~ > > I'm still trying to implement a solution to the requirement to keep a > complete history of data changes to a "person" table. (See earlier > correspondence below.) I'm trying for a variant of the architecture > suggested by Richard Huxton

[SQL] Still struggling with history tables

2006-01-17 Thread Ken Winter
Friends ~ I'm still trying to implement a solution to the requirement to keep a complete history of data changes to a "person" table. (See earlier correspondence below.) I'm trying for a variant of the architecture suggested by Richard Huxton (also below). In my variant, I have this "identifier