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

RE: A standard approach to glueing together reusableXMLfragmen

• To: <rjm@z...>
• Subject: RE: A standard approach to glueing together reusableXMLfragments in prose?
• From: "Chris Angus" <chris.angus@b...>
• Date: Tue, 26 Aug 2003 18:13:19 +0100
• Cc: <michael.h.kay@n...>,<xml-dev@l...>
• Importance: Normal
• In-reply-to: <1061911935.3923.63.camel@z...>

Rick

But the primary key in such a case is the one thing that establishes the
identity of the record over time - it is a surrogate for the real world
thing that the tuple represents.  Therefore the thing that is chosen to be
the primary key should be a property that is invariant.  If you choose a
property to act as primary key that is not invariant you have two problems.
Firstly the need that you have already identified to update foreign keys
that you know about in order to update them.  Secondly, you have the problem
that you do not necessarily know about other uses of the key - information
may already have been sent on to other systems, which leaves you with the
problem of making references over time to something with no firm identity.

Regards
Chris

-----Original Message-----
From: Rick Marshall [mailto:rjm@z...]
Sent: 26 August 2003 16:32
To: Chris Angus
Cc: michael.h.kay@n...; xml-dev@l...
Subject: RE:  A standard approach to glueing together
reusableXMLfragments in prose?


chris

ok, shoot the example - that's why most use customer numbers. however it
shouldn't be necessary if the name is a primary key - in fact the
customer number and name then become candidate keys and you have to
select one as the primary key - redundant and not normalised properly :(

i coined my terminology around 1980 .....

cheers

rick

• References:
  • RE: A standard approach to glueing together reusableXMLfragments in prose?
    • From: Rick Marshall <rjm@z...>

• Prev by Date: Re: XPath brain teaser
• Next by Date: RE: A standard approach to glueing together reusableXML fragments in prose?
• Previous by thread: RE: A standard approach to glueing together reusableXMLfragments in prose?
• Next by thread: RE: A standard approach to glueing together reusableXML fragments in prose?
• Index(es):
  • Date
  • Thread