Re: A Normalization Question

Neo wrote:

>>You'll have to explain why storing "brown" three times is redundant, 
>>while storing ->5 three times is okay.

You could say that the string "brown" is a reference to the actual colour brown. Or the string "Brown" is a reference to the surname Brown.

This is where the database's knowledge ends and the human mind begins; the jump from syntax to semantics.

Redundancy in terms of databases is about removing semantic duplicates, not about removing syntactic duplicates. i.e. about the logical level, not the physical level.

I think the type of redundancy you're talking about is more lower-level like information theory, Huffman coding etc.: http://en.wikipedia.org/wiki/Information_theory

It sounds like you're trying to roll these two concepts into one when it's more powerful and useful to have them separate.

Paul. Received on Thu Jul 08 2004 - 10:48:14 CEST