Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpolation


"Cimode" <cimode@xxxxxxxxxxx> wrote in message
news:1177938789.949723.62480@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 30, 1:56 pm, "Brian Selzer" <b...@xxxxxxxxxxxxxxxxxxx> wrote:
"Cimode" <cim...@xxxxxxxxxxx> wrote in message
[Snipped]
I'm not sure I understand you. Missing information is a problem
independent
of any implementation.
Sure but NULL is only one way to handle missing information and it is
one that does not fall into 2VL required by RM.

Why does NULL not fit into 2VL? I've never propoerly understood this.

In practice, I've been willing to use NULLS in databases rather than
decompose tables to eliminate the need for NULLS. And I've tended to avoid
SQL 3VL, by forumlating my queries carefully.

But I've never fully studied the question. Once you accept NULLS as (one
way) of dealing with missing data, are you then forced, willy nilly, into
3VL for your DML? It's not obvious to me, even though that's what SQL did.



.

Relevant Pages

  • Re: All hail Neo!
    ... Bags and nulls are quite apparently not but from where I am now the null at least seems the lesser of evils viz my post in the "beautiful mind" thread. ... With null or without logical identity, ... If the practitioner never considers where the pitfalls lie, he will only discover them from the bottom of the pit. ... They have correctly identified that missing information as of yet has no theory to address it. ...
    (comp.databases.theory)
  • Re: Why does 1:3 relationsihp require another table?
    ... practically difficult if not impossible and that is why NULLs or any such ... If representation of unknown value is the idea behind the ... implementation of NULLs in SQL, then SQL avoids far too many kinds of ... By assuming support for just one kind of missing information (Unknown value ...
    (microsoft.public.sqlserver.programming)
  • Re: Date, Darwen, Pascal and the alternative to Nulls in the RM
    ... books seem to have stronger and stronger proscriptions against nulls, ... and fewer and fewer ideas about how to handle missing information. ... The only way to avoid nulls is to avoid change management. ... of specific data integrity exceptions, ...
    (comp.databases.theory)
  • Re: Examples of SQL anomalies?
    ... If you don't spend enough time on design, ... NULLs are only one way to deal with missing information. ... I tend to believe that interpretation of the meaning of data should be ...
    (comp.databases.theory)
  • Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
    ... Sure but NULL is only one way to handle missing information and it is ... decompose tables to eliminate the need for NULLS. ... even though that's what SQL did. ... there at design time only but the advantages ...
    (comp.databases.theory)