Project

Profile

Help

Forums » Help »

XQuery on data in DB instead of XML file

Added by Anonymous over 18 years ago

Legacy ID: #3429201 Legacy Poster: gsorak (gsorak)

Is it feasible (with limited effort) to perform XQuery searches using Saxon on data in DB (not native XQuery databases). I.e. is it possible to load rows from DB using XQuery/XPath searches with Saxon? - If yes, what needs to be done - If no, are there other open source XQuery projects more appropriate for this Thanks, Goran


Replies (3)

Please register to reply

RE: XQuery on data in DB instead of XML file - Added by Anonymous over 18 years ago

Legacy ID: #3429589 Legacy Poster: Michael Kay (mhkay)

There are two ways of interpreting your question: (a) data in an external relational database such as Oracle, or (b) data in a Saxon-specific persistent store (such as the PTree). In both cases the answer is no, but the alternative solutions vary between the two cases. I'm not aware of any open-source products that run XQuery against a relational database. It's reasonably easy however to issue SQL queries from Saxon (via JDBC) - this is available as an extension in Saxon's XSLT interface, which can also be invoked from XQuery via the saxon:transform() method. If you're looking to run Saxon against a purpose-built persistent store, check the status of the Momento project which is trying to do this. See http://www.xslt.com/html/xsl-list/2005-08/msg00582.html

RE: XQuery on data in DB instead of XML file - Added by Anonymous over 18 years ago

Legacy ID: #3632799 Legacy Poster: alylad (alylad)

Michael, Does Saxon-A support running XQuery against a relational database? I have looked at DataDirect but the licensing costs are certainly not minimal. Thanks

RE: XQuery on data in DB instead of XML file - Added by Anonymous over 18 years ago

Legacy ID: #3632825 Legacy Poster: Michael Kay (mhkay)

No, Saxon does not have the ability to run XQuery queries against a relational database.

    (1-3/3)

    Please register to reply