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

RE: storing xml files into database

• From: Haresh Gujarathi <gharesh@v...>
• To: Chuck White <chuck@t...>
• Date: Mon, 10 Sep 2001 18:26:22 +0530

-----Original Message-----
From: Chuck White [mailto:chuck@t...]
Sent: Sunday, September 09, 2001 10:28 PM
To: gharesh@v...
Subject: RE: storing xml files into database

Hi Haresh:

 

I'm responding to your inquiry off list because I don't think it's quite the forum for this.

 

You might want to look at the XML database from Ipedo (http://www.ipedo.com). I've talked to the CEO there and he is pretty convincing about it being considerably faster than Oracle for handling large XML docs. It also will have failover, concurrency and other rdms features you would expect to find in any modern rdms. It isn't cheap, you'll have to negotiate for a decent price on the licensing but i think you'll find them reasonable. I am sure they have a free download, too.

 

Alternatively, you can map sql tables to xml tables using XSQL in Oracle or XPath in SQLServer 2000. This mapping is laborious and labor intensive.

 

The cheapest solution is to store it as a blob in MySQL but if you have a lot of site traffic you're going to run into some problems, especially if you try to manipulate the XML document using the DOM. It all really depends on what you are trying to accomplish, does't it?

 

Chuck White
CEO
The Tumeric Partnership
Advertising for the Next Generation.
http://www.tumeric.net/
chuck@t...
________________________________________
Co-Author, Mastering XML, Premium Edition
Sybex Books, May, 2001                       
http://www.javertising.com/     

-----Original Message-----
From: Haresh Gujarathi [mailto:gharesh@v...]
Sent: Sunday, September 09, 2001 5:20 AM
To: Xml-Dev
Subject: storing xml files into database

I am developing an internet based application where the the data of the users of that application is stored in xml format.

I expect about 1000 to 20000 total users of the system (and say about 100 users simultaneously accessing the system)

 

Naturally there is inconvenience in storing the xmls on the file system. I want to explore storing these xmls in the database. I need some inputs as to how the xmls can be stored in the rdbms database. Please provide me any insight regarding this.

 

I am looking for 2 solutions ; a zero cost solution and reasonable cost solutions (may be involving the xml aware databases like Ixiasoft xml server)

 

1. In considering a database as storage mechanism, what advantages I would get

2. In such scenario what other people do?

3. If I want to store the xmls in say MySQL, how do I do it and does mysql have any special features?

4. What about MS-SQL server;

5. Should xmls be stored as blobs in the rdbms databases?

 

6. Optionally, I am also looking for 'search' ability where the database should be able to index the elements of xml file and perform search.

 

regards

Haresh Gujarathi

• Follow-Ups:
  • RE: storing xml files into database
    • From: Chris Parkerson <chrisp@e...>

• Prev by Date: Re: Bad News on IE6 XML Support
• Next by Date: RE: storing xml files into database
• Previous by thread: Re: XML Database Technologies (was Re: storing xml files into database)
• Next by thread: RE: storing xml files into database
• Index(es):
  • Date
  • Thread