DotNetFirebird.org DotNetFirebird
Using Firebird SQL in .NET.
Wednesday, May 03, 2006

Updated Firebird Downloads

I've updated the downloads page to show the most recent versions:
  • Firebird Server for Windows 1.5.3
  • Firebird Embedded for Windows 1.5.3
  • Firebird Server for Windows 2 RC1
  • Firebird Embedded for Windows 2 RC1
  • Firebird ADO.NET Provider 1.7.1 for .NET Framework 1.1
  • FirebirdClient 2 RC3 for .NET Framework 2.0

Firebird and Multi Version Concurrency Control

A nice white paper by Roman Rokytskyy that describes the multi version concurrency control system used in Firebird in comparison to IBM DB2 and Oracle 9i.

So how does it work? The main idea was already presented when we talked about MS Word opening a file in read-only mode, but there are some important details. As the name implies, each record in the system might have multiple versions visible to different transactions. When a transaction modifies a record, a new version is written to the database, and a previous version, representing only the difference between the version of the record that was read by the transaction and the new value of the record, is written as a back version of that record.


http://www.firebirdsql.org/doc/whitepapers/fb_vs_ibm_vs_oracle.htm

Search Firebird Questions .NET:
Oracle
DB2


Previous

Archives