Subject: Looking for an XML (database-based) Query Reporting
Tool/advice
First off, let me apologize if this thread is somewhat off topic...
PLEASE REPLY TO: xm*@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