Month: April 2006

IBM are close to releasing the next version of their DB2 database, codenamed ‘Viper’, which they plan will steal some of Oracle’s market share.

Unless they have changed things though, I am not a fan of DB2 from experience developing a web-based application over the last 2 years that has DB2 at the backend. The problem with DB2 is that it has what I consider to be an ‘old-school’ (or traditional?) locking strategy that just does not work well with today’s web-based applications with many (thousands) of concurrent users. Even when using an optimistic locking strategy controlled either by the application or an ORM tool like Hibernate, it’s still hard to avoid DB2’s pessimistic locking, and therfore unavoidable that at some point you will have users or even processes deadlock against each other.

I don’t claim to be a DBA, but I know from working with Oracle for many years that deadlocks were never an issue, and no, we were not using an uncommitted read isolation level, we were still using read committed.

What I have found out more recently is that ‘modern’ RDBMSs (I say that tongue in cheek and now expect to get flamed from the DB2 croud) such as Oracle, InterBase and it’s derivitives such as FireBird, and other open source database engines such as PostreSQL and MySQL (with the InnoDB engine), use a mechanism called Multiversion Concurrency Control. What this does is it achieves transaction isolation not by using pessimistic locks which we know is an approach that does not scale well for systems with many concurrent users or processes, but by using snapshots of the data taken for each transaction so that each transaction has a copy of the data being read or written, plus the use of a version value or timestamp on the current row, similar to how optimistic locking works if implemented in application code or using ORM tools like Hibernate. If a transaction attempts to update data that has already been updated by another process since the initial data was read, the version values will not match and the transaction will have to be repeated by the user.

Using this approach, readers do not block writers and writers do not block readers. This approach is far more applicable for usage in online systems today where we need to support large numbers of concurrent processes.

Does anyone know if DB2 Viper will be using Multiversion Concurrency?

Recognizing that many users want to additionally install Windows on their new Intel-based Macs, Apple has released a beta version of software called ‘BootCamp’ that allows them to dual boot their system.

If you use Mambo CMS for a website and haven’t updated recently, now might be the time to consider upgrading and patching.

This post talks about a vulnerability that has been found in the server. I just had first-hand experience of someone hacking one of my sites that uses Mambo. It seems that the security hole allows someone to get access to and overwrite the configuration.php file with their own HTML content, and have this page displayed instead of the Mambo-based site.

This is the first issue that I’ve had with Mambo up until this point.

Sony has announced May 8 as the date of the pre-E3 conference press conference to reveal details of the much awaited PS3 console.

Hopefully details of price and initial games line up will be announced, plus final details of what we can expect to get in the box when it ships in November. There are still some details about the console that are up in the air. I am most interested in what is going to be shipped on the integral 60GB preinstalled with Linux – does this mean I can install additional software on the machine? What other software will come on the box? Is it going to be a media server type device as rumoured?