Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Relational Database and Versioning
I do exactly this: adding "version_number" column.
But, tables where I need "versioning" are relatively small, so I'm not
concerned with extra storage.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Gennick
Sent: Friday, May 09, 2003 10:57 AM
To: Multiple recipients of list ORACLE-L
A friend sent me the query below about versioning the data in a database. I thought I'd throw it out to the list and ask what, if any, versioning solutions you see being used.
--
Best regards,
Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
Thursday, May 8, 2003, 10:42:31 PM,
Eric M. Burke (burke_e_at_yahoo.com) wrote:
Jonathan,
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,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
INET: jonathan_at_gennick.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: ineyman_at_perceptron.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message 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 - 12:27:12 CDT