[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML-enabled databases, XQuery APIs

• Subject: Re: XML-enabled databases, XQuery APIs
• From: Ronald Bourret <rpbourret@r...>
• Date: Fri, 15 Apr 2005 11:49:02 -0700
• Cc: xml-dev@l...
• In-reply-to: <15725CF6AFE2F34DB8A5B4770B7334EE07206E3B@h...>
• References: <15725CF6AFE2F34DB8A5B4770B7334EE07206E3B@h...>
• User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)

It's a bit hard to get used to the idea, but an "XML type" is a first 
class data type whose disk storage is optimized for XML.

By analogy, think about how other data types are stored. A two byte 
integer data type is stored in two bytes where each bit is treated as a 
digit in a binary number. A ten-byte ASCII character data type is stored 
as ten bytes where each byte is treated as an integer representing an 
ASCII character. And an XML data type is stored (insert leap of faith 
here) in a structure designed to hold an XML document.

What's weird about this is that we're used to thinking of relational 
data types as scalar types, whereas the XML data type has much more 
structure. However, this isn't much different than in object-relational 
databases where a column can have an object data type, although that is 
presumably mapped to a set of scalar storage locations under the covers.

How the XML data type is actually stored depends on the database. For 
example, Oracle stores complete XML documents in CLOBs and indexes the 
heck out of them. SQL Server stores documents using a proprietary binary 
format in BLOBs, as well as storing them in a node table with columns 
like node ID, node name, node type, parent ID, and node value. DB2 
stores documents using a proprietary disk format that is designed for 
node-level addressability and is separate from their relational storage.

Another way to think about all of this is that the XML data type is the 
exposed tip of a native XML database embedded inside a relational database.

Clear as mud?

-- Ron

Bullard, Claude L (Len) wrote:

> I don't understand this nearly well enough.   In a 
> relational database, what are the characteristics 
> of an "XML type"?

• Follow-Ups:
  • Re: XML-enabled databases, XQuery APIs
    • From: Robert Koberg <rob@k...>

• References:
  • RE: XML-enabled databases, XQuery APIs
    • From: "Bullard, Claude L (Len)" <len.bullard@i...>

• Prev by Date: Re: XML-enabled databases, XQuery APIs
• Next by Date: Re: XML-enabled databases, XQuery APIs
• Previous by thread: RE: XML-enabled databases, XQuery APIs
• Next by thread: Re: XML-enabled databases, XQuery APIs
• Index(es):
  • Date
  • Thread