Re: Which one to choose

["Soumitra Sengupta, Ph.D." <soumitra@xxxxxxxxx>]

One of the problems of chunking rich XML content and storing it in
relational database is designing an appropriate schema for each DTD.  In
addition if you try to store arbitrary well formed XML documents, the
problem becomes even harder.  So it is a matter of trade-off.  

We have developed a solution that runs on top of any RDMS that allows
you to store, index and retrieve entire collection or a collection of
fragments of arbitrary XML documents quite efficiently.  We are in the
middle of testing it against hand optimized test sets in relational
schemas to benchmark the performance.  Will be happy to discuss the pros
and cons.

With best regards,

Soumitra

Ben Robb wrote:
> 
> SQL 7 also has an XML plug-in which allows you to store SQL queries in XML
> format and automatically output the results of that query in a well formed
> XML. It is said to be much faster than ASP + COM, and seems to be fairly
> stable when we've used it.
> 
> On another note, I would migrate from Access anyway - SQL 7 is much more
> friendly to rapid application development than its predecessors, so you
> might as well use the more powerful and faster SQL (or Oracle) server
> (assuming you can afford the license, of course *grin*)
> 
> > -----Original Message-----
> > From: Steve Muench [mailto:smuench@xxxxxxxxxxxxx]
> > Sent: 16 February 2000 06:43
> > To: xsl-list@xxxxxxxxxxxxxxxx
> > Subject: Re: Which one to choose
> >
> >
> > Ural,
> >
> > Portal sites typically strive for a personalized
> > experience. Personalization involves tracking lots
> > of information about each user, their interests,
> > their preferences, their screen layouts, etc.
> > Serving personalized content involved querying
> > your content repository to match various per-user
> > preferences/interests against your smorgasbord
> > of articles, stories, streaming video/audio, etc.
> >
> > Having all your content removed from a database
> > and stored physically as XML files, you'll lose
> > the lightning-fast query times that enterprise
> > relational databases can give the portal. The
> > strategy most are going for is dynamically
> > serving "slices" of data from (sometimes fairly
> > hairy and finely-performance-tuned) SQL queries
> > as dynamic XML content for XSLT-transforming
> > it into:
> >
> >  -> industry-standard DTD's for data exchange
> >  -> beautiful web pages
> >
> > Leading databases make this easy to do, to get
> > the full performance, reliability, and
> > maintainability benefits of existing relational
> > technology with the key benefits of XML.
> >
> > You might check out Oracle's free "XSQL Pages"
> > technology and the accompanying XSQL Servlet that
> > makes doing this *really* easy with your favorite
> > relational database (including ACCESS, if you use
> > the JDBC/ODBC driver) and your favorite servlet
> > engine -- not only Oracle.
> >
> http://technet.oracle.com/tech/xml/xsql_servlet
> 
> __________________________________________________________
> Steve Muench, Lead XML Evangelist / Consulting Product Mgr
> Oracle Corp, Business Components for Java Development Team
> http://technet.oracle.com/tech/xml
> ----- Original Message -----
> From: "ural" <ural@xxxxxxxx>
> To: <xsl-list@xxxxxxxxxxxxxxxx>
> Sent: Wednesday, February 16, 2000 2:59 AM
> Subject: Which one to choose
> 
> | hi,,
> | I am into a project where we have lot of content. In fact it is a portal
> | site. a IT related news tutorials etc are there.
> | So far we were using ASP and MS ACCESS for our contents. ie, we were
> | storing all the file in our database. and depending on user request we are
> 
> | displaying to them. If we convert them into XML, then do you think it will
> 
> | be a good move or not. We have around 1500 articles in our site. I want to
> 
> | know wheter XML is a right technology for large amount of content or not?
> | If it is not then please suggest any other technology.
> |
> | rgds
> | Ural
> |
> |
> |  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> |
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

begin:vcard 
n:Sengupta, Ph.D.;Soumitra
tel;cell:914-672-8730
tel;fax:203-975-9671
tel;work:203-975-9651
x-mozilla-html:FALSE
org:B-Bop Associates Inc. (http://www.b-bop.com)
version:2.1
email;internet:soumitra@xxxxxxxxx
title:Founder & C.T.O.
adr;quoted-printable:;;2, North First Street=0D=0A4th Floor=0D=0A;San Jose;CA;95141;U.S.A.
x-mozilla-cpt:;-20640
fn:Soumitra Sengupta, Ph.D.
end:vcard