From: Chuck White [mailto:firstname.lastname@example.org]
Sent: Sunday, September 09, 2001 10:28 PM
Subject: RE: storing xml files into databaseHi 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?
The Tumeric Partnership
Advertising for the Next Generation.
Co-Author, Mastering XML, Premium Edition
Sybex Books, May, 2001
From: Haresh Gujarathi [mailto:email@example.com]
Sent: Sunday, September 09, 2001 5:20 AM
Subject: storing xml files into databaseI 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 get2. 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.regardsHaresh Gujarathi