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

Re: Primary and Foreign Keys

• From: Ronald Bourret <rpbourret@r...>
• To: xml-dev <xml-dev@l...>
• Date: Tue, 24 Jul 2001 23:03:55 -0700

"Thomas B. Passin" wrote:

> Another situation would arise if a table is a "join" table (Mike Gorman's
> term is more charming, though: "intertwinkle" table).  That generally means
> a many-to-many relationship.  The primary key for a join table is usually
> compound, which leaves ID/IDRef out unless you use two of them in each
> element.

I like intertwinkle.

Many-to-many relationships cause a special problem with nesting. When
using a canonical object-relational mapping, they result in an extra
element (representing the join row) between the elements corresponding
to the joined rows. This element usually needs to be removed by XSLT or
by smarts in the data transfer software.

-- Ron

• References:
  • Primary and Foreign Keys
    • From: "Bullard, Claude L (Len)" <clbullar@i...>
  • Re: Primary and Foreign Keys
    • From: "Thomas B. Passin" <tpassin@h...>

• Prev by Date: Re: Primary and Foreign Keys
• Next by Date: Re: Primary and Foreign Keys
• Previous by thread: Re: Primary and Foreign Keys
• Next by thread: Re: Primary and Foreign Keys
• Index(es):
  • Date
  • Thread