Re: History tracking in databases

From: Sean Dreilinger <sean_at_interactivate.com>
Date: 1997/10/12
Message-ID: <34412073.274321092@news-server>#1/1

  | bhq001_at_email.mot.com wrote in article <872763022.5320_at_dejanews.com>...

| > As part of the design requirements, the database
| > must provide means of
| > tracking historical data. This is further explained
 ...
| > Question: How would this kind of relationship be
| > implemented in an RDBMS?

have you looked at how postgres/postgres95/postgresql handles time-travel?

i think they're planning to remove time-travel from the dbms and re-introduce it as a function or trigger you can add back in -- and that may be a good starting point for whatever rdbms you're working with now. i just built postgresql 6.2 (freely available from http://www.postgresql.org/) and included in the the distribution under `docs' or `examples' were the proposed function sources.

hth
--sean :-)

                           sean dreilinger, mlis
       +1 (619) 748-7684  sean_at_interactivate.com  
       http://www.interactivate.com/people/sean/

Received on Sun Oct 12 1997 - 00:00:00 CDT