470,614 Members | 1,627 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

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

Subject: Looking for an XML (database-based) Query Reporting

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.



Jul 20 '05 #1
2 2185
I recall that Oracle 9i provides much of what you want out of the box.
(That's why you would have upgraded from 8i.) Look on ebay for
one of those Oracle/XML books published by Osborne on the cheap
or try posting to comp.databases.oracle or googling "Oracle

Jul 20 '05 #2
Sorry, but I don't think you quite got the gist of the post ... I am
looking for a 3rd party front end tool, much like that of a traditional
ad-hoc query tool like Crystal/Impromptu BUT with the ability to query
an unstructured non-relational source (XML document) using native XML
query languages ... we are not interested in developing our own.

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Zanna | last post: by
2 posts views Thread by S Shulman | last post: by
6 posts views Thread by Bob Alston | last post: by
1 post views Thread by Mathieu [Marti-IT] | last post: by
2 posts views Thread by rwboley | last post: by
reply views Thread by Kelly Swon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.