Ads by TechWords

See your link here
Receive the latest technology news and information.
Storage
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
Cloud Computing
View all newsletters




Privacy Policy
 

IBM to unleash 'Venom' in DB2 database

April 24, 2006 12:00 PM ET

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.

Jump to comments

Storage

Additional Resources

WHITE PAPER
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
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
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

Data Manager Report Excerpt: File System Inventory
Cut storage costs and boost operational efficiencies.  

Key Strategies for Managing Data Growth
What are you storage challenges?

Reducing Storage Costs with F5 ARX
Save money- deploy ARX Solutions.  

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.

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

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