Feeds

Using DB2 Information Integrator

Three examples

  • alert
  • submit to reddit

Security for virtualized datacentres

Briefing Note Yesterday, I give a brief overview of some of the facilities offered by IBM's newly announced DB2 Information Integrator, writes Phil Howard. Based on federation and replication, Information Integrator is at odds with the approach advocated by Oracle, which is more slanted towards centralisation.

However, we need to be clear what we mean by centralisation. If we mean the centralisation of transactional data or of content management data, then IBM is not in this camp. It believes (and I am inclined to agree) that centralisation is unnecessary, very costly and potentially risky in such situations.

On the other hand, there are clear advantages to having a single centralised data warehouse, for example, because you need to be able to support complex, multi-dimensional queries. In such a case it makes more sense to use a conventional ETL (extract, transform and load) tool to populate the data warehouse rather than attempt to federate it with transactional sources.

Similarly, complex transformational requirements may predicate an ETL-based approach, while a requirement for up-to-the-minute, consistent data may require a conventional replication environment.

IBM gives three examples in which it suggests that DB2 Information Integrator will be most useful. The first of these is to support analytical functions, where there is a need for real-time data analysis, a requirement for cross-enterprise views or for ad hoc enquiries across infrequently accessed data.

The second is in customer-centric environments (though this could also be to extend to suppliers, human resources and so on) where there is a need for customer self service and customer care details. And the third is to support migration and co-existence, as a result of mergers, acquisitions and re-organisations.

Of course, in this last example, part of the whole point of mergers and acquisitions is often to reduce administrative costs, which may mean getting rid of some IT resources so that database consolidation is a long-term requirement. Still, DB2 Information Integrator may still be useful in an interim capacity.

Actually, the scenario I have most problem with of those outlined is in the support for real-time data analysis. With companies like Apama specialising in providing real-time analytical capability, and ETL vendors introducing real-time data feeds into their products, I don't think this situation is as clear cut as IBM might like to think.

However, in a sense that is beside the point - it is clear that that are a variety of environments in which Information Integrator has advantages over other technologies - precisely what these environments are should become more obvious once the product is widely available and we have the experience of seeing it in action.

© IT-Analysis.com

Phil Howard's Biog is here

Providing a secure and efficient Helpdesk

More from The Register

next story
It's Big, it's Blue... it's simply FABLESS! IBM's chip-free future
Or why the reversal of globalisation ain't gonna 'appen
IBM storage revenues sink: 'We are disappointed,' says CEO
Time to put the storage biz up for sale?
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
Microsoft and Dell’s cloud in a box: Instant Azure for the data centre
A less painful way to run Microsoft’s private cloud
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.