There's been an interesting discussion currently taking place on the XML-DEV
list. I've inserted below some of the messages relating to XML vs Relational
dbms. This may help you.
Rachel
Dylan Walsh wrote:
>
> -----Original Message-----
> From: Soumitra Sengupta [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 6:02 PM
> To: Dream Catcher
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> 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
-----Original Message-----
From: Kim, Thomas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 1:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Aboout transform data to relational database
You might also consider an object database for an XML store.
www.exceloncorp.com
-----Original Message-----
From: Cho, Pyounguk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:26 PM
To: 'Towhid'; [EMAIL PROTECTED]
Subject: RE: Aboout transform data to relational database
Towhid,
Have you tried xml-dbms? This might be something you're looking for.
Check out http://www.rpbourret.com <http://www.rpbourret.com> for further
information.
Regards,
Pyounguk
-----Original Message-----
From: Towhid [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 10:05 AM
To: [EMAIL PROTECTED]
Subject: Aboout transform data to relational database
Hi,
I am working for trnsforming XML data to relational database. But there
is some difficulty. Here anyone who is working or know about the matter? May
any one give me some suggestion or resource?
-----------------------
Towhid
Computer Science & Engineering,
Bangladesh University of Engineering & Technology
(BUET)
------ XML/edi Group Discussion List ------
Homepage = http://www.XMLedi-Group.org
Unsubscribe = send email to: [EMAIL PROTECTED]
Leave the subject and body of the message blank
Questions/requests: [EMAIL PROTECTED]
To receive only one message per day (digest format)
send the following message to [EMAIL PROTECTED],
(leave the subject line blank)
digest xmledi-group your-email-address
To join the XML/edi Group complete the form located at:
http://www.xmledi-group.org/xmledigroup/mail1.htm
---------------------------------------------------------------------
Plan on attending the upcoming meeting during DISA's conference:
http://www.disa.org/conference/annual_conf/index.htm
------ XML/edi Group Discussion List ------
Homepage = http://www.XMLedi-Group.org
Unsubscribe = send email to: [EMAIL PROTECTED]
Leave the subject and body of the message blank
Questions/requests: [EMAIL PROTECTED]
To receive only one message per day (digest format)
send the following message to [EMAIL PROTECTED],
(leave the subject line blank)
digest xmledi-group your-email-address
To join the XML/edi Group complete the form located at:
http://www.xmledi-group.org/xmledigroup/mail1.htm
---------------------------------------------------------------------
Plan on attending the upcoming meeting during DISA's conference:
http://www.disa.org/conference/annual_conf/index.htm
------ XML/edi Group Discussion List ------
Homepage = http://www.XMLedi-Group.org
Unsubscribe = send email to: [EMAIL PROTECTED]
Leave the subject and body of the message blank
Questions/requests: [EMAIL PROTECTED]
To receive only one message per day (digest format)
send the following message to [EMAIL PROTECTED],
(leave the subject line blank)
digest xmledi-group your-email-address
To join the XML/edi Group complete the form located at:
http://www.xmledi-group.org/xmledigroup/mail1.htm
---------------------------------------------------------------------
Plan on attending the upcoming meeting during DISA's conference:
http://www.disa.org/conference/annual_conf/index.htm
------ XML/edi Group Discussion List ------
Homepage = http://www.XMLedi-Group.org
Unsubscribe = send email to: [EMAIL PROTECTED]
Leave the subject and body of the message blank
Questions/requests: [EMAIL PROTECTED]
To receive only one message per day (digest format)
send the following message to [EMAIL PROTECTED],
(leave the subject line blank)
digest xmledi-group your-email-address
To join the XML/edi Group complete the form located at:
http://www.xmledi-group.org/xmledigroup/mail1.htm
---------------------------------------------------------------------
Plan on attending the upcoming meeting during DISA's conference:
http://www.disa.org/conference/annual_conf/index.htm
