13/11/2007

IBM DB2 9.5: a reliable Viper to protect you data

From November 7th to 9th I went to IBM Italy (Segrate, Milan) to attend the DB2 9.5 Viper 2 Bootcamp.
The tearchers were Michele Benedetti and Ernesto Beneduce, both very skilled on DB2 (and over...) and also truely available to answer to our technical questions.

Before the bootcamp, to me DB2 was just a black box, just another DBMS as mySQL, MS SQL Server, Oracle and so on... now I realize that DB2 deserves a lot more attention.

It's really powerful and up-to-date, and version 9.5 is technically very sophisticated:
I just got a good tasting ot its powerfulness. ;-)

Here are news about the DB2 9.x:
  • it was developed using more than 70 new patented technologies
  • it's the first DB server to deal with both relational AND XML data on the SAME data server
  • XML data are managed/stored by a technology called pureXML (patented)
  • the XML data can be queried using SQL statements and/or Xquery statements
  • you can both correlate relational data and XML data: very powerful!
  • except pureXML (storing data), XML management is done using open standard protocols approved by W3C (xQuery, xPath, XML schema...)
  • DB2 supports very sophisticated Table Partinioning and Clustering
  • DB2 is more "clever" than before because it supports several auto-tuning smart procedures, first of all STMM, i.e. Self Tuning Memory Manager
  • DB2 support table row compression to save server space on disk, and it wins over Oracle too!
  • it implements a new security facility to control access to data: it's called LBAC, label-based access control, and permits to (security) administrator to "label" data using logical names, both for table rows and columns
  • today DB2 is the preferred DBMS by SAP

I was happy to realized that DB2 server is really very powerful, and also that the management tools are getting better and better.
Moreover DB2 is becoming smart enough to take care of itself, managing server resource allocation in a clever way.
But the really new feature for DB2 is ways you can deal with XML data:
I don't mean "just" xml storage, but also querying and mixing that XML data with "usual" relational data. Great work, IBM!



Here is a review from the press:
“First, I think this leaves Oracle and Sybase (as the two vendors with the best
current handle on XML) well behind the curve, with Microsoft and the others more
or less out of sight. What this release will allow you to do is to build applications
that handle both XML and relational data much more easily, without losing any of
the richness that this implies, and without degrading performance.”
- Philip Howard, Bloor Research, The Register

No comments: