Re: Is Ingres yet relational?

On Thu, 27 May 2004 13:20:32 -0300, Leandro Guimaraens Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm> wrote:

>Em Thu, 27 May 2004 08:12:19 -0700, Alfredo Novoa escreveu:
>
>>> Indeed, but their existence, and that of SQL access,
>>> inherently hinders optimisation.
>>
>> I disagree. It makes optimization more difficult but you can use
>> different algorithms when you know that nulls and duplicates are not
>> allowed.
>
> That's what I said.

I misunderstood you. But I don't know any SQL DBMSs that take advantage on the possible optimization when the attributes are not nullable.

>> It would be a good possiblity if you know very well the source code of
>> Ingres. If not, probably it would be easier to start from scratch,
>> specially if you want to have decent physical independence.
>
> Perhaps. But then I think you have the cardinal virtue of the
>programmer, hubris.

Probably, but programmers hate to read the code of other programmers.

Regards
  Alfredo Received on Fri May 28 2004 - 13:11:06 CEST