> Its called a "temporal database". > Usually its intended for medical or police databases where > you need a hind sight. i.e. if today is 31/12/2005, what did we know at > 20/12/2005. > for example, for a doctor appearing at court and required to testify > what he knew at 20/12/2005. What he "can have known" not "what he knew". With GnuMed we are running a trigger based auditing solution which so far works nicely. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
