Can you recommend a book that explains different strategies for
implementing data versioning in relational databases? I'm no database
expert. My intuition tells me that for each table, I'd want to start
by adding an extra column containing a revision number. So each
change to the data results in a new row with a new revision.

This seems inefficient, particularly when you have 30 columns and
only two fields changed...it results in a lot of redundantly stored
data.

I guess I'm just not searching for the right thing, because I cannot
find any good info on this topic. I'm mostly interested in "generic"
relational/SQL solutions that would work on a variety of databases,

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri May 09 2003 - 13:43:24 CDT