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

Re: XML-enabled databases, XQuery APIs

• To: David Lyon <david.lyon@c...>
• Subject: Re: XML-enabled databases, XQuery APIs
• From: Robert Koberg <rob@k...>
• Date: Fri, 15 Apr 2005 20:21:26 -0700
• Cc: xml-dev@l...
• In-reply-to: <200504160858.48498.david.lyon@c...>
• References: <15725CF6AFE2F34DB8A5B4770B7334EE07206E3B@h...> <200504160858.48498.david.lyon@c...>
• User-agent: Mozilla Thunderbird 1.0 (Macintosh/20041206)

David Lyon wrote:
> On Fri, 15 Apr 2005 12:15 pm, 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"?
> 
> 
> Don't you mean "XML Document Type"? If so that is the
> equivilent to the <?DOCTYPE Invoice> tag.

hmmm..

> 
> Except that when you store the document in the database
> you rip out the doctype, and store it in one of the header
> fields.
> 
> So that you can query saying something like:
> 
>  select 
>   *
>  from 
>  trader_documents 
>  where 
>  (document_type="Invoice")
> 
> Makes it more convenient and organised that way.

Or using a filesystem (XSL 1.0):

<xsl:apply-templates
   select="document(concat($path-to, $identifier))"/>

Is the problem that filesystems are not good enough yet? (I don't have a 
problem with win or linux, but I am not huge)

Do people really feel a file based system is more difficult to manage 
(what with versioning - CVS/SVN, and checkout.., stage versions for 
dev/qa/cert/live.., wherever/whatever) than a relational database hacked 
to accomodate (roundtrip) XML?

-Rob

• Follow-Ups:
  • Re: XML-enabled databases, XQuery APIs
    • From: David Lyon <david.lyon@c...>
  • Re: XML-enabled databases, XQuery APIs
    • From: "Ken North" <kennorth@s...>

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

• Prev by Date: xml schema best practices question.. one big xml or lots of littlecomponents?
• 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