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


Edera Protect Expands Security Model
27/03/2025

Edera Protect for Kubernetes is now available as a 1.0 release that the company says is generally available and production-ready. Improvements in the 1.0 release include an expanded security mode [ ... ]



Pi Day 2025 - The Mystery Of Infinity
14/03/2025

Pi isn't infinite but it exemplifies the problem with allowing infinity into your life. Every year March 14 (3.14) is celebrated as Pi Day by π aficionados across the globe who can use it as a e [ ... ]


More News

Last Updated ( Friday, 06 April 2012 )