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.
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.
You can read more about DB2 and InfoSphere Warehouse software here.