[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML to Database Inserts via XSLT

Subject: Re: XML to Database Inserts via XSLT
From: Brian Chrisman <incubus@xxxxxxxxxxxxxx>
Date: Wed, 9 Mar 2005 23:40:18 -0800
Re:  XML to Database Inserts via XSLT
> This is akin to what some of the XQuery/relational vendors are doing: except
> that they push as much of the query to the database as possible, to make
> maximum use of indexes. 
> In principle you could implement the XPath data model directly as a view of
> the database, but relational databases are much happier doing a small number
> of large queries rather than millions of small ones. (If only we still had
> Codasyl databases...) Saxon's NodeInfo interface is actually slightly higher
> level than the XPath data model as described in the specs (because it
> supports navigation using the XPath axes) but a direct mapping of this
> interface onto SQL would still be a rather significant challenge, and
> wouldn't give as good performance as systems that translate whole FLWR
> expressions into SQL.

My first instinct was having the xpath processor calling
methods internal to the database (whatever the database uses to
lookup its data after parsing SQL).. seemed like trouble to
marshal the query into SQL only to have it reparsed by the
database engine.. but I guess that shouldn't involve too much
overhead anyways... not to mention being able to use it with
different databases.... certainly performance would be an
issue regardless...
I hadn't looked at Xquery and FLWR expressions... or the
efforts at pushing those queries into the database... thanks
for the tip...  am reading up on them and the sql extension 
Maybe they'll get me closer to my 'holy grail'. :-)


> Michael Kay
> http://www.saxonica.com/

Current Thread


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.