topics that matter; ideas worth sharing

share a tip, submit a link, add something new

IBM to unleash 'Venom' in DB2 database

April 24, 2006, 09:53 AM —  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 percent.

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, New York.

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.

» posted by abennett

IDG News Service

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
Resources
White Paper

Symantec Backup Exec 12 and Backup Exec System Recovery 8 deliver industry leading Windows data protection and system recovery. Download this whitepaper to find out the top reasons to upgrade and how to get continuous data protection and complete system recovery.

Webcast

Data and system loss — from a hard drive failure, malicious attack, natural disaster, or simple human error — can happen anytime. Don’t leave your business vulnerable. Make sure you have a secure recovery strategy in place. Symantec's latest backup and system recovery technology can efficiently restore critical applications, individual emails and documents and even restore your entire system in minutes in the event of a loss.

White Paper

Businesses face a growing challenge to ensure that the IT environment is properly protected. Backup Exec 12 integrates with other applications in the Symantec family of products, to complement your current data protection strategy, keep your data securely backed up and make it recoverable when you need it most.

Free stuff
Featured Sponsor

Get a broad understanding of important regulations and how you can make sure your site is in adherence.





Learn how VeriSign SGC-enabled SSL Certificates can help improve site security and customer confidence in the free white paper, "How to Offer the Strongest SSL Encryption." In this paper you will learn the differences between weak and strong encryption and what they mean for your site's performance.

Get VeriSign's free white paper: "The Latest Advancements in SSL Technology" and learn about the benefits of strong SSL encryption, Extended Validation (EV) SSL and security trust marks and what these SSL offerings can do for your site.

Now with Extended Validation (EV) SSL available from VeriSign, you can show your customers that they can trust your site. Learn about EV SSL benefits in this free VeriSign white paper.

More Resources