IBM to Add Native XML Storage Support to DB2
Says upgraded database will handleboth unstructured and relational data
Computerworld - IBM last week released the initial open beta of a planned update to its flagship DB2 database that will offer users the ability to natively store unstructured XML data separately from conventional relational data.
The upgrade, code-named Viper, is scheduled to be released in the middle of next year, according to Bernie Spang, director of database marketing at IBM. Spang said that Viper will be able to store data such as multimedia files, Excel spreadsheets and Word documents in an XML repository, which will operate in parallel with IBM's relational data repository under the control of a single DB2 engine.
Typically, relational databases handle XML data either by storing the entire file as an object that isn't relationally indexed, or by "shredding" the file so the unstructured information fits into multiple relational data cells.
"Offering native XML functionality is very essential to delivering improved performance for data access," said Noel Yuhanna, an analyst at Forrester Research Inc. Oracle Corp. had "a head start on XML for many years," he added. "I expect this to become a game of catch-up and leapfrog among the big vendors."
Viper's XML storage capabilities could be of use to CheckFree Corp. in light of its interest in service-oriented architectures (SOA) and Web services, said Robert Catterall, director of engineering at the Norcross, Ga.-based provider of online bill-payment services.
CheckFree uses DB2 to run databases with multiple terabytes or more of information. "We are not today storing XML documents as such in our databases," Catterall said. "But that has partly been because there wasn't an appealing way to do that in a single database."
Oracle officials said the company began offering XML storage options five years ago and in July enabled users of its 10g database to natively search XML files using the XQuery markup language. IBM's native XML storage feature "doesn't add any value," said Mark Drake, an XML technology manager at Oracle.
Viper will also support XQuery for processing XML data, along with standard SQL. In addition, it will be the first DB2 release to support three different partitioning methods: range partitioning, multidimensional clustering and hashing. That support is aimed at helping IBM compete against Oracle, which has said that 10g offers six methods of partitioning data tables for faster access to information.
Despite estimates that the amount of unstructured or XML-formatted data at most companies is already larger and growing faster than structured relational data is, Yuhanna said he doesn't think that XML will replace SQL as the preferred data format.
IBM said the next version of DB2 will include the following:
An XML data repository for native storage of unstructured data
Support for the XQuery markup language and PHP scripting language
Range partitioning capabilities, for enabling faster access to data
Read more about Databases in Computerworld's Databases Topic Center.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- SIEM: Keeping Pace with Big Security Data Learn how SIEM can have the right database back-end and offer security intelligence that leverages contextual data to achieve a strong security posture...
- Pay-as-you-Grow Data Protection: IBM Tivoli's Full-featured Data Protection Suite for Small to Medium Businesses IBM Tivoli Storage Manager Suite for Unified Recovery gives small and medium businesses the opportunity to start out with only the individual solutions...
- Streamline Data Protection with IBM Tivoli Storage Manager Operations Center IBM Tivoli Storage Manager (TSM) has been an industry-standard data protection solution for two decades. But, where most competitors focus exclusively on Backup...
- Live Webcast Best Practices for the Hyperconverged Enterprise Network To the Age of Constant Connectivity and Information overload
- Live Webcast On-demand webinar: "Mobility Mayhem: Balancing BYOD with Enterprise Security" Check out this on-demand webinar to hear Sophos senior security expert John Shier deep dive into how BYOD impacts your enterprise security strategy...
- Live Webcast Endpoint Backup & Restore: Protect Everyone, Everywhere Arek Sokol from the bleeding-edge IT team at Genentech/Roche explains how he leverages cross-platform enterprise endpoint backup in the public cloud as part...
- Meg Whitman presents Unlocking IT with Big Data During this Web Event you will hear Meg Whitman, President and CEO, HP discuss HAVEn - the #1 Big Data platform, as well...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,...