473,567 Members | 2,980 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2339
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
1362
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 dependencies. At the moment I am manually going through a swag of views and putting them in visio org chart but there must be a better way !
0
1111
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
316
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 integrates into DotNet yet has absolutely no COM in it, so I can deploy my app with just a file copy. I also need the report designer to be stand alone like Crystal, so designing reports does not have to...
2
1205
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, footers, table of contents, and page orientation All these functions must be accessed only via API so it will be completely automated by the program
6
3659
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 Access report writer capabilities. As far as development of reports, it is certainly fine in my book. But for end-users, with little experience or training, it would be nice to have an easy way...
1
1683
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 distribute my applications reports with. Does anyone know a good reporting tool for .NET? Crystal Reports is, of course, a good reporting tool, but i'm wondering if there are any others. Thanks...
2
1904
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 rips through an existing .XML file to grab the information needed and spits it out in a nicely formated html page that is easily read by anyone. This part works great, however I'm finding myself a...
0
2007
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 be chosen at runtime. The chosen fields are used to build a dynamic SQL query and the subsequent results will be used to fill the report for the chosen columns. The application being used in...
0
818
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 use it? Is it worth to purchase? Any comments on this product or good alternatives?
0
7590
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7905
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7960
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6272
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5488
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5216
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2093
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1205
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
930
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.