Ads by TechWords

See your link here
Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Storage
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
 

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.

Additional Resources

Xerox
By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!
Microsoft
Save time and mitigate security risk. Deploy it now.
Sybase
In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

Speeding business innovation with HP Data Center Transformation solutions
Data center transformation enables your IT organization to focus more on business priorities and innovation by decreasing spending on maintenance and management by...  

Four Principles for Reducing Storage TCO
(Source: Hitachi Data Systems) Difficult economic times require new strategies for reducing costs. Where storage technology and economics meet, there are...

HP Data Center Transformation Solutions
CIOs today are challenged to respond to economic and business pressures, to change from being cost centers to becoming strategic business enablers. There...  

Boost your CAE productivity, and break-away from the pack
(Source: Sun) Join Clemson University as they present their groundbreaking engineering simulations research at their Computational Center for Mobility Systems. Dr. James Leylek,...

Using Symark PowerBroker™ to Enrich Your Organization's RBAC Model
The essential notion of Role-Based Access Control (RBAC) for IT security administration is establishing permissions based on the functional roles within the enterprise,...  

Deduplication and Other Strategies for Protecting Your Assets with the Veritas NetBackup Platform
(Source: Symantec) Many companies find their backup and storage resources strained by data growth and increased regulatory requirements for data retention. In today's...

Using VMware Site Recovery Manager to Simplify DR
(Source: NetApp) Nothing is scarier than the prospect of having to recover an entire site after a disaster. VMware® Site Recovery Manager (SRM)...  

Controlling Email and File Server Growth and Costs with Intelligent Archiving
(Source: Symantec) According to IDC 54% of the storage capacity added by organizations in 2008 will be dedicated to the storage of file-based...

NetApp and VMware Virtual Infrastructure 3 Storage Best Practices
(Source: NetApp) NetApp has been providing advanced storage features to VMware ESX solutions since the product began shipping in 2001. During that time,...  

Maximize Storage Assets with Thin Provisioning, Tiered Storage, and Cluster File Systems
(Source: Symantec) Thin Provisioning is an opportunity to immediately optimize your storage systems and make more capacity available to your applications. In order...