Story image

Insights without the wait – how BLU is the new fast track

12 Nov 14

Every business, from the small, local service specialists to the best-known brands, generates an enormous amount of data. We often see this described by technology vendors as the greatest non-human resource of any organisation. Little wonder, then, that the question of how to exploit this resource and get better, faster insights is a preoccupation of most IT departments. Kyle Southam, Dimension Data’s Principal Consultant – Managed Services, answers some questions about in-memory computing in the form of IBM’s DB2 BLU:

Why do businesses find it hard to get the value they seek from their data?
Customers are finding themselves with data warehouses where they have to install high priced hardware, running expensive database systems, to cut down the time of running reports and queries across millions of rows of data. Even then, the time is typically cut from days to hours.

You conducted some fairly comprehensive testing of IBM DB2 BLU, is that something DD typically does with products it recommends?
Obviously every vendor will make a persuasive argument that their product is the best, but as an independent advisor, it is imperative that we confirm for ourselves the strengths and best fit of anything we offer. That way we can be confident in our recommendations.

So how did DB2 BLU compare with other options?
Compared to standard DB2 out of the box, we found DB2 BLU showed an increase on a 120,000,000 row data set of between 5x and 3000x the performance.

What about the promised storage reductions?
We achieved up to 80% reduction of storage on our test server, but on top of that, data remains compressed whilst it resides in the database’s buffer pool, maximising the amount of raw data that can fit in memory. Dimension Data found that DB2 far outpaced Solid State disk and completely removed the need for any indexes, again reducing disk space.

How much difference does that make?
Consider a 10TB table within a data warehouse with 100 columns.  If half of those columns require indexing, then the space taken up by indexes could far outweigh the size of the table. The task of hunting through queries to work out what indexes are required would be extremely time-consuming. DB2 BLU makes indexing unnecessary. No more indexes to offline or rebuild after data load also equates to a faster data load.

Does DB2 BLU tie businesses into using IBM hardware?
Even though DB2 BLU is optimised for Power Systems, making that a great choice in many environments, it also runs very effectively on Intel hardware. IBM Power Systems are certainly a great complement to DB2 BLU as well as bringing their own benefits to compute-intensive workloads.

What else should be considered when thinking of making a switch to DB2 BLU?
Changing database technologies is not without challenges and DB2 assists with this through comprehensive Oracle SQL/PL-SQL compatibility. A careful review by our specialists will make sure you get the best outcome for your specific circumstances.

Where can I find out more?
Contact Kyle via email or register your interest here and he will be in contact when it suits you best.

Survey reveals CX disconnect is risky business
Too much conversation and too little action could lead companies to neglect, lose, and repel their very lifeblood, according to Dimension Data.
Should AI technology determine the necessity for cyber attack responses?
Fujitsu has developed an AI that supposedly automatically determines whether action needs to be taken in response to a cyber attack.
Police making progress into Cryptopia breach
New Zealand Police say they are making ‘good progress’ into the investigation of an alleged cryptocurrency theft from Christchurch-based crypto exchange Cryptopia.
NEC concludes wireless transport SDN proof of concept
"Operation and management of 5G networks are very complicated and require automation and closed-loop control with timely data refinement and quick action."
Trend Micro’s telecom security solution certified as VMware-ready
Certification by VMware allows communications service providers who prefer or have already adopted VMware vCloud NFV to add network security services from Trend Micro.
Top cybersecurity threats of 2019 – Carbon Black
Carbon Black chief cybersecurity officer Tom Kellermann combines his thoughts with those of Carbon Black's threat analysts and security strategists.
Avaya introduces private cloud delivery of its UCaaS solution
Avaya is supposedly taking a flexible hybrid approach to the cloud with these new solutions.
Data growth the growing case for managed colocation
The relentless growth of data could see colocation take on a new importance, says Jon Lucas.