Re: A Normalization Question

> Because you're still confusing physical and logical
> redundancy. And ironically, you're dragging normalization
> down to physical storage, yet you're referring to it
> as a "higher" form of normalization.

Having the same person three times in a db is redundant. Having the same string three times in a db is redundant. Having the same thing three times in a db is redundant.

One is having difficulty realizing that a person and a string are both things (ie data, fact, entity, etc).

Below is approximately how XDb1 normalizes the three strings:

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

Note, there are no tables in XDb1, only things. However certain groups of things can be viewed as a list, tree, table, matrix, etc. Received on Thu Jul 08 2004 - 22:47:02 CDT