[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Which one to choose
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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|