Re: foreign key constraint versus referential integrity constraint

From: Cimode <cimode_at_hotmail.com>
Date: Wed, 28 Oct 2009 13:17:19 -0700 (PDT)
Message-ID: <b3da0599-c65d-43cd-81a2-1eeab859d7a6_at_z4g2000prh.googlegroups.com>


Snipped

> If I recall it

> wasn't until his second paper that he introduced the pair of attribute
> and domain name, he was adjusting his theory to meet practice.
Precisely.

As for the headers being less relevant in the context of domain analysis, I meant that domain analysis clearly focuses on the body of each un-ary relation being primarily a domain subset (*before* relation level constraints are applied; I use the term with great caution !) to be considered an attribute of a specific relation. It is only once domain requirements are met that the assignment of a specific header defines the attribute (then the header set defining the relation).

My observation is that a lot of work has been done into defining relations in order to algebrically operate them as relations but very little has been done to use domains to clarify relational algebra. `
My conclusion is that the relational consensus that constraint specialization through domain analysis could be in any way orthogonal to relation structural definitions restricts the possibility of clarifying further relational model operations and implementations.

But that is only my opinion.

Regards... Received on Wed Oct 28 2009 - 21:17:19 CET

Original text of this message