Feeds

IBM tools up DB2 with OLAP add-ons

Down in the data mines

  • alert
  • submit to reddit

HP ProLiant Gen8: Integrated lifecycle automation

The need for analytics is so great that, nowadays, even Microsoft bundles its database with a suite of the stuff. IBM previously took the approach of providing such functionality through third parties, but last week it souped up its offering with a new set of tools which, once again, demonstrates why Oracle is so concerned about this weighty competition.

IBM is to incorporate a couple of OLAP tools into DB2, enabling organisations to do data mining and analysis. They should provide a further boost to IBM's database product line as previously, customers had to choose which OLAP tools - usually third party solutions - IBM would bundle along with the database.

This will give IBM a perception boost in the market - everybody seems to think IBM is the last to venture down this OLAP track - but IBM's DB2 hardly needs such a lift.

In historical terms the relational database started out by providing transactional capabilities plus some standard query capabilities. The latter were then expanded into full-scale support for data warehousing, based on a ROLAP (relational OLAP) model.

In this area the next significant step was heralded by Microsoft's announcement that it would include multi-dimensional OLAP capability within its database product as well. This has since grown to the extent that all of the leading vendors now include this facility, and ETL (extract, transform and load) tools, and data mining capabilities within their database product architecture.

IBM typically goes further, providing a range of offerings that taken as the sum of its parts clearly outweigh the competition. It has tight integration with third party solutions, offers a whole range of data extenders - as well as support for most others in the market - and ties in beautifully with MQSeries, handling message queues as tables. And that's only scratching the surface.

While this latest announcement is a handy addition to IBM's portfolio, it won't actually do an awful lot to boost its business intelligence capabilities. Why? Because they have already wiped the floor with the rest. Microsoft offers some good solutions, and Oracle is never a slouch; but looking at the extent of IBM's offering it's clear that it holds the crown. The latest developments reinforce this position.

© IT-Analysis.com. All rights reserved.

The Power of One eBook: Top reasons to choose HP BladeSystem

More from The Register

next story
Apple fanbois SCREAM as update BRICKS their Macbook Airs
Ragegasm spills over as firmware upgrade kills machines
HIDDEN packet sniffer spy tech in MILLIONS of iPhones, iPads – expert
Don't panic though – Apple's backdoor is not wide open to all, guru tells us
NO MORE ALL CAPS and other pleasures of Visual Studio 14
Unpicking a packed preview that breaks down ASP.NET
Captain Kirk sets phaser to SLAUGHTER after trying new Facebook app
William Shatner less-than-impressed by Zuck's celebrity-only app
Microsoft takes on Chromebook with low-cost Windows laptops
Redmond's chief salesman: We're taking 'hard' decisions
Cheer up, Nokia fans. It can start making mobes again in 18 months
The real winner of the Nokia sale is *drumroll* ... Nokia
Mozilla fixes CRITICAL security holes in Firefox, urges v31 upgrade
Misc memory hazards 'could be exploited' - and guess what, one's a Javascript vuln
EU dons gloves, pokes Google's deals with Android mobe makers
El Reg cops a squint at investigatory letters
prev story

Whitepapers

Designing a Defense for Mobile Applications
Learn about the various considerations for defending mobile applications - from the application architecture itself to the myriad testing technologies.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Reducing security risks from open source software
Follow a few strategies and your organization can gain the full benefits of open source and the cloud without compromising the security of your applications.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Consolidation: the foundation for IT and business transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.