IBM continues to pursue its Big Data ambitions, this time with an upgrade to its flagship DB2 to v10 along with InfoSphere Warehouse 10 that integrates with Big Data systems and compresses data into tighter spaces.

IBM and Big Data

The race to corner the market for Big Data management is gathering pace, and, in the case of IBM, runs in parallel to the developments of its analytics products that have seen it buy companies in the space as quickly as they come up on the market.

But it’s not the only player in a market that has seen many other players in the same space boost their offerings, like Oracle, which added Hadoop connectors that tie it into Hadoop-based systems.

According to IBM, this is the first time in four years that it has updated DB2, but in light of the number of new products that are coming onto the market, particularly in the area of high-performance applications, it really had do something.

This is compounded, of course, by the social network explosion and the massive amount of data that is now available through these networks and the drive by enterprises to take as much meaning from the information contained in them as possible.

DB2 10, InfoSphere Warehouse 10

DB2 10 and InfoSphere Warehouse 10 respond to that explosion and, while integrating with big data systems, also offer enterprises way to compress data into smaller spaces and prevent storage sprawl.

It also slices both past and future information to eliminate expensive application code.

During testing, IBM says, users clients performed individual data warehouse queries up to 10 times faster and freed up storage space by up to 90%. Significantly, it migrated data from expensive Oracle Database to IBM DB2 software with 98% code compatibility that didn't require changing the data or retraining staff.

Some of the features that IBM is particularly pushing include:

  • Query enhancements: IBM says workload management and query enhancements means they now run up to 3.3 times faster than before.
  • DB Compatibility: It offers native support for most data types of SQL syntax, PL/SQL syntax and scripting syntax. It makes it easier for users to move from Oracle Database to DB2.
  • DB2 pureScale: IBM has also enhanced product support for the DB2 pureScale features.
  • Adaptive Compression: It is applying adaptive compression techniques to DB2 10 and InfoSphere Warehouse 10, further compressing data savings.
  • Continuous Ingest: DB2 10 and InfoSphere Warehouse 10 add a parallel ingest utility that supports the continuous ingest of data.

Of course, there’s a whole pile of other features that IBM has added. It has also tested them with some of the bigger companies in the US, including Coca-Cola, which migrated from Oracle to IBM and says it saved more than US$ 1 million over four years on licensing, maintenance and storage costs.

DB2 10 and InfoSphere Warehouse 10 also include enhancements to security, workload management, index management, monitoring, high availability and resiliency features in the product. Version 10 of both products will be available April 30.