RE: storing xml files into database

[Haresh Gujarathi <gharesh@vsnl.com>]

Hi Chuck,

 

thx for ur reply.

 

I have already looked into the mapping tables mechanism. That is too painful and will not work for me.

 

Now this question keeps coming into my mind; (if you read all the messages in this thread) There are companies like excelon, Ipedo, Software Ag(tamino), IXIASFOT which offer a native xml server (where xml is stored in native format as against tabular format in typical RDBMSs)

I wonder what does it take to MS-SQL server, oracle, db2 guys to do just the same.  Is that too difficult? 

 

What would it take to them to do what tamino, ipedo, excelon does?

 

regards

haresh

 

-----Original Message-----
From: Chuck White [mailto:chuck@tumeric.net]
Sent: Sunday, September 09, 2001 10:28 PM
To: gharesh@vsnl.com
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 (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@tumeric.net
________________________________________
Co-Author, Mastering XML, Premium Edition
Sybex Books, May, 2001                       
http://www.javertising.com     

-----Original Message-----
From: Haresh Gujarathi [mailto:gharesh@vsnl.com]
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