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

Re: XML versus Relational Database

  • From: Kimbro Staken <kstaken@d...>
  • To: Dylan Walsh <Dylan.Walsh@K...>
  • Date: Fri, 02 Feb 2001 10:44:00 -0700

rdbms versus xml searches
Dylan Walsh wrote:
> 
> -----Original Message-----
> From:   Soumitra Sengupta [SMTP:soumitra@b...]
> Sent:   Thursday, February 01, 2001 6:02 PM
> To:     Dream Catcher
> Cc:     xml-dev@l...; xmlschema-dev@w...
> Subject:        Re: XML versus Relational Database
> 
> >If you have a few documents and do not need to search across them, a
> >persistent DOM implementation will work
> 
> If you do not need to search across the document, why use a persitent DOM
> implementation?
> Why not store the XML as file or as text in the database?

I believe this was referring to searching across a collection of
documents rather then within a single document. If you do not need to
search across multiple documents then a persistent DOM will work well
for storing a pre-parsed representation of the document.  For handling
multiple documents and querying across them you need to move into an XML
database. By XML database I'm referring to all types as listed here
http://www.xmldb.org/faqs.html 

Storing XML in a file or in a text blob in a RDBMS works fine as long as
you always treat the XML as one atomic unit and can handle the hit of
parsing the document each time it is retrieved from storage. If your XML
is static this works fine but if the application is changing the XML
then a more robust mechanism might be in order.

-- 
Kimbro Staken
Chief Technology Officer
dbXML Group L.L.C
http://www.dbxmlgroup.com

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.