OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Primary and Foreign Keys

"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