Story image

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

12 Nov 2014

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.

Dropbox invests in hosting data inside Australia
Global collaboration platform Dropbox has announced it will now host Australian customer files onshore to support its growing base in the country.
Opinion: Meeting the edge computing challenge
Scale Computing's Alan Conboy discusses the importance of edge computing and the imminent challenges that lie ahead.
Alibaba Cloud discusses past and unveils ‘strategic upgrade’
Alibaba Group's Jeff Zhang spoke about the company’s aim to develop into a more technologically inclusive platform.
Protecting data centres from fire – your options
Chubb's Pierre Thorne discusses the countless potential implications of a data centre outage, and how to avoid them.
Opinion: How SD-WAN changes the game for 5G networks
5G/SD-WAN mobile edge computing and network slicing will enable and drive innovative NFV services, according to Kelly Ahuja, CEO, Versa Networks
TYAN unveils new inference-optimised GPU platforms with NVIDIA T4 accelerators
“TYAN servers with NVIDIA T4 GPUs are designed to excel at all accelerated workloads, including machine learning, deep learning, and virtual desktops.”
AMD delivers data center grunt for Google's new game streaming platform
'By combining our gaming DNA and data center technology leadership with a long-standing commitment to open platforms, AMD provides unique technologies and expertise to enable world-class cloud gaming experiences."
Inspur announces AI edge computing server with NVIDIA GPUs
“The dynamic nature and rapid expansion of AI workloads require an adaptive and optimised set of hardware, software and services for developers to utilise as they build their own solutions."