applying cvs-like operations to data in database?

[Marcel van der Boom]

Hi,

Maybe I'm a little off-topic here, so I apologize in advance if I am.

I'm looking for pointers to apply versioning to data stored in a RDBMS visible
to users of the database.

Functionality should range from storing diffs for each and every update in the
database to initiating a store of a diff related to a previous one, or at
specified intervals.
These diffs should be *online*. In the long run there should be something
like:"View the data in this dataset for revision 1.45, for a past date or with
tag "This was an important state of the data"
Revision number functionality like CVS does for each record would be the
ultimate (and may be required too..)

- Any pointers to techniques to accomplish the above?
- How about literally using cvs to generate the appropriate information?
- Are these questions equivalent to asking whether there is a cvs implementation
with a rdbms as back-end? A glimpse of the modelling principles would get me
started just fine.

Thanks!

Marcel

marcel.vcf
Description: Card for Marcel van der Boom