Re: Relation problem

From: Jan Hidders <hidders_at_REMOVE.THIS.win.tue.nl>
Date: 23 Jan 2001 12:25:06 GMT
Message-ID: <94jt72$462$1_at_news.tue.nl>


Kristian Damm Jensen wrote:
> Jan Hidders wrote:
> > Kristian Damm Jensen wrote:
> > >
> > > What can be avoided is some of the performance problems. Without
> > > the supertype referential integrity from Adresses to Individuals
> > > and Organizations can not be maintained using an index. With
> > > Parties it can.
> > >
> > > Ah, you say, but then you will just move the problem on to
> > > maintaing referential integrity between Parties and
> > > Individuals/Organizations. But as this will not be updated (!)
> > > the is reduced to deletion and insertion, which I believe will
> > > happen much more infrequently.
> >
> > Very good point and you might be right about the number of updates.
> > But it may depend upon the type of organizaton that you are dealing
> > with. In some organizations clients come and go, in others they
> > stick with the same supplier for years.
>
> But even so, that will either be deletes and inserts or it will be
> updates of attributes and thus not affecting the referential
> integrity.

I am not sure I understand this. If an organization is deleted/inserted then you also have to delete/insert it in the Parties table, otherwise referential integrity is compromised.

-- 
  Jan Hidders
Received on Tue Jan 23 2001 - 13:25:06 CET

Original text of this message