Re: storing xml files into database

[Kimbro Staken <kstaken@dbxmlgroup.com>]

Definitely take a look at dbXML it is about the closest you'll find to 
fulfilling your requirements, especially given your price constraints (i.e.
  free). http://www.dbxml.org The only thing it is missing is full text 
query but if you really need that then contact me and we might be able to 
figure it out. A new beta will be available this week.

Kimbro Staken
The dbXML Group L.L.C. - http://www.dbxmlgroup.com/
Embedded XML Database Software and Services

On Monday, September 10, 2001, at 05:56 AM, Haresh Gujarathi wrote:

> Hi Soumitra,
>  
> thx for ur reply.
>  
>  
> Why file system seems to be inconvenient for me?
> 1. I already have some data in the RDBMS database. So I have to manage 
> (backup, maintain etc) 2 things the rdbms data and the xml files on the 
> local file system.
> I would like to store everything in one type of storate system.
>  
> (well I can get rid of the rdbms by keeping this data again in xml files)
>  
> 2. If I store the xml files in database, security of the data can be 
> manages in much better fashion
>  
> 3. This is what I assume ==> If I store the xmls in xml aware database 
> system,
> -- creating DOM from the blob
> -- performing queries
> -- performing XSLT , XPath might be much efficient
> -- besides I will need indexing and searching capabilities
>  
>  
> Basically this is my requirement;
> I have built an internet based application; where new users come in; 
> create account; a new xml file is created for each of the new user.
> His personal information (name, email address, etc, his profession 
> related data) will be stored in the xml file. (This data is highly 
> structured and hierarchical)
> I expect the size of each xml to be 10k to 30k.
>  
> The same user can come into the system again to modify and update his 
> information; that time the application builds DOM and keeps the DOM in 
> the memory till the user logs out.
>  
> Other users can come into the system and can view the data of other users.
>  There maintainance of DOM is not required but lot of XSLT and XPath 
> queries will be performed. This is where I need to achieve better 
> efficiency (I have not yet got any answers to it)
>  
> I want to to perform the XSLT and XPath as efficiently as possible.
>  
> Search capabilities;
> 1. indexing on the elements and attributes of the elements
> I should be able to specify in the configuration what elements and 
> attributes should be indexed;
>  
> 2. full text indexing
>  
> Now there are few responses to this thread which suggest to use eXcelon 
> and Ipedo. I will start evaluating them. But I wonder if I can use them.
>  
> Mine is not an enterprise application; I plan to price tag this 
> application at about US$ 2,000-4000. And using these specialized xml db 
> servers would be commercially unviable. That is why I am looking for a no 
> cost solution. However I am definitely looking for prospects where a high 
> performance is required for the custiomers of my product. There I can 
> provide a customized solution.
>  
> Hope this gives more Idea as to what am I upto.
>  
> regards
> Haresh
>  
>
> -----Original Message-----
> From: Soumitra Sengupta, Ph.D. [mailto:soumitra@b-bop.com]
> Sent: Sunday, September 09, 2001 10:32 PM
> To: gharesh@vsnl.com
> Cc: Xml-Dev
> Subject: Re: storing xml files into database
>
>
>
> Haresh Gujarathi wrote:
>
> Naturally there is  inconvenience in storing the xmls on the file system.
>   
>
> Could you explain your requirements a bit more.  Why is it that you find 
> the filesystem inconvenient?
>
>  
> I am looking for 2 solutions ; a zero cost solution
>
> If  you go back and check the archives of this list, you will find 
> announcements for couple of open source initiatves.
>
> and reasonable cost solutions (may be involving the xml aware databases 
> like Ixiasoft xml server)
>
> Take a look at our Xfinity Server.  It is a reasonable cost solution and 
> is fully XML aware.
> http://www.b-bop.com/products_xfinity_server.htm
>
>  
> 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?
>
> Xfinity is tested on MySQL on Linux.
>
> 4. What about MS-SQL  server;
>
> Xfinity supports MS-SQL Server 7.0 and 2000.
>
> 5. Should xmls be stored as blobs in the rdbms databases?
>  
>
> Depends on whether you need granular access to your XML documents or not.
>   Also what kind of search capabilities you need and what performance 
> requirements you have.
>
> 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.
>  
>
> A better explanation of your requirements would help but Xfinity supports 
> "all of the reqs" you mention here out of the box.
>
> regards
> Haresh Gujarathi
>
>