• To: xml-dev <xml-dev@l...>
• Subject: RE: hierarchical XML in a relational DB structure - moving nodes
• From: Tatu Saloranta <cowtowncoder@y...>
• Date: Fri, 26 May 2006 16:40:00 -0700 (PDT)
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ibrk3I4AeJmfQ1PMftZtuE8WPuWrt3eiM0I+uPMuuhsPwvrPZoBvLCbqEb9UzAbkXqNLBgJVx8b/+sdMKaXiE7G+QCA0kqqpuzhcMoxtj3+5m5U+wP6NRP/cQs3rYVyKRYRgp7XzuaFQ/8/41ar5FSbNNYyDWz161eZslGrsyBQ= ;
• In-reply-to: <07D2490E9E33124B8ED67F01E828B9E701341A6A@R...>

--- Michael Rys <mrys@m...> wrote:
...
> 2. Don't need frequent independent access at
> individual item level or
> order in the tree is important:
> 
> Use an XML datatype (like Oracle, SQL Server or
> other databases
> provide).

In this latter case, chances are that storing and
accessing them as LOBs is about as efficient as using
proprietary datatypes? Or are there special tricks db
drivers can do to compress data in flight or
something?
I have always wondered what are the benefits of XML
extensions for cases where the whole documents are
returned (as opposed to using XQuery etc. to do parts
of actual processing in the server side).

-+ Tatu +-



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

• References:
  • RE: hierarchical XML in a relational DB structure - moving nodes
    • From: "Michael Rys" <mrys@m...>

• Prev by Date: RE: hierarchical XML in a relational DB structure - moving nodes
• Next by Date: Re: UBL 2, W3C Schema extensibility, and multiple
• Previous by thread: RE: hierarchical XML in a relational DB structure - moving nodes
• Next by thread: RE: hierarchical XML in a relational DB structure - moving nodes
• Index(es):
  • Date
  • Thread