Subject | RDBMS feature timelines |
---|---|
Author | paulruizendaal |
Post date | 2005-04-14T12:22:47Z |
--- In Firebird-general@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
[..discussing features in oracle vs. firebird..]
I like this. Please help me in completing and correcting this table:
System: Firebird (Interbase)
Introduced 1983
Client/Server 1983
No table locks 1983
MVCC 1983
Hot backup 1983
Programmable 1983? or 1990?
Cluster -
Self-tuning 1983
System: Oracle
Introduced 1981
Client/Server 1985
No table locks 1988
MVCC 1998? (only 4 record versions, I'm told)
Hot backup 1988
Programmable 1992
Cluster 2001
Self-tuning 2004
System: SQLServer (Sybase)
Introduced 1988
Client/Server 1988
No table locks 1995?
MVCC 2005 (if yukon ships this year)
Hot backup ?
Programmable 1995?
Cluster -
Self-tuning -
System: MySQL
Introduced 1996
Client/Server 1996
No table locks 2000
MVCC -
Hot backup -
Programmable 2005 (in beta)
Cluster 2004
Self-tuning -
System: DB2
Introduced 1982
Client/Server 1988?
No table locks ?
MVCC -
Hot backup ?
Programmable ?
Cluster ?
Self-tuning ?
<Ivan.Prenosil@s...> wrote:
[..discussing features in oracle vs. firebird..]
I like this. Please help me in completing and correcting this table:
System: Firebird (Interbase)
Introduced 1983
Client/Server 1983
No table locks 1983
MVCC 1983
Hot backup 1983
Programmable 1983? or 1990?
Cluster -
Self-tuning 1983
System: Oracle
Introduced 1981
Client/Server 1985
No table locks 1988
MVCC 1998? (only 4 record versions, I'm told)
Hot backup 1988
Programmable 1992
Cluster 2001
Self-tuning 2004
System: SQLServer (Sybase)
Introduced 1988
Client/Server 1988
No table locks 1995?
MVCC 2005 (if yukon ships this year)
Hot backup ?
Programmable 1995?
Cluster -
Self-tuning -
System: MySQL
Introduced 1996
Client/Server 1996
No table locks 2000
MVCC -
Hot backup -
Programmable 2005 (in beta)
Cluster 2004
Self-tuning -
System: DB2
Introduced 1982
Client/Server 1988?
No table locks ?
MVCC -
Hot backup ?
Programmable ?
Cluster ?
Self-tuning ?