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.
- A Modern Approach to the Data Deluge Read this whitepaper to learn how infrastructure leaders can confidently manage cost, complexity, and risk, capitalize on emerging technologies, and drive future innovation...
- 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.
- The Truth About Virtual Computing for CAD If you're a user of graphics-intensive software such as 3D modeling, simulation and analysis, and visualization, you might be skeptical about moving to...
- Going Paperless? Here's What You Need to Think About As makers of some of the world's most popular PDF solutions, we often consult with businesses & governmental agencies that have the goal...
- 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...
- What should I look for in a Next Generation Firewall? SANS Provides Guidance With so many vendors claiming to have a Next Generation Firewall (NGFW), it can be difficult to tell what makes each one different.... 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!