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.

 

blog comments powered by Disqus

 

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


Windows Not 9 But 10
01/10/2014

The next version of Windows has just been presented to the world and  the biggest surprise is that it is to be called Windows 10 rather than the more logical Windows 9.



JetBrains Releases New Version of PHP IDE
25/09/2014

The changes to PhpStorm 8 have been designed to make it easier to use emerging web technologies that include both back-end and front-end development. The designers say it has ‘even deeper code under [ ... ]


More News

Last Updated ( Friday, 06 April 2012 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.