[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Generating reports for XML-based tables

• From: Ronald Bourret <rpbourret@r...>
• To: xml-dev@l..., jnbello@p...
• Date: Fri, 19 Oct 2001 23:58:00 -0700

Jorge Bello wrote:

> The company I work for, have a bunch of information in an old platform
> (Oracle 7/NCR 3450) which in turn is going to be discarded.
> We want to preserve this information using a XML file for every table
> (this seems to be an easy step).

It is the easy step.

> We want to preserve some SQL-based reports (with select statements
> using "wheres" and "joins").
> 
> I'm convinced that is unavoidable to rewrite these reports and I´m trying
> to figure out what is the better way.

Do you mean that you still want the reports to work over the new XML
documents? I also think you will have to rewrite the reports.
Furthermore, you're going to need a query language/processor that can do
joins across XML documents. I think your choices are:

1) Rewrite the queries using an XML query language that supports
cross-document queries and then write a query processor for that
language.

2) Rewrite the queries using an XML query language that supports
cross-document queries and then find an existing query processor to run
the queries.

3) Put the data into another relational database and forget about XML
altogether.

Personally, I think (3) is the best option. And if the data is static
(which I assume it would be), you could use MySQL, which is very fast
but (I'm pretty sure) doesn't support transactions. Since it's free,
your only expense would be buying a new PC to run it on.

-- Ron

• References:
  • Generating reports for XML-based tables
    • From: Jorge Bello <jnbello@p...>

• Prev by Date: Re: XML Database Decision Tree?
• Next by Date: Re: XML Database Decision Tree?
• Previous by thread: Generating reports for XML-based tables
• Next by thread: Re: Generating reports for XML-based tables
• Index(es):
  • Date
  • Thread