IBM remolds DB2 10.5 as a Hadoop killer
With a new set of acceleration technologies, DB2 10.5 could replace data warehouses or stand-alone in-memory databases, IBM claims
IDG News Service - In the new update of DB2, released Friday, IBM has added a set of acceleration technologies, collectively code-named BLU, that promise to make the venerable database management system (DBMS) better suited for running large in-memory data analysis jobs. "BLU has significant benefits for the analytic and reporting workloads," said Tim Vincent, IBM's vice president and chief technology officer for information management software.
Developed by the IBM Research and Development Labs, BLU (a development code name that stood for Big data, Lightening fast, Ultra easy) is a bundle of novel techniques for columnar processing, data deduplication, parallel vector processing and data compression.
The focus of BLU was to enable databases to be "memory optimized," Vincent said. "It will run in memory, but you don't have to put everything in memory." The BLU technology can also eliminate the need for a lot of hand-tuning of SQL queries to boost performance.
Because of BLU, DB2 10.5 could speed data analysis by 25 times or more, IBM claimed. This improvement could eliminate the need to purchase a separate in-memory database -- such as Oracle's TimesTen -- for speedy data analysis and transaction processing jobs. "We're not forcing you from a cost model perspective to size your database so everything fits in memory," Vincent said.
On the Web, IBM provided an example of how a 32-core system using BLU technologies could execute a query against a 10TB data set in less than a second.
"In that 10TB, you're [probably] interacting with 25% of that data on day-to-day operations. You'd only need to keep 25% of that data in memory," Vincent said. "You can buy today a server with a terabyte of RAM and 5TB of solid state storage for under $35,000."
Also, using DB2 could cut the labor costs of running a separate data warehouse, given that the pool of available database administrators is generally larger than that of data warehouse experts. In some cases, it could even serve as an easier-to-maintain alternative to the Hadoop data processing platform, Vincent said. Among the new technologies is a compression algorithm that stores data in such a way that, in some cases, the data does not need to be decompressed before being read. Vincent explained that the data is compressed in the order in which it is stored, which means predicate operations, such as adding a WHERE clause to a query, can be executed without decompressing the dataset.
Another time-saving trick: The software keeps a metadata table that lists the high and low key values for each data page, or column of data. So when a query is executed, the database can check to see if any of the sought values are on the data page.
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- Mission Critical: Managing Mobile Applications & Content Smartphones, tablets and other mobile devices have become embedded in enterprise processes, thanks to the consumerization of IT and a new generation of...
- Securing Mobility, From Device to Network At one time, the process of managing and securing mobile devices and applications was fairly straightforward. Most organizations worried about one application (email)...
- Planning for Mobile Success Many organizations are seeing clear and quantifiable benefits from the deployment of mobile technologies that provide access to data and applications any time,...
- Leveraging Flash Storage to Accelerate Oracle Real Application Clusters Join this webinar to understand the latest solid-state storage trends, the specific applications driving solid-state storage deployments and the benefits of deploying the...
- Keep Servers Up and Running and Attackers in the Dark An SSL/TLS handshake requires at least 10 times more processing power on a server than on the client. SSL renegotiation attacks can readily... All Databases White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!