Re: WWW/Internet 2009: 2nd CFP until 21 September x
Date: Wed, 19 Aug 2009 03:46:42 GMT
Message-ID: <CAKim.2731$nh2.2036_at_nwrddc02.gnilink.net>
"Mr. Scott" <do_not_reply_at_noone.com> wrote in message
news:i5WdnRK1WL_HaRfXnZ2dnUVZ_qudnZ2d_at_giganews.com...
>
>> solution to be a materialized outer join gives a way of conceptualizing
>> the two tables, where no NULLS are necessary or permitted. It also cuts
>> back on the proliferation of tables. I'm all for decomposing tables when
>> it will really do some good, but there's no need to make a religious
>> ritual of it.
>
> I'm now wondering if there are really three kinds of null. There is the
> applicable null, which when submitted in an update indicates 'I know there
> is supposed to be a value here but I don't know what it is,' there is the
> inapplicable null, which when submitted in an update indicates 'I know
> there is not supposed to be a value here,' and now there is the
> I-don't-have-a-clue null, which when submitted in an update indicates 'I
> don't know if there is supposed to be a value here.' In order to simulate
> the I-don't-have-a-clue null that can be in your Employee table, your
> Employee_Middle_Initial table has to have the open world interpretation,
> so that whenever a row is missing it indicates that either there should be
> a value here but it is at present unknown or that there shouldn't be a
> value here.
>
The difference between these three kinds of nulls (and the other seventeen kinds of nulls) is not in what the null says about the real world. It''s all about the state of mind of the writer. Reread what you've written here... it's all about the narrator knows or doesn't know or doesn't have a clue about.
So what does a null say about the real world? Nothing.
That's beyond the scope of the point I was trying to make. My point was just that if you think of a table containing nulls as a materialized outer join, it can help you to avoid getting all balled up in SQL's three valued logic and like that. Received on Wed Aug 19 2009 - 05:46:42 CEST