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

Re: XML and the Relational Model (was Re: A standard

• To: pop3 <lbradshaw@d...>,lbradshaw@d...,Mike Champion <mc@x...>,xml-dev@l...
• Subject: Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
• From: Jonathan Robie <jonathan.robie@d...>
• Date: Mon, 25 Aug 2003 15:58:14 -0400
• In-reply-to: <5.1.1.5.2.20030825142612.02ddb3c0@m...>
• References: <6.0.0.14.0.20030825130625.01d428d8@n...><5.1.1.5.2.20030825121731.02cda430@m...><20030825152941.39878.qmail@w...><5.1.1.5.2.20030822130933.00aa4950@m...>

At 02:30 PM 8/25/2003, pop3 wrote:
>I agree that mappings among models are useful.
>
>But I wish to note that the farther one gets away from the hardware the 
>less robust, slower and harder to optimize the resulting system becomes. 
>Specifically, if the application design for a terabyte system works out to 
>be a mapping between an rdbms and an XML tool like TeraText, and then a 
>separate, different mapping between the XML tool set back to a rdbms, then 
>my point is that the resulting system will have more failure points, be 
>harder to tune, and generally less robust than a "native" system.

You seem to like broad generalizations. Adding layers can improve 
performance - for instance, adding a cache or indexed access involves 
adding another layer of software, and either one does make the system more 
complex, but it also improves performance. Similarly, adding a query 
optimizer makes the system significantly more complex, but it does not 
really make it harder to use or hurt performance.

>Mappings, if you ask me, are bridges... like bridges they are an 
>infrastructure that is high maintenance and which require above normal 
>attention to support, and are subject to replacement periodically at high 
>costs.

For our SQL/XML product, we have found that using the SQL/XML extensions 
generally results in faster programs than building the XML "by hand" using 
the DOM. The reason for this has a lot to do with the structure of the 
mappings between XML and relational, and the number of database calls 
required by the approaches people generally use when solving this problem. 
Here's a paper that discusses this at a useful level of depth:

         SQL/XML in JDBC Applications
         http://www.datadirect-technologies.com/products/connectsqlxml/docs/sqlxml_whitep.pdf

I think this also applies to XQuery. It's pretty easy to imagine what it 
would look like to add a section on XQuery to the above paper.

Jonathan 

• Follow-Ups:
  • Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
    • From: pop3 <lbradshaw@d...>

• References:
  • Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
    • From: Jonathan Robie <jonathan.robie@d...>
  • Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
    • From: lbradshaw@d...
  • XML and the Relational Model (was Re: A standard approach to glueing together ...)
    • From: Mike Champion <mc@x...>
  • Re: A standard approach to glueing together reusableXML fragments in prose?
    • From: lbradshaw@d...
  • Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
    • From: pop3 <lbradshaw@d...>

• Prev by Date: RE: A standard approach to glueing together reusableXML fragments in prose?
• Next by Date: Re: XML and the Relational Model (was Re: Astandard approach to glueing together ...)
• Previous by thread: Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
• Next by thread: Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
• Index(es):
  • Date
  • Thread