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

Re: ID/IDREF is evil

• From: Michael Kay <mike@saxonica.com>
• To: Kurt Cagle <kurt.cagle@gmail.com>
• Date: Thu, 20 Feb 2014 10:30:59 +0000

On 19 Feb 2014, at 22:45, Kurt Cagle <kurt.cagle@gmail.com> wrote:

> Actually, this brings up something I've been thinking about for a while. It is typical to think of an XML document as being a self-contained entity

I think this is one of the big problems with the use of XML as a database model.

Sometimes the concept of a "document" makes sense, it relates to something in the real world, like an insurance claim. Sometimes it makes no sense at all, e.g. when you're modelling the human genome. Ideally, the choice of document boundaries shouldn't make much difference; queries should work the same way regardless of where the document boundaries are. In practice, that's very hard to achieve, and one of the reasons is that intra-document linking is so very different from cross-document linking. There are actually three basic ways of modelling relationship in XML: use of the XML containment hierarchy, use of intra-document links, and use of cross-document links; and the way you write queries is totally dependent on which representation has been chosen. That violates the basic principles of data independence (which was the topic of my PhD thesis in 1975...)

I wouldn't normally recommend using an XML database unless it is natural to think about the data as being a set of documents.

Michael Kay
Saxonica

• Follow-Ups:
  • Re: ID/IDREF is evil
    • From: Kurt Cagle <kurt.cagle@gmail.com>
  • Re: ID/IDREF is evil
    • From: Hans-Juergen Rennau <hrennau@yahoo.de>

• References:
  • ID/IDREF is evil
    • From: "Costello, Roger L." <costello@mitre.org>
  • Re: ID/IDREF is evil
    • From: Michael Kay <mike@saxonica.com>
  • Re: ID/IDREF is evil
    • From: Arjun Ray <arjun.ray@verizon.net>
  • Re: ID/IDREF is evil
    • From: Kurt Cagle <kurt.cagle@gmail.com>
  • Re: ID/IDREF is evil
    • From: Arjun Ray <arjun.ray@verizon.net>
  • Re: ID/IDREF is evil
    • From: Kurt Cagle <kurt.cagle@gmail.com>
  • Re: ID/IDREF is evil
    • From: Kurt Cagle <kurt.cagle@gmail.com>