Software // Information Management
05:10 PM
Connect Directly
Risk Data as a Strategy
Apr 06, 2016
There is a renewed focus on risk data aggregation and reporting (RDAR) solutions, as financial ins ...Read More>>

Databases Get Better At Managing XML Data

The explosive growth of XML data on the Web has pushed large database vendors and standards organizations into action.

The Web supports a massive amount of content formatted in XML, the standard method for structuring online documents and data. Relational databases, however, have had a hard time handling XML documents, which are structured as a hierarchy--a set of nodes, stored in sequence--and don't fit the rows-and-columns tabular format used by those databases.

That's starting to change. Oracle 10g, Microsoft SQL Server 2005, and IBM's DB2 9.0, released last week, include XML handling capabilities, an important step in making XML queries easier. Database users can further benefit from XQuery, an XML data-access language and emerging standard.

Bilingual Databases

The updated SQL/XML standard will simplify:
Retrieval of XMLcontent from relational databases using SQL and XQuery
Storage of XMLdocuments in relational databases, by putting content into SQL-accessible tables
Publication of XMLdocuments built from results of both XQuery and SQL queries

These developments are important for businesses looking to include dissimilar types of information in a database. Beth Israel Deaconess Medical Center in Boston uses InterSystems' hybrid object/relational database system, Cache, for its CareWeb system used by doctors. Charts, images, subtle relationships between medicines, allergies, and reports on a patient's vital signs from operating room to recovery all can be represented in CareWeb, while older relational systems would be too slow to build screens of such dissimilar types of data. Growing support for XML in standard databases eventually may eliminate the need for a specialized one, says Robert Beckley, Beth Israel's director of information systems. The hospital already provides content to public health officials in XML. "Someday, all that CareWeb data could be XML," he says.

Get Smart
Some businesses have been storing XML data in the form of messages and documents in specialized XML systems, such as Software AG's Tamino and Ipedo's Ipedo XIP. These systems break content into a sequence of nodes that can be tagged, then invoked to retrieve either a single piece of data or an entire document.

Oracle, Microsoft, and IBM don't want to concede their data-storage dominance to interlopers such as Ipedo and Tamino. The big three's databases also support XQuery, which is approaching final approval by the World Wide Web Consortium. It defines a means of accessing XML data from different sources and building new documents from it.

Digital Steps, a developer of apps for the energy industry, can manage XML data using XQuery with Gamma, its system for tracking energy suppliers' assets and inventories. Digital Steps used to have to modify or rebuild parts of Gamma for different customers, leading to maintenance complexities. Thanks to Oracle 10g's support of XML, "we're much closer to having a single standard platform across our client base," says Peter Black, managing director of Digital Steps.

Meanwhile, the American National Standards Institute, the standards-keeper of the SQL query language used by relational databases, is working on a version of the SQL/XML standard that will support XQuery in the next version of SQL, due out in 2007. Some vendors' databases already support the SQL/XML standard.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
4 Trends Shaping Digital Transformation in Insurance
Insurers no longer have a choice about digital adoption if they want to remain relevant. A comprehensive enterprise-wide digital strategy is fundamental to doing business today.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of April 17, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week!
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.