Re: database systems and organizational intelligence

From: x <x-false_at_yahoo.com>
Date: Thu, 27 May 2004 17:45:55 +0300
Message-ID: <40b5fe44$1_at_post.usenet.com>


  • Post for FREE via your newsreader at post.usenet.com ****

"Laconic2" <laconic2_at_comcast.net> wrote in message news:BdydnYyQb8hHbijdRVn-gg_at_comcast.com...
>
> "Alfredo Novoa" <alfredo_at_ncs.es> wrote in message
> news:40b5be6c.187579_at_news.wanadoo.es...
>
> > You can represent a tree with a relation. There is no problem.
>
> You can represent a relation with a tree. I don't understand your point.
>
>
> > I disagree. Optimizer compilers are here since a while. If you
> > translate the optimized syntax trees into code you will have
> > normalized code.
>
> The word "normalized" can apparently mean many things.
>
> My first exposure to this word was in the processor manuals description
of
> floating point arithmetic.
>
> In particular, there were synonyms among the floating point
representations.
> That is, different representations for the same number. Of these, one of
> them was chosen as the "normalized" representation. It was the one whose
> fraction had a high order bit that was different from the sign bit, or
> something like that. And there was an operator called the "unnormalized
> floating add" that would add to floating point operands, but not
normalize
> the result.
>
> I think of the above definition as utterly unconnected to the meaning that
> Codd gave for "normal form of data" in the original paper. And I have
yet
> to see a definition that legitimately revises that definition. Normal
> forms beyond 1NF extend 1NF, but do not revise 1NF.

Citation from Codd 1970 ACM paper:

In order to discuss a preferred way (or normal form), we must first introduce a few additional concepts (active domain, primary key, foreign key, nonsimple domain) and establish some links with terminology currently in use in information systems programming.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

  • Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Thu May 27 2004 - 16:45:55 CEST

Original text of this message