RE: storing xml files into database

["Sterin, Ilya" <Isterin@ciber.com>]

Thanks, good link.  I just started reading and already answered a few
questions from my previous post:-)

I don't see why xml-dev is not the forum for this.  I might get flamed, and
I mean **flamed** for this, but I would rather see discussions like this,
than English majors on this list having a spelling bee contest.
I've never seen one of those post quoted OT.

Ilya

-----Original Message-----
From: Chuck White
To: gharesh@vsnl.com
Cc: Xml-Dev
Sent: 9/10/01 8:19 AM
Subject: RE: storing xml files into database

I am still not convinced the xml-dev list is the forum for this, but for
an excellent overview of DBs and their relationship to XML, I'd go here:

http://www.rpbourret.com/xml/XMLDatabaseProds.htm

regards,

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: Monday, September 10, 2001 5:56 AM
To: Chuck White
Cc: Xml-Dev
Subject: RE: storing xml files into database


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

-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this elist use the subscription
manager: <http://lists.xml.org/ob/adm.pl>