IBM speeds up big databases

IBM has just released its latest incarnations of DB2 10 and InfoSphere Warehouse 10 which it claims will give users data access which is ten times faster.

The software has been sped up thanks to ideas that have come from the boffins in IBM’s labs. The idea is that the software continuously accesses, compresses, and analyses data. This allows IT staff to work on higher value tasks such as big data and business analytics.

It has taken four years to develop the software which was tested on more than 100 clients who did not die.

IBM said that with all this talk about big data, organisations were finding it difficult to get ideas from all the data they have stored. Social networks, sensors, and mobile devices, along with data growing inside business software, and this is making it even harder to find useful information.

Using the new software, clients managed data warehouse queries up to 10 times faster to speed up decision making, and freed up storage space up to 90 percent to dramatically reduce storage needs. They could migrate data from expensive Oracle Database to IBM DB2 software with 98 percent code compatibility.

But really the advantage is supposed to be how ideas are easily integrated with real-time analysis of structured data in the warehouse, to enable better and faster business decisions.

IBM claims that some of the database functions make it possible to look into the past and future to improve decision making, using a function called Time Travel Query. This enables easier access to data at any point in time, provided that Quantum cats don’t get in the way.

For example, an online travel agency can 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. Previously, database administrators and application developers had to write complex code to work this out.