Re: Primary and Foreign Keys

["Thomas B. Passin" <tpassin@home.com>]

[Ronald Bourret]


>
> 6) Leave the key value out of the XML document. This requires that
> nesting is used to indicate key relationships and makes sense when: (a)
> key values are generated by the database, and (b) the data is being
> transferred to a different database. Such values not guaranteed to be
> unique in the second database.
>

I almost included this thought in my post, but didn't because it occurred to
me that even if you nested a child entity within a parent, you might still
need to refer to it from somewhere else rather than duplicate its data.  So
it seemed that eliminating the ID and nesting could be orthogonal.  A
case-by-case decision, methinks.

Cheers,

Tom P