472,353 Members | 999 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

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

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

Jul 20 '05 #1
2 2243
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
XML XQL".

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Uri Teitler | last post by:
Was wondering if anyone knew of a tool that you can point to a view in the database and it graphically (or even in text) determines the...
0
by: Zanna | last post by:
Hi, What do you think about my little reporting tool written in c# for .Net apps? -- Reporting tool: http://www.neodatatype.net
6
by: Bob | last post by:
I want to dump Crystal, one of the many reasons being that it requires a client-side installation. I'm looking for a reporting package that...
2
by: S Shulman | last post by:
Hi I am looking for a reporting tool that has much of the functionality offerd by Microsoft Word. The features I need is tables, headers,...
6
by: Bob Alston | last post by:
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the...
1
by: Mathieu [Marti-IT] | last post by:
Hi all, in creating a C# Windows Forms library to create professional applications with. In searching for a good reporting tool to create and...
2
by: rwboley | last post by:
I'm currently learning my way through Python and in the process developing a reporting tool for the company I'm working for. Basically the tool...
0
by: itsraghz | last post by:
Hello people, My present project need is to have an Open Source Java based reporting tool, which would allow the users to customize the fields to...
0
by: Kelly Swon | last post by:
Hello! Our company was looking for good reporting tool... and found It is here: http://www.perpetuumsoft.com I just want to know: Does anybody...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.