OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: Designing an XML-Database Application

[ Lists Home | Date Index | Thread Index ]
  • From: tpassin@home.com
  • To: xml-dev@lists.xml.org
  • Date: Tue, 01 Aug 2000 21:39:20 -0400

Raheja, Dhruv asked about storing and querying XML in databases -
> hello everybody,
>                        i have three q's on my mind....i was hoping someone
> will be able to help.
> 1.) Is there any advantage of storing data in XML format versus in a
> object-oriented database that is provided by PDM tools like e-Matrix? Also
> is there any advantage of first converting data into an XML format and
> storing it in such a database?
> 2.) I want to learn how to connect my XML documents with a database. I
> basically want to be able to store my XML data in a database. I then want
> be able to retrieve the data using a front-end that will query the
> and display the results using XML.

A lot depends on how much data you will be storing, what kind of queries you
want to do, how regular the structure of the XML documents is, how fast yu
need the responses, and how often (if at all) you need to do updates and

If you need to do complex joins, especially ones that were not contemplated
originally, there is still no equal to a relational database.  If the data
structure is very regular, it might easily lend itself to converting to a
RDBMS for storage.

If you don't need joins and your response time can be relatively long, you
might be able to use XSLT/XPath on native xml files.

If your documents have a loose and irregular structure, maybe Phillipe
Lambert's TextML solution would be best.

If you have no money, that makes a difference too!

There is no one answer.

Tom Passin


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS