Looking for an XML (database-based) Query Reporting Tool/advice

[Quoted] First off, let me apologize if this thread is somewhat off topic...

PLEASE REPLY TO: xml_at_solex-bi.com

I am looking for a way to query XML documents stored in an Oracle 9i database, contained in an unstructured CLOB column, much like one would with a traditional BI query reporting tool, but using XPath or XQuery query syntax..

Does anyone know of, or have any ideas/opinions on the following: 1. An XML Query Reporting Tool - are there any out there that you know of or can recommend?*
2. Does anyone know of any XML middleware that can translate an XML document to a traditional SQL query tool so that it thinks it's a relational structured object, and translate the SQL syntax to native XML query syntax?*
3. Is XQuery/XPath a plausible approach for ad-hoc queries against an Oracle database with 30+ million records (assuming appropriate XML Datatypes and indexes are used) or does this sound a bit absurd? I.e. would you just use a relational/SQL approach?

*Technical considerations.
· XML documents are to be stored in an Oracle CLOB column
(unstructured is preferred as it is currently setup for full-text searching), but can also be represented in structured object XML Type.
· Backend would be Oracle 9i or 10g with Oracle XML DB and support
for W3C XPath 1.0/ XPath 2.0/ XQuery 1.0.

Any thoughts, opinions and/or suggestions on the above are appreciated.

Thanks!

Alex Received on Tue Jun 21 2005 - 15:20:55 CEST