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

Re: XML and the Relational Model [long]

• To: xml-dev@l...
• Subject: Re: XML and the Relational Model [long]
• From: Mike Champion <mc@x...>
• Date: Wed, 27 Aug 2003 17:46:40 -0700 (PDT)
• In-reply-to: <006701c36cfd$8c9e5be0$6501a8c0@tbp1>

--- "Thomas B. Passin" <tpassin@c...> wrote:

> On the other hand, if you create a well-normalized
> data model to begin
> with - when that is practical - you could probably
> implement it either with
> xml or with a relational database.  What are the
> differentiators between
> going one way or the other?

All other things being equal, I'd guess that the XML
approach would be faster and more convenient in
read-only (or heavily weighted toward reading)
applications because you wouldn't have to join the
data back together from multiple tables to recover a
"document." [The old "take the car apart at night and
reassemble it in the morning" analogy that OODBMS and
XMLDBMS advocates like to use and RDBMS advocates just
hate :-) ] But the more updates of existing data,
especially by concurrent applications, the more the
RDBMS approach is likely to be better or even
necessary.  XML's lack of a coherent referential
integrity story can bite hard in such situations.

• Follow-Ups:
  • Re: XML and the Relational Model [long]
    • From: "Thomas B. Passin" <tpassin@c...>

• References:
  • Re: XML and the Relational Model [long]
    • From: "Thomas B. Passin" <tpassin@c...>

• Prev by Date: Re: XML and the Relational Model (was Re: A standard approach to glueing together ...)
• Next by Date: Re: XML and the Relational Model [long]
• Previous by thread: Re: XML and the Relational Model [long]
• Next by thread: Re: XML and the Relational Model [long]
• Index(es):
  • Date
  • Thread