Re: Design question-versioning using timestamps on rows

On 23 Jul 1997 01:52:26 GMT, "ADP / CSG" <dluik_at_sr.csg.com> wrote:
>I am looking for opinions from database designers on a versioning scheme.
...

Sounds like you understand the issues of temporal RDBMS. I've been involved in planning similar systems on a couple of occassions. In each case, more careful consideration of the requirements showed the capability was not in fact needed. Word to the wise.

If you must proceed, my preference is for a different architecture, a single current record and a history journal of time-stamped previous values. I've never yet had the chance to implement this all the way through. You'd hide most of it through views, of course, but to do a really good job, you need to extend SQL, too. Have you given that any thought? There are papers on TSQL (temporal SQL), I don't think too highly of, but they're out there.

Josh Received on Sat Jul 26 1997 - 00:00:00 CDT