Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 8 Jul 2004 21:20:10 -0700
Message-ID: <4b45d3ad.0407082020.6735f7e9_at_posting.google.com>


> There is only redundancy if one of them can be ignored
> without loss of information. You cannot.

Below is approximately how XDb1 ignores the redundant "brown" strings that were in the place of ->2, ->3 and ->4 without loss of information. The person, color and street in tuple1 are not redundant, the string that names them was.

Thing Person Color Street
1 ->2 ->3 ->4

Person Name
2 ->5

Color Name
3 ->5

Street Name
4 ->5

String Sym1 Sym2 Sym3 Sym4 Sym5 ....
5 ->6, ->7, ->8, ->9, ->10

Symbol

6      b
7      r
8      o
9      w
10     n
Received on Fri Jul 09 2004 - 06:20:10 CEST

Original text of this message