IBM DB2 10 Aims to Tame the Data Deluge
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.

 

 
 



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


Apache Drill Adds YARN Support
17/04/2018

The new release of Apache Drill has added the ability to run Drill as a YARN application, along with support for HTTP Kerberos authentication using SPNEGO, and SQL syntax highlighting of queries.



GitHub Learning Labs Now Open For Newbies
19/04/2018

Once you know your way around GitHub its difficult to remember how it felt when it was an unfamiliar environment with its strange jargon of Commits, Issues, Pull Requests and so on. The newly launched [ ... ]


More News

Last Updated ( Friday, 06 April 2012 )
 
 

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