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

RE: XML-enabled databases, XQuery APIs

  • To: <xml-dev@l...>
  • Subject: RE: XML-enabled databases, XQuery APIs
  • From: "scott wiseman" <scott@i...>
  • Date: Thu, 14 Apr 2005 21:05:00 -0700
  • Thread-index: AcVBVEY/Ol6//2lBT6mqYbt1sETKeAAIHKCA
  • Thread-topic: XML-enabled databases, XQuery APIs

RE:  XML-enabled databases


-----Original Message-----
From: David Lyon [mailto:david.lyon@c...] 
Sent: Friday, April 15, 2005 5:45 AM
To: xml-dev@l...
Subject: Re:  XML-enabled databases, XQuery APIs

On Thu, 14 Apr 2005 4:50 pm, Ken North wrote:
> in an article by Edd Dumbill. Edd quoted Ron Bourret as mentioning 
> "Oracle 9i release 2 was the first out with "native"
> XML support, but their "native" XML support means storing the XML in a

> CLOB column [snip]".

I am a big fan of doing that..

> That requires clarification because there are some persistent 
> misconceptions about XML and databases.
>
> From the time people first started talking about "native XML 
> databases", there's been a myth that SQL databases cannot store and 
> index XML documents in their native format.

For business XML data exchange, I think that it is the perfect
combination.

And for mass interoperability, I would advocate an ultra-simple SQL
database structure (like the one I posted about a month ago on xml-dev)
that can be setup to send/receive xml documents. It should be able to
exist on all database vendors databases (ie be non-exclusive) and be
based on two accounting tables; traders(companies) and trader_documents.

The problem with file based XML systems is that it is awful to manage. 
Databases are so much cleaner to maintain. If the documents are filed
nicely inside memo/xml fields, well I think how easy is that.

Just need to have some nice open source communications software to do
the (what can be surprisingly) quite tricky job of transferring the xml
documents.

> Developers wanted more, of course, such as being able to describe 
> document structure and shred documents (map document content to 
> columns). That's also been available for years with SQL platforms such

> as Microsoft SQL Server, Oracle, Sybase and DB2 (XML Extender).

Even now I think are happy to have more. Anything that they can show to
the Boss and get approval for spending (wasting) time looking into :-) 

Open source is great for that.. I've come to discover..
 
> Even more desirable is implementing XML as an SQL type. This provides 
> efficiencies for the SQL engine and query optimizer. Informix was the 
> first to demonstrate that at XML conferences in 1999. Those demos 
> showed the XML type gave significantly better performance than XML 
> stored in a CLOB column. (IBM acquired Informix in 2001).

That's interesting, true.



David

--
Computergrid : The ones with the most connections win.
<p><a href="http://www.avidware.net/">Spam Blocker</a></p>
<p>&nbsp;</p>
<p><a href="http://www.avidware.net/spam">Exchange Spam Filter</a></p>
<p>&nbsp;</p>
-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://www.oasis-open.org/mlmanage/index.php>


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.