Re: Concurrency in an RDB - another question about recursive definitions

paul c wrote:

> Bob Badour wrote:
>

>> paul c wrote:
>> ...
>>
>>> Given relation : B = { {a,b} | a in A and b in B } /* Using C-style 
>>                                                  ^
>>                                                  |
>> Relations are not domains -----------------------/

Let's just say confusing a relation with a domain is a blunder. Using the same name to refer to a relation and a domain is not necessarily a blunder provided everyone agrees that relations and domains with the same name are not the same thing.

Consider a system with Person, Name, Date and Integer domains. Might the following compile?

CREATE RELATION Person (

   Person Person

, Name Name
, DOB Date
, #Dependents Integer

It might compile provided the language can always contextually distinguish between relation names, attribute names and domain names. Would it be a good idea to create such a relation? That's a matter of opinion.

>> One can describe the extent of a domain as a relation.
>> The extent of domain B is infinite.
>> ...

It is no more or less static than the domain Integer. I agree it should go without saying; however, it should be said if necessary or helpful. Received on Sun Jan 21 2007 - 18:43:03 CET