Firebird and Multi Version Concurrency Control – why is so good

Spotted on dotnetfirebird blog
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.

I found this quote on the Hibernate Tuning blog: [Ed:They linked to the Roman’s Page , Scroll down to “db2 and friends”]

In fact glaring are the benchmarks published by MySQL. I’d put to you that MVCC support is probably more important than a lot of other concerns in transactional computing (as opposed to batch processing and OLTAP type stuff)

Backup Firebird Databases

There are to different backup Systems in Firebird:

nBackup included in Firebird 2.0 an up

and gBak included in Firebird since humm, good old Borland days back in 199x up to the (still in beta) Firebird 2.0.

When you dont want to struggle with the commandline switches of gbak, you can use the (very useful) GUI-Frontend for gbak developed and provided for free by Talat Dogan: FIBS Firebird-Interbase Backup Scheduler

Read more on this blog

Jim Starkey: Introducing Falcon (Storage Engine for MySQL)

Last session of the MySQL UC is Jim Starkey giving an introduction to the new Falcon storage engine. Jim is an icon in the database field, was the creator of MVCC and the BLOB data type. There’s a can of Falcon beer for anyone who asks a good question.

Read the Falcon intro

[Ed :When i read the word Falcon i always associate it with Millennium Falcon, Yes Jim is fighting a good cause against evil empire ;)]

1 278 279 280 281 282 294