IBM Says New DB2 Will Require Less Storage - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
News

IBM Says New DB2 Will Require Less Storage

One reason is that a new feature in the next version of DB2, code-named Viper, will apply compression to data at the row level.

A key shortcoming of IBM's DB2 database is that it requires massive storage, but the company is promising to change that with its forthcoming release, due out this summer.

A new feature in that next version, code-named Viper, will apply compression to data at the row level, according to Jeff Jones, director of strategy for IBM's information-management software. Rows in database are the key data components in a horizontal field.

Although it's not the first time IBM has applied compression to DB2, Jones says the latest compression technology, called Venom, can cut in half the amount of storage needed for large data warehouses. In some instances, the compression ration was as high as 72 percent, he adds.

"The more data you have, the more physical disk you save," Jones says. "The savings are huge."

Not only does the technology reduce the amount of storage needed, but it saves time in terms of performing backups, says Doug Ward, director of e-business applications at Strada Software, a beta tester and an IBM ISV partner. Given the size of his company's data warehouse, which has data records going back to 1995, that's significant, Ward says.

By applying the compression, backups and recoveries can be performed much faster.

"We're still conducting a number of tests, but the early results are encouraging," Ward says.

Another key feature of Viper that IBM is talking up is its ability to manage both XML and relational data within the repository without requiring XML data to be reformatted. That, has implications both for storage as well as the ability to perform queries, Ward notes.

By not having to reformat the XML data to relational SQL, applications will require less use of storage capacity, Ward says. Also, developers who are more skilled in SQL programming can stick with that model in most cases, he adds.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
State of the Cloud
State of the Cloud
Cloud has drastically changed how IT organizations consume and deploy services in the digital age. This research report will delve into public, private and hybrid cloud adoption trends, with a special focus on infrastructure as a service and its role in the enterprise. Find out the challenges organizations are experiencing, and the technologies and strategies they are using to manage and mitigate those challenges today.
Commentary
Study Proposes 5 Primary Traits of Innovation Leaders
Joao-Pierre S. Ruth, Senior Writer,  11/8/2019
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
White Papers
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll