Thursday, April 16, 2009

XML is Everywhere in SOA, so why store it differently?

Have you ever seen a SOA architecture chart like this:

XML is everywhere. It used to interchange information. It is used to submit functions via SOAP and web services. It is used in the presentation tier and business logic tier. So, why change it. If your SOA application uses XML everywhere why change it into some relational format. Just store it in the DBMS as XML. That's what DB2 pureXML does.

Well that keeps it simple, but then the next question how do I get it into and out of the DBMS? We could do it the traditional approach of writing some application code in Java/C# to put the data into and out of the database via JDBC, but why not use XSL, SQL or stored procedures for this. Wait, but what does SQL and stored procedures have to do with this? Just like we suggested not to shread the XML into relational to store it, you don't have to transform it into some OO objects to process it.

Sounds hard! Actually with Data Studio data web services (DWS) it's easy. DWS allow you to take any DML SQL or stored procedure and drag and drop it into a web services. And that service could run as XML using Data Power. There is some very nice integration between DWS and data power and which you learn more about from Michael Schienker's blog entry.

Thursday, April 2, 2009

Data Studio 2.1 fp1 (DSD, DSA, IDA, PE)

Data Studio released a series of fixpacks April 1, 2009. No this is not an April fool's joke. :-)

This was mostly a bug fix fixpack which included some usability fixes.

You can find them at the following links:
IBM Data Studio Developer, Version Fix Pack 1
IBM Data Studio pureQuery Runtime Version 2.1.1 Fix pack 1
IBM Data Studio Administrator Version Fix pack 1

DB2 Performance Expert Version 3.2.1 Fix Pack 1
DB2 Performance Extended Insight Feature, Version 3.2.1

InfoSphere Data Architect Version Fix Pack 1

Let the downloading begin.

If you need more details on how to install the fixpack, check this out: