Re: A Normalization Question
Date: 8 Jul 2004 20:47:02 -0700
Message-ID: <4b45d3ad.0407081947.37c553f9_at_posting.google.com>
> 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 Fri Jul 09 2004 - 05:47:02 CEST