In Firebird-general@yahoogroups.com,
"Martijn Tonies" <m.tonies@u...> wrote:

> > what do you mean by v3 or v4?

> Oracle v3 or v4 :-)

From
http://firebird.sourceforge.net/
doc/whitepapers/
fb_vs_ibm_vs_oracle.htm

________________________________
Firebird is naturally multi-versioned,
while Oracle acquired this feature in
Oracle 7.x. Until than it had an
architecture similar to IBM DB2.
____________________________________


Though it is my *_understanding_* that Oracle
had started to partially implement MVCC
since V4 of their db - not sure where I read
this, but I'm sure that I've seen it
written down someplace.

> > I have carefully read some local articles, and seems that
> > MS SQL 2005 versioning copied 95% of IB/FB versioning.

> I thought they only do a part of this, with "snapshot transaction",
> but not for the rest?

We'll have to wait and see what the
Great Satan(tm) has planned for
MGA/MVCC - though mind you, with
all the delays, I may not be around
to see it (and I'm a young man!).

> > already? I'm not sure about their transaction support,
> > so versioning here does not mean so much. I'm wrong?

> InnoDB has transaction support and Foreign Key Constraints.

It would appear from

http://www.phpbbserver.com/phpbb/
viewtopic.php?t=537&mforum=dizwellforum

that the language is very similar to the article by
Roman Rokytskyy on IB/FB's MGA model. Part of
the reason I started this thread.


Paul...

> Martijn Tonies