Es geht doch

Der angesprochene Testbericht bringt noch mehr Wahrheiten über DB2 9 zu Tage. So wie zum Bloor "White Paper" werde ich hier einige zentrale Aussagen aneinander reihen:

(zu XML)

"IBM's technology outdoes its competitors, however, by preserving the native format of XML data." (nach leo bedeutet "outdo" "übertreffen")

... und

"Instead of storing the XML as a BLOB (binary large object) or parsing it into relational key/value pairs, pureXML stores the XML file itself, with all its properties and hierarchical structure preserved."

Die Nachricht ist also endgültig bei der CW angekommen.

Auf der nächsten Seite geht es weiter:

"The pureXML engine also provides more efficient indexing, because individual XML nodes aren't stored merely as strings. According to IBM, customers who have already adopted the new engine have reported performance increases of approximately 5 to 7 times over what they were getting from Microsoft or Oracle."

Beeindruckend!

Ähnliches hat auch der IT-Leiter eines international agierenden Handelsunternehmens für eine Anwendung berichtet, in der eingescannte Kassenbons aus aller Welt (Soll heißen: Europa) im XML-Format in der Datenbank gespeichert und ausgewertet werden.

Der Testbericht erwähnt auch eine interessante Anwendung des XML-Datentyps, die die übliche, eher allgemeine Platzierung im SOA-Universum konkretisiert:

"One very interesting feature of the pureXML engine is that it will preserve digital signatures of signed XML files. If you receive a digitally signed XML file, you can load it into the database, retrieve it at any time in the future, and the digital signature will still be intact. Microsoft and Oracle can't do that; but then again, it isn't a widespread requirement."

Noch nicht!

("Statistical views")

Das sind Statistiken, die für Views geführt werden können - ein neues DB2 9 Feature.

"IBM isn't the only one to consider blurring the line between views and tables, but it is the first to implement it."

("Compression")

"I performed an initial benchmark just to get an idea of the performance difference between two identical tables, one that was compressed and the other that was not. I found that the performance between the two was close, but the compressed table often actually performed better than the uncompressed table (presumably because more of its data fit in memory)."

"All the same, if I had to pick one feature that puts DB2 ahead of any of the other databases, this would definitely be the one, because it's going to be far more useful to the largest portion of the client base. I would imagine that Oracle and Microsoft are both scrambling to be the next to bring this to market."

Da bin ich gespannt!

(Resumee)

"The new DB2 is a technically impressive release. It's loaded with features that are sure to please DB2 admins and developers alike."

Die Übersetzung dieses Zitats findet man weiter oben.

"Viper's groundbreaking row-level compression is where most customers will see the greatest returns."

Sowohl der Testbericht als auch der Artikel in der Papierausgabe der CW fragen abschließend:

"Ob diese Features allerdings verlockend genug sind, um einen eingeschworenen Oracle-Datenbankadministrator dazu zu bewegen, die Plattform zu wechseln, bleibt abzuwarten."

Möglicherweise sind Oracle-DB-Administratoren skeptisch, denn schließlich geht es um ihre Arbeitsplätze.