Hello, plinehan!

Wednesday, October 19, 2005, 3:57:15 PM, you wrote:

p> I was engaged in a debate about IB/FB's
p> MVCC model and various other issues about

Need some correction. InterBase's multiversion
architecture is named as Multi-Generational Architecture
(MGA). So, most of documents about Interbase refer to
MGA, not MVCC.

As to myself, I saw MVCC abbreviature at first in
PostgreSQL. Seems that PGSQL copied MGA from InterBase
(maybe not) and named it MVCC. It was done by some
russion programmer, sorry don't remember his name (maybe
it can be found at PGSQL sources).

Right now

- InterBase have MGA since 1985

- Oracle have versioning (named as semi-verisioning
because it have some problems with very long snapshot
transactions) since version 8.0 (am I right?).

- PostgreSQL have MVCC since ... (don't know).

- MS SQL 2005 will have versioning same as in InterBase/Firebird.

- MySQL will (? or already) have versioning ... don't know
about it's implementation or limitations.

These all show that commercial RDBMS' are moving to
versioning systems. And this also shows that
there is no new (extraordinal) thoughts in that area
since 1983-1985.

--
Dmitri Kouzmenko, www.ibase.ru, (095) 953-13-34