Software // Information Management
News
7/27/2006
05:10 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

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
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
InformationWeek Tech Digest - July 22, 2014
Sophisticated attacks demand real-time risk management and continuous monitoring. Here's how federal agencies are meeting that challenge.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
A UBM Tech Radio episode on the changing economics of Flash storage used in data tiering -- sponsored by Dell.
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.