IBM DB2 10 Aims to Tame the Data Deluge
Written by Kay Ewbank   
Thursday, 05 April 2012

 A new version of IBM DB2 10 has been released aimed at ‘taming the data deluge’. According to IBM, the new release continuously accesses, compresses, and analyzes data, freeing up IT staff to work on higher value tasks such as big data and business analytics.

The new release of the Linux, Unix and Windows version has been under development for the last four years and IBM says can perform data warehouse queries up to 10 times faster as well as freeing up storage space by up to 90 percent.

 

DB2LOGO10

 

Alongside DB2 10, IBM has released InfoSphere Warehouse 10. The new version of DB2 can be used to carry out real-time analysis of unstructured as well as structured data, and support has been added for incorporating data from Hadoop-based systems.

The storage space reductions have been achieved by using adaptive compression and ‘multi-temperature data management’. In other words, the database automatically assesses how frequently data is needed and moves it to different types of storage based on how "hot" or "cold" it is.

The creative feature naming continues with so-called “Time Travel Queries”, which uncover underlying data relations at any point in time. The example given is that of an online travel agency being able to automatically detect inconsistencies in itineraries such as a hotel booked in Rome for eight days while a car is reserved in New York City for three of those days. This will be impressive if it proves to be workable, though someone would still have to bother to actually look for the inconsistencies, which is in our experience where most business intelligence analysis falls down.

 

DB2logo10square

You can read more about DB2 and InfoSphere Warehouse software here.

 

espbook

 

Comments




or email your comment to: comments@i-programmer.info

 

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Google+, Twitter, Linkedin or Facebook or sign up for our weekly newsletter.

 

Banner


Making Money From Subscription Apps
02/04/2025

The findings of RevenueCat's State of Subscription Apps Report show wide discrepancies in revenue potential between the top percentile of apps and the rest. Travel and photo apps are best earners.



Deno 2.2 Adds Built-in OpenTelemetry
06/03/2025

Deno 2.2 has been released with built-in OpenTelemetry among its improvements. Other changes include new Lint plugins, and support for node:sqlite.


More News

Last Updated ( Friday, 06 April 2012 )