Does Oracle have an XSLt engine embedded in the database
engine itself? When it comes down to it, that's the tool
I'm really looking for... :-)
I know postgres allows you to store/query XML data *within*
a data field in the database... but I'm looking to actually
treat the database itself like an XML document.... and have
the stylesheet evaluate xpath expressions inside the database
engine, thereby avoiding having to copy data out of the
database and then throw 99.9% of it away before the presentation
layer.
I've really done a lot of looking around for this kind of
solution before... posting here is just kind of a last-gasp
attempt on my part.... I'm designing a rewrite of a decent
sized software project, and if something like this exists,
I want to use it.. :-)
DB2 with the XML extender (std with V8 but available with V7) does this
also.
You can have XML column types that embed an entire XML document in it, or
call a stored proc to shred XML into regular/normal columns or call a
stored proc to execute a query and have XML returned.
If you look under the covers, it is using Xalan/Xerces (in C++). I've only
just started playing with it, so I can not comment on exactly how fast it
is.
I am looking at combining it with the MQ listener to have an XML based
message placed on an MQ queue and have DB2 automatically pull it off the
queue and insert it into a normal table ('though could put the XML msg
itself into an XML column).
-Chris
***********************************************************************************
This email contains information confidential to AAMI Limited. If you are not
the intended recipient, you must not disclose or use the information in it. If
you have received this email in error, please notify us immediately by return
email, and delete this email and any attached documents.
AAMI Limited is not responsible for any changes made to a document other than
those made by AAMI Limited or for the effect of the changes on the document
meaning.
***********************************************************************************
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--