IBM to unleash 'Venom' in DB2 database

By Shelley Solheim

April 24, 2006 12:00 PM ET

Recommended

(0)

Digg

Twitter

Share/Email

IDG News Service - IBM Corp. is building new storage-compression technology into its forthcoming "Viper" DB2 database server that it says can cut storage needs by more than half.

The technology, code-named "Venom," allows database administrators to compress rows in database tables by scanning tables for repetitive, duplicate data in rows and building dictionaries that assign short, numeric keys to those repetitive entries. According to IBM, this compression can provide disk, I/O and memory savings, and beta testers of the technology have been able to reduce storage needs by more than 50%.

With Viper, set to ship this summer, administrators will have the option to use the compression technology on a table-by-table basis, as not all applications benefit equally from the technology, IBM said. The company will provide tools to allow administrators to estimate potential savings before building dictionaries.

"Transactional applications don't see as much benefit, but query applications -- where you spend more time looking at information and asking questions -- tend to find more benefit," said Jeff Jones, director of strategy for information management software at IBM, in Armonk, N.Y.

IBM developed Venom from hardware-assisted compression technologies the company had built for DB2 running on the mainframe, he said.

"From that we gained a lot of experience with compression algorithms and the science of compression," Jones said.

IBM also is building other storage-management capabilities into Viper that will allow database tables to draw automatically from a pool of storage, so that administrators don't have to manage storage at the table level.

Reprinted with permission from

IDG.net
Story copyright 2009 International Data Group. All rights reserved.

Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Jump to comments

Storage

Additional Resources

WHITE PAPER

Do You Know the 7 Steps to Successful Data Migration?

Approximately 60 percent of data migration projects overrun time or budget, while some fail completely. Download this white paper, "Enhancing Your Chance for Successful Data Migration," to learn the critical steps you need to take to execute a data migration project with minimum cost and risk to your business.

WHITE PAPER

Total Cost of Ownership of Server Computing Vs. PCs

Read the Gartner research note to learn why the TCO of a server-based computing deployment used to deliver all applications to users is around 50% lower than that of an unmanaged desktop deployment.

WHITE PAPER

IDC White Paper: Linux in a Global Recession

Economic downturns have a tendency to accelerate emerging technologies, boost the adoption of effective solutions, and punish solutions that are not cost competitive or that are out of synch with industry trends. This IDC White Paper presents the results of an IDC survey of 330 companies in Western Europe, Asia/Pacific and the Americas that measures the receptiveness to Linux and takes into consideration changing views driven by the disruptive economic environment that businesses face today.

White Papers & Webcasts

Informatica 9 Launch: Transform your Business. Transform your world.

LIVE Nov 10, 2009 12:00 PM ET

Architecting Business Intelligence Applications for Change: The Open Solution

LIVE Nov 12, 2009 02:00 PM ET

Connecting to the Cloud with F5 and VMware VMotion
F5 and VMware partner to enable live application and storage migrations between datacenters and clouds, over short or long distances.

Data Protection is not an insurance policy -you cannot buy-back lost data
Find out why you need to maintain access to critical information to run your business and remain competitive.

SiliconFS - The BlueArc Filesystem
Learn the power of the BlueArc family of products to enterprise storage management features, providing real value for its customers.

Strategic ECM Webinar
Learn what new strategic business benefits can be realized through ECM!

Enabling Enterprise Class Features for the Mid-Range
Learn how BlueArc's new storage platform, BlueArc Mercury™, scales in fixed increments that make it easy to install and deploy, scales up to...

Rethinking Business Continuity and High Availability in Storage - HP and Forrester Pre-Recorded Webcast
Download it.

Tabor Research: NFS Evolution Changes the Landscape of HPC Data Management
A hybrid file system combining the benefits of standard NFS and the performance and scale of parallel file systems.

5 Architecture Issues that Impact BES performance
Register to attend this LIVE Webinar to learn 5 Architecture Issues that Impact BES performance!

Intelligent Tiered Storage: BlueArc's Implementation
This ESG White Paper discusses the importance of tiered storage, examines BlueArc's approach to intelligent tiering, and shows how it creates operational value...

Four Principles for Reducing Storage TCO
View cost reduction strategies in this video! Provided by Hitachi Data Systems.

All White Papers | All Webcasts