Versioning

["Alexey Parshin" <alexeyp@gmail.com>]

There are several ways to do versioning.

Here is one:

Every object  should have a version number, a reference to an object it's derived from (previous version), and a reference to the original object. The separate table should hold object class, original object id, and the latest version of that object available.

The question is how to indicate the latest version of the object. We can move the connections of the old version to the new version, if the new version stays with the same parent object. If we need to step back to prior version - we just switch connections to required version. All the versions have the same original object id reference.

2006/10/20, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>:

Few more things, at we are going to be in good enough shape to
start writing stored procs
- I don't see where student's solution of a problem is stored
- Versioning support
- DoT doesn't look too close to what I was thinking, but I'll leave
  it alone till I know what it really should be working like.

Probably there are other things I missed, so we'll change
schema later as needed.

--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com

-- 
Alexey Parshin,
http://www.sptk.net