[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: Sat, 20 Oct 2001 17:12:27 -0700

Jonathan Robie wrote:
> >3) Put the data into another relational database and forget about XML
> >altogether.
> >
> >Personally, I think (3) is the best option.
> 
> Please compare the queries in the XQuery document to the equivalents in SQL
> before you conclude that ;->

Actually, this conclusion isn't based on the question of which query
language is better or easier to use. It's based on what the simplest and
cheapest solution is. The original problem was how to keep functioning
data and reports alive when the underlying database went away.

Solution (3) could mean as little work as downloading MySQL (free),
writing a simple ODBC application to transfer the data, and testing. In
reality, it probably won't be that easy, but it probably will be easier
than learning a new query language and database, rewriting all the
queries, and finding the money to pay for a new database that obviously
isn't in great demand.

-- Ron

• References:
  • Generating reports for XML-based tables
    • From: Jorge Bello <jnbello@p...>
  • Re: Generating reports for XML-based tables
    • From: Jonathan Robie <jonathan.robie@s...>

• Prev by Date: Re: Perl XML::Parser and nested external entity references
• Next by Date: HELP! I need a straight answer about Xschemas IE6 and msxml4
• Previous by thread: Re: Generating reports for XML-based tables
• Next by thread: XML pretty printer?
• Index(es):
  • Date
  • Thread