Feeds

DB2 Information Integrator goes live

Federation

  • alert
  • submit to reddit

High performance access to file storage

IBM yesterday (May 20th) published the packaging and pricing of DB2 Information Integrator, together with some case studies of customers that have been using the beta version. While DB2 Information Integrator can now be ordered, general availability begins on June 13.

IBM has also revealed its partnership programme. This includes both leading ETL (extract, transform and load) and Business Intelligence vendors, all of which have completed initial development projects in conjunction with DB2 Information Integrator.

For those of you that missed the initial announcement about DB2 Information Integrator in February, here's a recap.

Information Integrator (which is in version 8.1 to align it with the latest release of DB2) is based primarily upon the facilities of DB2, SQL and DataJoiner. The basic concept is predicated upon a federated database approach in which multiple heterogeneous databases appear to the user as if they were a single database.

However, Information Integrator is not limited to accessing relational data sources - it can also access XML, flat files, Microsoft Excel, ODBC, Web and other content stores, although updates and replication are limited to relational sources in the first release. Thus the full capabilities of DataJoiner have not been implemented in this release, although beta testing has shown improved performance compared to that product.

There are some key features of Information Integrator that should be mentioned. In particular, you can query data wherever it resides, as if it was at a single location, with a single view across all the relevant data sources.

The product supports queries by caching query tables across federated sources, while the optimiser will validate the SQL used against the source database and will automatically compensate if the relevant syntax is not supported on the remote database. Other features of the federation capabilities of the product include the ability to publish the results of a query to a message queue and to compose, transform and validate XML documents.

In terms of updates, replication and Information Integrator acts as a replication server, initially supporting Oracle, Informix, Microsoft, Sybase and Teradata databases, as well as DB2. Functions are flexible with support for both one to many and many-to-one topologies, table-based or transaction-based data movement (which may be dependent on whether you have batch or online requirements), and latency which may be scheduled, interval-based or continuous.

Perhaps the most notable feature of the beta trial has been the reports of increased developer productivity. This is partly because there is less hand coding required and, more particularly, because SQL queries do not have to be decomposed to act across the various databases involved. This is a complex task and requires experienced SQL programmers. Thus a subsidiary effect of the automation introduced by DB2 Information Integrator is that it reduces the skill requirement needed.

The big question is whether the market will warm to the concept of the federated database, which is enabled through DB2 Information Integrator.

Microsoft notionally embraces the concept but it has done little to implement it, while Oracle's approach runs directly counter to federalism, with the company espousing consolidation (centralisation) instead. Thus IBM has to market federation on its own. That shouldn't stop it: the idea nicely aligns with its On-Demand Computing concept and it will make sense to a lot of users.

What will be most interesting is how Larry will explain it when Oracle has to embrace it too. © IT-Analysis.com

High performance access to file storage

More from The Register

next story
Seagate brings out 6TB HDD, did not need NO STEENKIN' SHINGLES
Or helium filling either, according to reports
European Court of Justice rips up Data Retention Directive
Rules 'interfering' measure to be 'invalid'
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
Cisco reps flog Whiptail's Invicta arrays against EMC and Pure
Storage reseller report reveals who's selling what
Bored with trading oil and gold? Why not flog some CLOUD servers?
Chicago Mercantile Exchange plans cloud spot exchange
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Just what could be inside Dropbox's new 'Home For Life'?
Biz apps, messaging, photos, email, more storage – sorry, did you think there would be cake?
IT bods: How long does it take YOU to train up on new tech?
I'll leave my arrays to do the hard work, if you don't mind
prev story

Whitepapers

Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
HP ArcSight ESM solution helps Finansbank
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.